tests.yaml

name: Test Suite

on:
    push:
        branches: ["master", "v1"]
        paths-ignore:
          - "docs/**"
    pull_request:
        branches: ["master", "v1"]
        paths-ignore:
            - "docs/**"

jobs:
    linters:
        runs-on: ubuntu-latest
        timeout-minutes: 60
        strategy:
            matrix:
                python-version: ["3.9", "3.10", "3.11", "3.12", "3.13"]

        steps:
            - uses: actions/checkout@v3
            - name: Set up Python ${{ matrix.python-version }}
              uses: actions/setup-python@v5
              with:
                  python-version: ${{ matrix.python-version }}
            - name: Install dependencies
              run: |
                  python -m pip install --upgrade pip
                  pip install -r requirements/requirements.txt
                  pip install -r requirements/dev-requirements.txt
                  pip install -r requirements/test-requirements.txt
            - name: Lint
              run: ./scripts/lint.sh

    integration:
        runs-on: ubuntu-latest
        timeout-minutes: 60
        strategy:
            matrix:
                # These tests are slow, so we only run on the latest Python
                # version.
                python-version: ["3.12"]
                postgres-version: [17]
        services:
            postgres:
                image: postgres:${{ matrix.postgres-version }}
                env:
                    POSTGRES_PASSWORD: postgres
                options: >-
                    --health-cmd pg_isready
                    --health-interval 10s
                    --health-timeout 5s
                    --health-retries 5
                ports:
                    - 5432:5432
        steps:
            - uses: actions/checkout@v3
            - name: Set up Python ${{ matrix.python-version }}
              uses: actions/setup-python@v5
              with:
                  python-version: ${{ matrix.python-version }}
            - name: Install dependencies
              run: |
                  python -m pip install --upgrade pip
                  pip install -r requirements/requirements.txt
                  pip install -r requirements/test-requirements.txt
                  pip install -r requirements/extras/postgres.txt
            - name: Setup postgres
              run: |
                  export PGPASSWORD=postgres
                  psql -h localhost -c 'CREATE DATABASE piccolo;' -U postgres
                  psql -h localhost -c "CREATE USER piccolo PASSWORD 'piccolo';" -U postgres
                  psql -h localhost -c "GRANT ALL PRIVILEGES ON DATABASE piccolo TO piccolo;" -U postgres
                  psql -h localhost -c "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" -d piccolo -U postgres
            - name: Run integration tests
              run: ./scripts/test-integration.sh
              env:
                  PG_HOST: localhost
                  PG_DATABASE: piccolo
                  PG_PASSWORD: postgres

    postgres:
        runs-on: ubuntu-latest
        timeout-minutes: 60
        strategy:
            matrix:
                python-version: ["3.9", "3.10", "3.11", "3.12", "3.13"]
                postgres-version: [12, 13, 14, 15, 16, 17]

        # Service containers to run with `container-job`
        services:
            # Label used to access the service container
            postgres:
                # Docker Hub image
                image: postgres:${{ matrix.postgres-version }}
                # Provide the password for postgres
                env:
                    POSTGRES_PASSWORD: postgres
                # Set health checks to wait until postgres has started
                options: >-
                    --health-cmd pg_isready
                    --health-interval 10s
                    --health-timeout 5s
                    --health-retries 5
                ports:
                    - 5432:5432

        steps:
            - uses: actions/checkout@v3
            - name: Set up Python ${{ matrix.python-version }}
              uses: actions/setup-python@v5
              with:
                  python-version: ${{ matrix.python-version }}
            - name: Install dependencies
              run: |
                  python -m pip install --upgrade pip
                  pip install -r requirements/requirements.txt
                  pip install -r requirements/test-requirements.txt
                  pip install -r requirements/extras/postgres.txt
            - name: Setup postgres
              run: |
                  export PGPASSWORD=postgres
                  psql -h localhost -c 'CREATE DATABASE piccolo;' -U postgres
                  psql -h localhost -c "CREATE USER piccolo PASSWORD 'piccolo';" -U postgres
                  psql -h localhost -c "GRANT ALL PRIVILEGES ON DATABASE piccolo TO piccolo;" -U postgres
                  psql -h localhost -c "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" -d piccolo -U postgres

            - name: Test with pytest, Postgres
              run: ./scripts/test-postgres.sh
              env:
                  PG_HOST: localhost
                  PG_DATABASE: piccolo
                  PG_PASSWORD: postgres
            - name: Upload coverage
              uses: codecov/codecov-action@v1
              if: matrix.python-version == '3.13'

    cockroach:
        runs-on: ubuntu-latest
        timeout-minutes: 60
        strategy:
            matrix:
                python-version: ["3.9", "3.10", "3.11", "3.12", "3.13"]
                cockroachdb-version: ["v24.1.0"]
        steps:
            - uses: actions/checkout@v3
            - name: Set up Python ${{ matrix.python-version }}
              uses: actions/setup-python@v5
              with:
                  python-version: ${{ matrix.python-version }}
            - name: Install dependencies
              run: |
                  python -m pip install --upgrade pip
                  pip install -r requirements/requirements.txt
                  pip install -r requirements/test-requirements.txt
                  pip install -r requirements/extras/postgres.txt
            - name: Setup CockroachDB
              run: |
                  wget -qO- https://binaries.cockroachdb.com/cockroach-${{ matrix.cockroachdb-version }}.linux-amd64.tgz | tar xz
                  ./cockroach-${{ matrix.cockroachdb-version }}.linux-amd64/cockroach start-single-node --insecure --background
                  ./cockroach-${{ matrix.cockroachdb-version }}.linux-amd64/cockroach sql --insecure -e 'create database piccolo;'

            - name: Test with pytest, CockroachDB
              run: ./scripts/test-cockroach.sh
              env:
                  PG_HOST: localhost
                  PG_DATABASE: piccolo
            - name: Upload coverage
              uses: codecov/codecov-action@v1
              if: matrix.python-version == '3.13'

    sqlite:
        runs-on: ubuntu-latest
        timeout-minutes: 60
        strategy:
            matrix:
                python-version: ["3.9", "3.10", "3.11", "3.12", "3.13"]

        steps:
            - uses: actions/checkout@v3
            - name: Set up Python ${{ matrix.python-version }}
              uses: actions/setup-python@v5
              with:
                  python-version: ${{ matrix.python-version }}
            - name: Install dependencies
              run: |
                  python -m pip install --upgrade pip
                  pip install -r requirements/requirements.txt
                  pip install -r requirements/test-requirements.txt
                  pip install -r requirements/extras/sqlite.txt
            - name: Test with pytest, SQLite
              run: ./scripts/test-sqlite.sh
            - name: Upload coverage
              uses: codecov/codecov-action@v1
              if: matrix.python-version == '3.13'