catalog-updates-check.yaml

name: Check for unsafe catalog updates
"on":
  pull_request:
jobs:
  check_catalog_correctly_updated:
    name: Check updates to latest-dev and reverse-dev are properly handled by PR
    runs-on: ubuntu-latest
    steps:
      - name: Checkout source
        uses: actions/checkout@v4
        with:
          fetch-depth: 0
      - name: Install pglast
        run: |
          python -m pip install pglast

      - name: Check sql file contents
        run: |
          find sql -name '*.sql' -not -path 'sql/updates/*' -not -path 'sql/compat.sql' | xargs -IFILE python scripts/check_updates_ast.py FILE

      - name: Check latest-dev contents
        run: |
          python scripts/check_updates_ast.py --latest "sql/updates/latest-dev.sql"

      - name: Check for idempotency in SQL scripts
        if: always()
        run: |
          python scripts/check_sql_script.py sql/*.sql

      # To allow fixing previous mistakes we run the check against reverse-dev but don't
      # fail it on errors.
      - name: Check reverse-dev contents
        if: always()
        run: |
          python scripts/check_updates_ast.py "sql/updates/reverse-dev.sql" || true