nightly.yml

name: Nightly

on:
  workflow_dispatch:
  schedule:
    - cron: '0 2 * * *'


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

        # 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 }}

    steps:
      - uses: actions/checkout@v4
      - name: Set up Python ${{ matrix.python-version }}
        uses: actions/setup-python@v4
        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
          bin/test -vvv