python-integration.yml

# This workflow will install Python dependencies, run tests and lint with a variety of Python versions
# For more information see: https://help.github.com/actions/language-and-framework-guides/using-python-with-github-actions
concurrency:
  group: integration
  cancel-in-progress: false

name: Python integration tests

on:
  push:
    branches: [ main ]
  pull_request:
    branches: [ main ]

jobs:
  build:

    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        python-version: [3.9]

    steps:
    - uses: actions/checkout@v2
    - name: Set up Python ${{ matrix.python-version }}
      uses: actions/setup-python@v2
      with:
        python-version: ${{ matrix.python-version }}
    - name: Install dependencies
      run: |
        python -m pip install --upgrade pip
        pip install -r requirements/test.txt
    - name: Install multicorn2
      run: |
        git clone https://github.com/pgsql-io/multicorn2.git
        cd multicorn2
        git checkout v2.5
        pip install .
    - name: Start the Postgres service
      run: |
        docker compose -f postgres/docker-compose.yml up --build -d
        docker compose ps
        sleep 15
        docker compose ps
        until docker run --network container:postgres_postgres_1 postgres_postgres pg_isready -h postgres -p 5432 -U shillelagh --timeout=90; do sleep 10; done
    - name: Test with pytest
      env:
        SHILLELAGH_ADAPTER_KWARGS: ${{ secrets.SHILLELAGH_ADAPTER_KWARGS }}
      run: |
        pytest --cov-fail-under=100 --cov=src/shillelagh -vv tests/ --doctest-modules src/shillelagh --with-integration --with-slow-integration
    - name: Stop the Postgres service
      if: always()
      run: |
        docker compose -f postgres/docker-compose.yml down