tests.yml

name: Tests

on:
  push:
    branches: [ master ]
  pull_request: ~
  workflow_dispatch:

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

jobs:
  test:
    name: "Python: ${{ matrix.python-version }}
     SQLA: ${{ matrix.sqla-version }}
     on ${{ matrix.os }}"
    runs-on: ${{ matrix.os }}
    strategy:
      matrix:
        os: ['ubuntu-latest', 'macos-latest']
        python-version: ['3.7', '3.8', '3.9', '3.10', '3.11', '3.12']
        cratedb-version: ['nightly']
        sqla-version: ['<1.4', '<1.5', '<2.1']
        pip-allow-prerelease: ['false']

        # To save resources, only use the most recent Python versions on macOS.
        exclude:
          - os: 'macos-latest'
            python-version: '3.7'
          - os: 'macos-latest'
            python-version: '3.8'
          - os: 'macos-latest'
            python-version: '3.9'
          - os: 'macos-latest'
            python-version: '3.10'

        # Another CI test matrix slot to test against prerelease versions of Python packages.
        include:
          - os: 'ubuntu-latest'
            python-version: '3.12'
            cratedb-version: 'nightly'
            sqla-version: 'latest'
            pip-allow-prerelease: 'true'

      fail-fast: false

    env:
      CRATEDB_VERSION: ${{ matrix.cratedb-version }}
      SQLALCHEMY_VERSION: ${{ matrix.sqla-version }}
      PIP_ALLOW_PRERELEASE: ${{ matrix.pip-allow-prerelease }}
      CODECOV_TOKEN: ${{ secrets.CODECOV_TOKEN }}

    steps:
      - uses: actions/checkout@v4
      - name: Set up Python ${{ matrix.python-version }}
        uses: actions/setup-python@v5
        with:
          python-version: ${{ matrix.python-version }}
          cache: 'pip'
          cache-dependency-path: setup.py

      - name: Invoke tests
        run: |

          # Propagate build matrix information.
          ./devtools/setup_ci.sh

          # Bootstrap environment.
          source bootstrap.sh

          # Report about the test matrix slot.
          echo "Invoking tests with CrateDB ${CRATEDB_VERSION} and SQLAlchemy ${SQLALCHEMY_VERSION}"

          # Run linter.
          flake8 src bin
          
          # Run tests.
          export SQLALCHEMY_WARN_20=1
          coverage run bin/test -vvv

          # Set the stage for uploading the coverage report.
          coverage xml

      # https://github.com/codecov/codecov-action
      - name: Upload coverage results to Codecov
        uses: codecov/codecov-action@v4
        env:
          CODECOV_TOKEN: ${{ secrets.CODECOV_TOKEN }}
        with:
          fail_ci_if_error: true