(pgtap) add test for the fix & similar to pseudo-test #1815
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 queries | |
| # This action runs: | |
| # - When this file changes | |
| # - When changes on code (src, include, sql) | |
| # - When changes on data or testing scripts (tools/testers) | |
| # - When the way the build changes (CMakeLists.txt) | |
| # | |
| # using | |
| # - the installed version on actions | |
| # - the latest postgis version | |
| on: | |
| workflow_dispatch: | |
| push: | |
| paths: | |
| - '.github/workflows/check-queries.yml' | |
| - 'src/**' | |
| - 'include/**' | |
| - 'sql/**' | |
| - 'docqueries/**' | |
| - 'tools/testers/**' | |
| - 'CMakeLists.txt' | |
| branches-ignore: | |
| - 'gh-pages' | |
| tags: [] | |
| pull_request: | |
| paths: | |
| - '.github/workflows/check-queries.yml' | |
| - 'src/**' | |
| - 'include/**' | |
| - 'sql/**' | |
| - 'docqueries/**' | |
| - 'tools/testers/**' | |
| - 'CMakeLists.txt' | |
| branches-ignore: | |
| - 'gh-pages' | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.ref }} | |
| cancel-in-progress: true | |
| permissions: | |
| contents: read | |
| jobs: | |
| build: | |
| name: Check queries | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: get postgres version | |
| run: | | |
| sudo service postgresql start | |
| PGVER=$(psql --version | grep -Po '(?<=psql \(PostgreSQL\) )[^;]+(?=\.\d+ \()') | |
| echo "PGVER=${PGVER}" >> $GITHUB_ENV | |
| echo "PGPORT=5432" >> $GITHUB_ENV | |
| echo "PGIS=3" >> $GITHUB_ENV | |
| - name: Add PostgreSQL APT repository | |
| run: | | |
| sudo apt-get install curl ca-certificates gnupg | |
| curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - | |
| sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ \ | |
| $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' | |
| - name: Install dependencies | |
| run: | | |
| sudo apt-get update | |
| sudo apt-get install -y \ | |
| libboost-graph-dev \ | |
| libtap-parser-sourcehandler-pgtap-perl \ | |
| postgresql-${PGVER} \ | |
| postgresql-${PGVER}-pgtap \ | |
| postgresql-${PGVER}-postgis-${PGIS} \ | |
| postgresql-${PGVER}-postgis-${PGIS}-scripts \ | |
| postgresql-server-dev-${PGVER} | |
| - name: Configure | |
| run: | | |
| export PATH=/usr/lib/postgresql/${PGVER}/bin:$PATH | |
| mkdir build | |
| cd build | |
| cmake -DPOSTGRESQL_VERSION=${PGVER} -DCMAKE_BUILD_TYPE=Debug .. | |
| - name: Build | |
| run: | | |
| cd build | |
| make -j 4 | |
| sudo make install | |
| - name: Test signature is up to date | |
| run: | | |
| sudo service postgresql start | |
| sudo -u postgres createdb -p ${PGPORT} ____sigs_routing____ | |
| sudo -u postgres psql -p ${PGPORT} -c "CREATE ROLE runner SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN" -d ____sigs_routing____ | |
| tools/release-scripts/get_signatures.sh -p ${PGPORT} | |
| git diff --name-only sql/sigs/*.sig | |
| git diff --exit-code --quiet sql/sigs/*.sig | |
| - name: Test documentation queries are up to date | |
| run: | | |
| sudo -u postgres createdb -p ${PGPORT} pgr_test__db__test | |
| # queries that might change | |
| # version: will catch the current version | |
| # mincut: results change depending on boost | |
| TESTDIRS="version mincut" | |
| for d in ${TESTDIRS} | |
| do | |
| ./tools/testers/doc_queries_generator.pl -pgver "${PGVER}" -pguser runner -documentation -alg "docqueries/${d}" | |
| done | |
| ./tools/testers/doc_queries_generator.pl -pgver "${PGVER}" |