Skip to content

fix setup.py command migrate taxref data sql files #371

fix setup.py command migrate taxref data sql files

fix setup.py command migrate taxref data sql files #371

Workflow file for this run

name: pytest
on:
push:
branches:
- master
- hotfixes
- develop
pull_request:
branches:
- master
- hotfixes
- develop
jobs:
build:
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
debian-version: [ '10', '11', '12' ]
sqlalchemy-version: [ '1.3', '1.4' ]
include:
- debian-version: '10'
python-version: '3.7'
postgres-version: '11'
postgis-version: '2.5'
- debian-version: '11'
python-version: '3.9'
postgres-version: '13'
postgis-version: '3.2'
- debian-version: '12'
python-version: '3.11'
postgres-version: '15'
postgis-version: '3.3'
exclude:
- debian-version: '10'
sqlalchemy-version: '1.3'
- debian-version: '12'
sqlalchemy-version: '1.3'
name: Debian ${{ matrix.debian-version }} - SQLAlchemy ${{ matrix.sqlalchemy-version }}
services:
postgres:
image: postgis/postgis:${{ matrix.postgres-version }}-${{ matrix.postgis-version }}
env:
POSTGRES_DB: taxhub
POSTGRES_USER: taxhubadmin
POSTGRES_PASSWORD: taxhubpwd
ports:
- 5432:5432
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
steps:
- name: Add postgis_raster database extension
if: ${{ matrix.postgis-version >= 3 }}
run: |
psql -h localhost -U taxhubadmin -d taxhub -tc 'CREATE EXTENSION "postgis_raster";'
env:
PGPASSWORD: taxhubpwd
- name: Add database extensions
run: |
psql -h localhost -U taxhubadmin -d taxhub -tc 'CREATE EXTENSION "unaccent";'
psql -h localhost -U taxhubadmin -d taxhub -tc 'CREATE EXTENSION "uuid-ossp";'
psql -h localhost -U taxhubadmin -d taxhub -tc 'CREATE EXTENSION "pg_trgm";'
env:
PGPASSWORD: taxhubpwd
- uses: actions/checkout@v3
with:
submodules: true
- name: Set up Python ${{ matrix.python-version }}
uses: actions/setup-python@v4
with:
python-version: ${{ matrix.python-version }}
- name: Install GDAL
run: |
sudo apt update
sudo apt install -y libgdal-dev
- name: Install dependencies
if: ${{ matrix.sqlalchemy-version == '1.3' }}
run: |
python -m pip install --upgrade pip
python -m pip install \
-e .[tests] \
-r requirements-dev.in \
"sqlalchemy<1.4" \
"flask-sqlalchemy<3"
- name: Install dependencies
if: ${{ matrix.sqlalchemy-version == '1.4' }}
run: |
python -m pip install --upgrade pip
python -m pip install \
-e .[tests] \
-r requirements-dev.in \
"sqlalchemy<2,>=1.4" \
"flask-sqlalchemy>=3"
- name: Install database
run: |
flask db upgrade taxhub@head -x local-srid=2154
flask db upgrade taxhub-admin@head
flask db upgrade ref_geo_fr_departments@head
flask db autoupgrade
flask db status
env:
TAXHUB_SETTINGS: test_config.py
- name: Install taxref
run: |
flask taxref import-v16
env:
TAXHUB_SETTINGS: test_config.py
- name: Test with pytest
run: |
pytest -v --cov --cov-report xml
env:
TAXHUB_SETTINGS: test_config.py
- name: Upload coverage to Codecov
if: ${{ matrix.name == '11' && matrix.sqlalchemy-version == '1.4' }}
uses: codecov/codecov-action@v3
with:
flags: pytest