db.yml

name: Migrate DB
on:
  push:
    paths:
      - packages/database/prisma/migrations/**
    branches:
      - main

jobs:
  deploy:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout repo
        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'
      - run: pnpm install
      - name: Apply migrations to STAGING
        run: |
          cd packages/database
          pnpm prisma migrate deploy
        env:
          PRISMA_DB_URL: ${{ secrets.STAGING_DATABASE_URL }}
      - name: Apply migrations to PRODUCTION
        run: |
          cd packages/database
          pnpm prisma migrate deploy
        env:
          PRISMA_DB_URL: ${{ secrets.PRODUCTION_DATABASE_URL }}