Skip to content

GSoC 2024: Betweenness Centrality: Week 12 #1197

GSoC 2024: Betweenness Centrality: Week 12

GSoC 2024: Betweenness Centrality: Week 12 #1197

Workflow file for this run

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
TESTDIRS="version"
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}"