chore: validate schema file on ci

sweatybridge · sweatybridge · commit ba3e0e2c53db · 2022-10-26T15:24:58.000+08:00
diff --git a/.github/workflows/test.yml b/.github/workflows/test.yml
@@ -80,3 +80,16 @@ jobs:
           PGPORT: 5478
           PGUSER: postgres
           PGPASSWORD: ${{ env.POSTGRES_PASSWORD }}
+
+  schema:
+    runs-on: ubuntu-latest
+    steps:
+      - uses: actions/checkout@v3
+      - name: verify schema.sql is committed
+        run: |
+          docker compose up db dbmate --abort-on-container-exit
+          if ! git diff --ignore-space-at-eol --exit-code --quiet migrations/schema.sql; then
+            echo "Detected uncommitted changes after build. See status below:"
+            git diff
+            exit 1
+          fi
diff --git a/migrations/.env b/migrations/.env
@@ -0,0 +1,2 @@
+POSTGRES_PASSWORD=password
+DATABASE_URL="postgres://postgres:${POSTGRES_PASSWORD}@localhost:5478/postgres?sslmode=disable"
diff --git a/migrations/db/migrations/100000022_test.sql b/migrations/db/migrations/100000022_test.sql
diff --git a/migrations/docker-compose.yaml b/migrations/docker-compose.yaml
@@ -45,3 +45,14 @@ services:
     volumes:
       - ./tests:/tests
     command: pg_prove /tests/test.sql
+
+  dbmate:
+    image: ghcr.io/amacneil/dbmate:1
+    depends_on:
+      db:
+        condition: service_healthy
+    volumes:
+      - ./schema.sql:/db/schema.sql
+    environment:
+      DATABASE_URL: postgres://supabase_admin:${POSTGRES_PASSWORD}@db/postgres?sslmode=disable
+    command: dump
diff --git a/migrations/schema.sql b/migrations/schema.sql
@@ -991,24 +991,3 @@ CREATE EVENT TRIGGER pgrst_drop_watch ON sql_drop
 -- Dbmate schema migrations
 --
 
-INSERT INTO public.schema_migrations (version) VALUES
-    ('00000000000000'),
-    ('00000000000001'),
-    ('00000000000002'),
-    ('00000000000003'),
-    ('10000000000000'),
-    ('20211115181400'),
-    ('20211118015519'),
-    ('20211122051245'),
-    ('20211124212715'),
-    ('20211130151719'),
-    ('20220118070449'),
-    ('20220126121436'),
-    ('20220224211803'),
-    ('20220317095840'),
-    ('20220321174452'),
-    ('20220322085208'),
-    ('20220404205710'),
-    ('20220609081115'),
-    ('20220613123923'),
-    ('20220713082019');

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+POSTGRES_PASSWORD=password`
	`2`	`+DATABASE_URL="postgres://postgres:${POSTGRES_PASSWORD}@localhost:5478/postgres?sslmode=disable"`