sa-versions.yml

on: [push, pull_request]
name: "SQLAlchemy >=2.0.18 versions"
jobs:
  tests:
    runs-on: ubuntu-20.04
    strategy:
      matrix:
        python-version:
          - "3.12"
        clickhouse-version:
          - 23.8.4.69
        sa-version: [18, 19, 20, 21, 22, 23, 24, 25, 26, 27]
    services:
      clickhouse-server:
        image: clickhouse/clickhouse-server:${{ matrix.clickhouse-version }}
        ports:
          - 8123:8123
          - 9000:9000

    name: ${{ matrix.python-version }} SA=2.0.${{ matrix.sa-version }}
    steps:
      - uses: actions/checkout@v4
      - name: Set up Python
        uses: actions/setup-python@v4
        with:
          python-version: ${{ matrix.python-version }}
          architecture: x64
      - name: Install test requirements
        run: |
          pip install --upgrade pip setuptools wheel
          python testsrequire.py
          python setup.py develop
          # Limit each test time execution.
          pip install pytest-timeout
      - name: Install SQLAlchemy
        run: pip install sqlalchemy==2.0.${{ matrix.sa-version }}
      - name: Run tests
        run: pytest --timeout=10 -v
        timeout-minutes: 2