validate-migrations.yml

name: Validate Prisma migrations
on:
  pull_request:
    paths:
      - packages/database/prisma/**
  push:
    branches:
      - main
    paths:
      - packages/database/prisma/**
  merge_group:
    paths:
      - packages/database/prisma/**

jobs:
  validate-migrations:
    runs-on: ubuntu-latest
    env:
      DATABASE_URL: postgresql://postgres:postgres@localhost:5432/postgres
    services:
      postgres:
        image: postgres:14
        env:
          POSTGRES_PASSWORD: postgres
        options: >-
          --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
        ports:
          - 5432:5432
    steps:
      - name: Check out code
        uses: actions/checkout@v4

      - uses: pnpm/action-setup@v4
        name: Install pnpm
        with:
          run_install: false

      - name: Install Node.js
        uses: actions/setup-node@v4
        with:
          node-version: 22
          cache: 'pnpm'

      - name: Install dependencies
        run: pnpm install

      - name: Check if prisma migration is updated
        run: |-
          cd packages/database
          pnpm prisma migrate diff --exit-code \
            --from-migrations prisma/migrations \
            --to-schema-datamodel prisma/schema.prisma \
            --shadow-database-url ${{env.DATABASE_URL}}