eldridge.cam
Trading card city builder game?
1name: SQL CI
2on: push
3
4env:
5 DATABASE_URL: "postgresql://postgres:postgres@localhost/cartography"
6 SHADOW_DATABASE_URL: "postgresql://postgres:postgres@localhost/shadow"
7 ROOT_DATABASE_URL: "postgresql://postgres:postgres@localhost/postgres"
8
9jobs:
10 migrate:
11 runs-on: ubuntu-latest
12 services:
13 postgres:
14 image: postgres:18
15 env:
16 POSTGRES_PASSWORD: postgres
17 POSTGRES_DB: cartography
18 ports:
19 - 5432:5432
20 options: >-
21 --health-cmd pg_isready
22 --health-interval 10s
23 --health-timeout 5s
24 --health-retries 5
25 steps:
26 - name: Checkout code
27 uses: actions/checkout@v4
28 - name: Install Node.js
29 uses: actions/setup-node@v4
30 with:
31 cache: npm
32 node-version-file: app/.node-version
33 cache-dependency-path: app/package-lock.json
34 - name: Check status
35 run: npx graphile-migrate status --skipDatabase
36 - name: Run migrate
37 run: npx graphile-migrate migrate