name: Check Migrations

on:
  push:
    branches: [ main ]
  pull_request:
    branches: [ '*' ]
  # Required by the merge queue: the queue builds a temporary `merge_group` ref
  # (PR rebased onto the latest main) and waits for this check to report on it.
  # Without this trigger the check never runs for queued PRs and the queue stalls.
  merge_group:

jobs:
  check-duplicate-numbers:
    name: Check for duplicate migration numbers
    runs-on: ubuntu-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v6

      - name: Setup Node.js
        uses: actions/setup-node@v6
        with:
          node-version: '20'

      - name: Check for duplicate migration numbers
        run: node scripts/check-migration-duplicates.js
        working-directory: backend