migration.yml

name: migrate

on:
  push:
    branches:
      - main

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

jobs:
  setup:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v6
      - name: Set up Node.js
        uses: actions/setup-node@v6
        with:
          node-version: "24"
      - name: Enable Corepack
        run: corepack enable
      - name: Cache
        uses: actions/cache@v4
        id: cache-files
        with:
          path: |
            **/node_modules
          key: ${{ runner.os }}-cache-${{ hashFiles('**/yarn.lock') }}
      - name: Install Dependencies
        if: ${{ steps.cache-files.outputs.cache-hit != 'true' }}
        run: yarn install --mode=skip-build
      - name: Generate Prisma Client
        run: yarn prisma generate

  migrate-for-production:
    environment: production
    if: github.ref_name == 'main'
    needs: setup
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v6
      - uses: actions/setup-node@v6
        with:
          node-version: "24"
      - name: Enable Corepack
        run: corepack enable
      - name: Restore cache
        uses: actions/cache/restore@v4
        with:
          path: |
            **/node_modules
          key: ${{ runner.os }}-cache-${{ hashFiles('**/yarn.lock') }}
      - name: Create .env
        shell: bash
        run: |
          printf "DATABASE_URL=\"%s\"\nDIRECT_URL=\"%s\"\n" \
            "${{ secrets.DATABASE_URL_FOR_MIGRATION }}" \
            "${{ secrets.DIRECT_URL }}" > .env
      - name: Generate Prisma Client
        run: yarn prisma generate
      - name: Generate Schema
        run: yarn schema:gen
      - name: Migrate
        uses: nick-fields/retry@v3
        with:
          command: yarn migrate-for-single
          max_attempts: 5
          timeout_minutes: 10
          retry_on: error