Add "expose primary keys" option to create_postgis_store #55
Workflow file for this run
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: End-to-End Tests | |
| on: | |
| push: | |
| branches: | |
| - main | |
| - master | |
| pull_request: | |
| # schedule: | |
| # - cron: "0 0 * * 0" | |
| jobs: | |
| e2e-test: | |
| name: E2E Test Python ${{ matrix.py }} - Postgis ${{ matrix.postgis }} | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| py: | |
| - "3.12" | |
| postgis: | |
| - "9.6-2.5-alpine" | |
| - "10-2.5-alpine" | |
| - "11-2.5-alpine" | |
| - "12-2.5-alpine" | |
| # Not working on PostGIS 3.4 yet | |
| - "12-3.4-alpine" | |
| - "13-3.4-alpine" | |
| - "14-3.4-alpine" | |
| - "15-3.4-alpine" | |
| - "16-3.4-alpine" | |
| services: | |
| geoserver: | |
| image: tethysplatform/geoserver | |
| env: | |
| ENABLED_NODES: 1 | |
| REST_NODES: 1 | |
| MAX_MEMORY: 512 | |
| MIN_MEMORY: 128 | |
| NUM_CORES: 2 | |
| MAX_TIMEOUT: 60 | |
| ports: | |
| - 8181:8181 | |
| postgis: | |
| image: postgis/postgis:${{ matrix.postgis }} | |
| env: | |
| POSTGRES_USER: postgres | |
| POSTGRES_PASSWORD: mysecretpassword | |
| # Set health checks to wait until postgres has started | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| ports: | |
| - 5432:5432 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Python ${{ matrix.py }} for test | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: ${{ matrix.py }} | |
| - name: Install dependencies | |
| run: | | |
| python -m pip install --upgrade pip | |
| python -m pip install -e . | |
| python -m pip install tox tox-gh-actions | |
| - name: Setup Postgis | |
| run: | | |
| PGPASSWORD=mysecretpassword psql -U postgres -h localhost -c "CREATE DATABASE tds_tests WITH OWNER postgres;" | |
| PGPASSWORD=mysecretpassword psql -U postgres -h localhost -d tds_tests -c "CREATE EXTENSION postgis;" | |
| if [[ ${{ matrix.postgis }} == *"3.4-alpine"* ]]; then PGPASSWORD=mysecretpassword psql -U postgres -h localhost -d tds_tests -c "CREATE EXTENSION postgis_raster;"; fi | |
| # The next two are workarounds for issues with PostGIS calculating extents in PostGIS 3.4 (see: https://gis.stackexchange.com/questions/75536/geoserver-not-reading-bounding-box-from-postgis-geometry-correctly) | |
| if [[ ${{ matrix.postgis }} == *"3.4-alpine"* ]]; then PGPASSWORD=mysecretpassword psql -U postgres -h localhost -d tds_tests -c "create or replace function st_estimated_extent(text,text) returns box2d as 'select null::box2d' language sql;"; fi | |
| if [[ ${{ matrix.postgis }} == *"3.4-alpine"* ]]; then PGPASSWORD=mysecretpassword psql -U postgres -h localhost -d tds_tests -c "create or replace function st_estimated_extent(text,text,text) returns box2d as 'select null::box2d' language sql;"; fi | |
| sleep 10 | |
| - name: Run tests | |
| run: tox -e e2e_gs_tests |