Repository navigation
339 lines (304 loc) · 10.8 KB
/
Copy pathextended-db-tests.yml
File metadata and controls
339 lines (304 loc) · 10.8 KB
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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
name: Nightly — full E2E + extended DB
on:
workflow_dispatch:
workflow_call:
inputs:
checkout_sha:
required: false
default: ""
type: string
select_jobs_explicitly:
description: "Honor run_* inputs instead of running the complete direct-dispatch matrix"
required: false
default: false
type: boolean
run_e2e_postgres:
required: false
default: true
type: boolean
run_e2e_mysql:
required: false
default: true
type: boolean
run_db_contract_postgres:
required: false
default: true
type: boolean
run_db_contract_mysql:
required: false
default: true
type: boolean
schedule:
# Nightly (UTC)
- cron: "0 4 * * *"
concurrency:
group: ${{ github.workflow }}-${{ github.ref }}
# Keep the active failure collector intact; a newer scheduled/manual request may wait.
cancel-in-progress: false
jobs:
ui-e2e-nightly:
if: ${{ github.event_name == 'schedule' && github.repository == 'happier-dev/happier' }}
name: Full UI E2E nightly
permissions:
contents: read
pull-requests: read
actions: read
uses: ./.github/workflows/tests.yml
with:
select_jobs_explicitly: true
run_ui_e2e: true
run_ui: false
run_shared_packages: false
run_server: false
run_server_db_contract: false
run_cli: false
run_stack: false
run_typecheck: false
run_cli_daemon_e2e: false
run_e2e_core: false
run_installers_smoke: false
run_binary_smoke: false
e2e-postgres:
if: ${{ (github.event_name != 'schedule' || github.repository == 'happier-dev/happier') && (!inputs.select_jobs_explicitly || inputs.run_e2e_postgres) }}
name: Core E2E (Postgres)
runs-on: ubuntu-22.04
timeout-minutes: 120
services:
postgres:
image: postgres:17
env:
POSTGRES_DB: happier
POSTGRES_USER: happier
POSTGRES_PASSWORD: happier
ports:
- 5432/tcp
options: >-
--health-cmd="pg_isready -U happier -d happier"
--health-interval=10s
--health-timeout=5s
--health-retries=10
steps:
- name: Checkout
uses: actions/checkout@11d5960a326750d5838078e36cf38b85af677262
with:
ref: ${{ inputs.checkout_sha || github.sha }}
- name: Setup Node
uses: actions/setup-node@49933ea5288caeca8642d1e84afbd3f7d6820020
with:
node-version: 22.x
cache: yarn
cache-dependency-path: yarn.lock
- name: Enable Corepack
uses: ./.github/actions/enable-corepack-yarn
- name: Install system dependencies
run: |
set -euo pipefail
sudo apt-get update
sudo apt-get install -y --no-install-recommends tmux
tmux -V
- name: Install Sapling
run: |
bash scripts/ci/install_sapling_ubuntu22.sh
- name: Verify Sapling CLI
run: sl --version
- name: Install dependencies
env:
YARN_PRODUCTION: "false"
npm_config_production: "false"
uses: ./.github/actions/install-yarn-dependencies
with:
args: --frozen-lockfile --ignore-engines
- name: Generate server provider client (postgres)
env:
HAPPIER_BUILD_DB_PROVIDERS: postgres
DATABASE_URL: postgresql://happier:happier@127.0.0.1:${{ job.services.postgres.ports[5432] }}/happier?sslmode=disable
run: yarn -s workspace @happier-dev/server generate:providers
- name: Run core e2e database suite (postgres)
env:
CI: "1"
HAPPIER_E2E_SAVE_ARTIFACTS: "0"
HAPPIER_E2E_DB_PROVIDER: postgres
HAPPIER_E2E_PROVIDER_SKIP_SERVER_GENERATE: "1"
DATABASE_URL: postgresql://happier:happier@127.0.0.1:${{ job.services.postgres.ports[5432] }}/happier?sslmode=disable
run: yarn test:e2e:core:fast -- --no-file-parallelism --maxWorkers=1 --minWorkers=1
- name: Upload e2e diagnostics (on failure)
if: failure()
uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02
with:
name: extended-e2e-postgres-diagnostics
retention-days: 7
if-no-files-found: ignore
path: |
.project/logs/e2e/**/*.log
.project/logs/e2e/**/*.json
.project/logs/e2e/**/*.jsonl
.project/logs/e2e/**/*.txt
e2e-mysql:
if: ${{ (github.event_name != 'schedule' || github.repository == 'happier-dev/happier') && (!inputs.select_jobs_explicitly || inputs.run_e2e_mysql) }}
name: Core E2E (MySQL)
runs-on: ubuntu-22.04
timeout-minutes: 120
services:
mysql:
image: mysql:8.0
env:
MYSQL_ROOT_PASSWORD: happier
MYSQL_DATABASE: happier
ports:
- 3306/tcp
options: >-
--health-cmd="mysqladmin ping -h 127.0.0.1 -u root -p${MYSQL_ROOT_PASSWORD}"
--health-interval=10s
--health-timeout=5s
--health-retries=15
steps:
- name: Checkout
uses: actions/checkout@11d5960a326750d5838078e36cf38b85af677262
with:
ref: ${{ inputs.checkout_sha || github.sha }}
- name: Setup Node
uses: actions/setup-node@49933ea5288caeca8642d1e84afbd3f7d6820020
with:
node-version: 22.x
cache: yarn
cache-dependency-path: yarn.lock
- name: Enable Corepack
uses: ./.github/actions/enable-corepack-yarn
- name: Install system dependencies
run: |
set -euo pipefail
sudo apt-get update
sudo apt-get install -y --no-install-recommends tmux
tmux -V
- name: Install Sapling
run: |
bash scripts/ci/install_sapling_ubuntu22.sh
- name: Verify Sapling CLI
run: sl --version
- name: Install dependencies
env:
YARN_PRODUCTION: "false"
npm_config_production: "false"
uses: ./.github/actions/install-yarn-dependencies
with:
args: --frozen-lockfile --ignore-engines
- name: Generate server provider client (mysql)
env:
HAPPIER_BUILD_DB_PROVIDERS: mysql
DATABASE_URL: mysql://root:happier@127.0.0.1:${{ job.services.mysql.ports[3306] }}/happier
run: yarn -s workspace @happier-dev/server generate:providers
- name: Run core e2e database suite (mysql)
env:
CI: "1"
HAPPIER_E2E_SAVE_ARTIFACTS: "0"
HAPPIER_E2E_DB_PROVIDER: mysql
HAPPIER_E2E_PROVIDER_SKIP_SERVER_GENERATE: "1"
DATABASE_URL: mysql://root:happier@127.0.0.1:${{ job.services.mysql.ports[3306] }}/happier
run: yarn test:e2e:core:fast -- --no-file-parallelism --maxWorkers=1 --minWorkers=1
- name: Upload e2e diagnostics (on failure)
if: failure()
uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02
with:
name: extended-e2e-mysql-diagnostics
retention-days: 7
if-no-files-found: ignore
path: |
.project/logs/e2e/**/*.log
.project/logs/e2e/**/*.json
.project/logs/e2e/**/*.jsonl
.project/logs/e2e/**/*.txt
db-contract-postgres:
if: ${{ (github.event_name != 'schedule' || github.repository == 'happier-dev/happier') && (!inputs.select_jobs_explicitly || inputs.run_db_contract_postgres) }}
name: DB Contract (Postgres)
runs-on: ubuntu-latest
timeout-minutes: 120
services:
postgres:
image: postgres:17
env:
POSTGRES_DB: happier
POSTGRES_USER: happier
POSTGRES_PASSWORD: happier
ports:
- 5432/tcp
options: >-
--health-cmd="pg_isready -U happier -d happier"
--health-interval=10s
--health-timeout=5s
--health-retries=10
steps:
- name: Checkout
uses: actions/checkout@11d5960a326750d5838078e36cf38b85af677262
with:
ref: ${{ inputs.checkout_sha || github.sha }}
- name: Setup Node
uses: actions/setup-node@49933ea5288caeca8642d1e84afbd3f7d6820020
with:
node-version: 22.x
cache: yarn
cache-dependency-path: yarn.lock
- name: Enable Corepack
uses: ./.github/actions/enable-corepack-yarn
- name: Install dependencies
env:
YARN_PRODUCTION: "false"
npm_config_production: "false"
uses: ./.github/actions/install-yarn-dependencies
with:
args: --frozen-lockfile --ignore-engines
- name: Migrate (Postgres)
env:
DATABASE_URL: postgresql://happier:happier@127.0.0.1:${{ job.services.postgres.ports[5432] }}/happier?sslmode=disable
run: yarn --cwd apps/server -s prisma migrate deploy
- name: Run db contract suite (Postgres)
env:
HAPPIER_DB_PROVIDER: postgres
DATABASE_URL: postgresql://happier:happier@127.0.0.1:${{ job.services.postgres.ports[5432] }}/happier?sslmode=disable
run: yarn --cwd apps/server test:db-contract
db-contract-mysql:
if: ${{ (github.event_name != 'schedule' || github.repository == 'happier-dev/happier') && (!inputs.select_jobs_explicitly || inputs.run_db_contract_mysql) }}
name: DB Contract (MySQL)
runs-on: ubuntu-latest
timeout-minutes: 120
services:
mysql:
image: mysql:8.0
env:
MYSQL_ROOT_PASSWORD: happier
MYSQL_DATABASE: happier
ports:
- 3306/tcp
options: >-
--health-cmd="mysqladmin ping -h 127.0.0.1 -u root -p${MYSQL_ROOT_PASSWORD}"
--health-interval=10s
--health-timeout=5s
--health-retries=15
steps:
- name: Checkout
uses: actions/checkout@11d5960a326750d5838078e36cf38b85af677262
with:
ref: ${{ inputs.checkout_sha || github.sha }}
- name: Setup Node
uses: actions/setup-node@49933ea5288caeca8642d1e84afbd3f7d6820020
with:
node-version: 22.x
cache: yarn
cache-dependency-path: yarn.lock
- name: Enable Corepack
uses: ./.github/actions/enable-corepack-yarn
- name: Install dependencies
env:
YARN_PRODUCTION: "false"
npm_config_production: "false"
uses: ./.github/actions/install-yarn-dependencies
with:
args: --frozen-lockfile --ignore-engines
- name: Migrate (MySQL)
env:
DATABASE_URL: mysql://root:happier@127.0.0.1:${{ job.services.mysql.ports[3306] }}/happier
run: yarn --cwd apps/server -s migrate:mysql:deploy
- name: Run db contract suite (MySQL)
env:
HAPPIER_DB_PROVIDER: mysql
DATABASE_URL: mysql://root:happier@127.0.0.1:${{ job.services.mysql.ports[3306] }}/happier
run: yarn --cwd apps/server test:db-contract