fix: update queries to work in sequence. #7041
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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" | |
# 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 |