forked from n8n-io/n8n
-
Notifications
You must be signed in to change notification settings - Fork 0
142 lines (125 loc) · 3.59 KB
/
ci-postgres-mysql.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
name: Test Postgres and MySQL schemas
on:
schedule:
- cron: '0 0 * * *'
workflow_dispatch:
pull_request:
paths:
- packages/cli/src/databases/**
concurrency:
group: db-${{ github.event.pull_request.number || github.ref }}
cancel-in-progress: true
jobs:
build:
name: Install & Build
runs-on: ubuntu-latest
steps:
- uses: actions/[email protected]
- run: corepack enable
- uses: actions/[email protected]
with:
node-version: 18.x
cache: 'pnpm'
- run: pnpm install --frozen-lockfile
- name: Build Backend
run: pnpm build:backend
- name: Cache build artifacts
uses: actions/cache/[email protected]
with:
path: ./packages/**/dist
key: ${{ github.sha }}:db-tests
sqlite-pooled:
name: SQLite Pooled
runs-on: ubuntu-latest
needs: build
timeout-minutes: 20
env:
DB_TYPE: sqlite
DB_SQLITE_POOL_SIZE: 4
steps:
- uses: actions/[email protected]
- run: corepack enable
- uses: actions/[email protected]
with:
node-version: 18.x
cache: 'pnpm'
- run: pnpm install --frozen-lockfile
- name: Restore cached build artifacts
uses: actions/cache/[email protected]
with:
path: ./packages/**/dist
key: ${{ github.sha }}:db-tests
- name: Test SQLite Pooled
working-directory: packages/cli
run: pnpm jest --coverage
mysql:
name: MySQL
runs-on: ubuntu-latest
needs: build
timeout-minutes: 20
env:
DB_MYSQLDB_PASSWORD: password
steps:
- uses: actions/[email protected]
- run: corepack enable
- uses: actions/[email protected]
with:
node-version: 18.x
cache: 'pnpm'
- run: pnpm install --frozen-lockfile
- name: Restore cached build artifacts
uses: actions/cache/[email protected]
with:
path: ./packages/**/dist
key: ${{ github.sha }}:db-tests
- name: Start MySQL
uses: isbang/[email protected]
with:
compose-file: ./.github/docker-compose.yml
services: |
mysql
- name: Test MySQL
working-directory: packages/cli
run: pnpm test:mysql
postgres:
name: Postgres
runs-on: ubuntu-latest
needs: build
timeout-minutes: 20
env:
DB_POSTGRESDB_PASSWORD: password
steps:
- uses: actions/[email protected]
- run: corepack enable
- uses: actions/[email protected]
with:
node-version: 18.x
cache: 'pnpm'
- run: pnpm install --frozen-lockfile
- name: Restore cached build artifacts
uses: actions/cache/[email protected]
with:
path: ./packages/**/dist
key: ${{ github.sha }}:db-tests
- name: Start Postgres
uses: isbang/[email protected]
with:
compose-file: ./.github/docker-compose.yml
services: |
postgres
- name: Test Postgres
working-directory: packages/cli
run: pnpm test:postgres
notify-on-failure:
name: Notify Slack on failure
runs-on: ubuntu-latest
needs: [mysql, postgres]
steps:
- name: Notify Slack on failure
uses: act10ns/[email protected]
if: failure() && github.ref == 'refs/heads/master'
with:
status: ${{ job.status }}
channel: '#alerts-build'
webhook-url: ${{ secrets.SLACK_WEBHOOK_URL }}
message: Postgres or MySQL tests failed (${{ github.server_url }}/${{ github.repository }}/actions/runs/${{ github.run_id }})