Raw project query #283

	name: Ensure Prisma migrations are in sync with the schema

	on:
	push:
	branches:
	- dev
	- main
	pull_request:
	branches:
	- dev
	- main

	jobs:
	check_prisma_migrations:
	runs-on: ubuntu-latest

	strategy:
	matrix:
	node-version: [22.x]

	steps:
	- uses: actions/checkout@v3

	- name: Setup Node.js ${{ matrix.node-version }}
	uses: actions/setup-node@v3
	with:
	node-version: ${{ matrix.node-version }}

	- name: Setup pnpm
	uses: pnpm/action-setup@v3
	with:
	version: 9.1.2

	- name: Install dependencies
	run: pnpm install --frozen-lockfile

	- name: Start Postgres shadow DB
	run: docker run -d --name postgres-prisma-diff-shadow -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=PLACEHOLDER-PASSWORD--dfaBC1hm1v -e POSTGRES_DB=postgres -p 5432:5432 postgres:latest

	- name: Check for differences in Prisma schema and migrations
	run: pnpm run prisma migrate diff --from-migrations ./prisma/migrations --to-schema-datamodel ./prisma/schema.prisma --shadow-database-url postgres://postgres:PLACEHOLDER-PASSWORD--dfaBC1hm1v@localhost:5432/postgres --exit-code

Provide feedback