Skip to content

Prepare IBM-DB2 and Snowflake tests. #87

Prepare IBM-DB2 and Snowflake tests.

Prepare IBM-DB2 and Snowflake tests. #87

Workflow file for this run

name: Tests
on:
push:
branches:
- main
pull_request:
paths-ignore:
- 'docs/**'
jobs:
lint:
name: Pre-commit Checks
runs-on: ubuntu-latest
timeout-minutes: 10
steps:
- name: Checkout branch
uses: actions/checkout@v4
- name: Install Python 3.9
uses: actions/setup-python@v5
with:
python-version: 3.9
- name: Linting - Run pre-commit checks
uses: pre-commit/action@v3.0.1
smoke_test:
name: Smoke Test
strategy:
matrix:
os:
- ubuntu-latest
environment:
- py312
uses: ./.github/workflows/test.yml
with:
os: ${{ matrix.os }}
environment: ${{ matrix.environment }}
postgres_test:
name: Postgres Tests
needs: [smoke_test]
strategy:
matrix:
os:
- ubuntu-latest
environment:
- py39
- py310
- py311
- py312
uses: ./.github/workflows/test.yml
with:
os: ${{ matrix.os }}
environment: ${{ matrix.environment }}
docker-services: |
postgres
pytest-arguments: --postgres
mssql_test:
name: MSSql Tests
needs: [smoke_test]
strategy:
matrix:
os:
- ubuntu-latest
environment:
- py39
- py311
- py312
uses: ./.github/workflows/test.yml
with:
os: ${{ matrix.os }}
environment: ${{ matrix.environment }}
docker-services: |
mssql
pytest-arguments: --mssql
# ## Deactivated since ibm_db2 tests never ran and are currently failing
# db2_test:
# name: DB2 Tests
# needs: [smoke_test]
# strategy:
# matrix:
# os:
# - ubuntu-latest
# environment:
# - py39ibm
# - py312ibm
# uses: ./.github/workflows/test.yml
# with:
# os: ${{ matrix.os }}
# environment: ${{ matrix.environment }}
# docker-services: |
# ibm_db2
# pytest-arguments: --ibm_db2
# ## Deactivated since snowflake requires pandas < 2 and pydiverse transform does not support it
# snowflake_test:
# name: Snowflake Tests
# needs: [smoke_test]
# strategy:
# matrix:
# os:
# - ubuntu-latest
# environment:
# - py311pdsa1
# uses: ./.github/workflows/test.yml
# secrets:
# SNOWFLAKE_PASSWORD: ${{ secrets.SNOWFLAKE_PASSWORD }}
# SNOWFLAKE_ACCOUNT: ${{ secrets.SNOWFLAKE_ACCOUNT }}
# SNOWFLAKE_USER: ${{ secrets.SNOWFLAKE_USER }}
# with:
# os: ${{ matrix.os }}
# environment: ${{ matrix.environment }}
# workers: 1 # tests are often waiting on snowflake
# timeout-minutes: 40
# docker-services: |
# postgres
# zoo
# pytest-arguments: --snowflake