Updates for SQLA 2.0.35 #95
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Test and Lint | |
| on: | |
| # Triggers the workflow on push or pull request events. | |
| push: | |
| # This should disable running the workflow on tags, according to the | |
| # on.<push|pull_request>.<branches|tags> GitHub Actions docs. | |
| branches: | |
| - "*" | |
| pull_request: | |
| types: [opened, reopened, synchronize] | |
| # Allows you to run this workflow manually from the Actions tab | |
| workflow_dispatch: | |
| # This allows a subsequently queued workflow run to interrupt previous runs. | |
| concurrency: | |
| group: '${{ github.workflow }} @ ${{ github.event.pull_request.head.label || github.head_ref || github.ref }}' | |
| cancel-in-progress: true | |
| jobs: | |
| # This job aggregates all matrix results and is used for a GitHub required status check. | |
| test_results: | |
| if: ${{ always() }} | |
| runs-on: ubuntu-latest | |
| name: Test Results | |
| needs: [test-py39] | |
| steps: | |
| - run: | | |
| result="${{ needs.test-py39.result }}" | |
| if [[ $result == "success" || $result == "skipped" ]]; then | |
| exit 0 | |
| else | |
| exit 1 | |
| fi | |
| test-py39: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| crdb-version: [ | |
| "cockroach:latest-v23.2", | |
| "cockroach:latest-v24.1", | |
| "cockroach:latest-v24.2" | |
| ] | |
| db-alias: [ | |
| "psycopg2", | |
| "asyncpg", | |
| "psycopg" | |
| ] | |
| env: | |
| TOXENV: py39 | |
| TOX_VERSION: 3.23.1 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.9' | |
| - name: Start CockroachDB | |
| run: | | |
| docker pull cockroachdb/${{ matrix.crdb-version }} | |
| docker run --rm -d --name crdb -p 26257:26257 \ | |
| cockroachdb/${{ matrix.crdb-version }} start-single-node --insecure | |
| sleep 10 | |
| docker exec crdb cockroach sql --insecure --host=localhost:26257 \ | |
| -e 'CREATE SCHEMA test_schema; CREATE SCHEMA test_schema_2;' | |
| - name: Install testrunner | |
| run: pip install --user tox==${TOX_VERSION} | |
| - name: Test | |
| run: ${HOME}/.local/bin/tox -- --db=${{ matrix.db-alias }} | |
| lint: | |
| runs-on: ubuntu-latest | |
| env: | |
| TOXENV: py39 | |
| TOX_VERSION: 3.23.1 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.9' | |
| - name: Install testrunner | |
| run: pip install --user tox==${TOX_VERSION} | |
| - name: Lint | |
| run: ${HOME}/.local/bin/tox -e lint | |