postgres.yml

name: Postgres Versions Tests
on:
  schedule:
    - cron: '0 18 * * 1'
permissions:
  contents: read
env:
  # Skips setuptools_scm's `git archive` file listing; see Makefile.
  SETUPTOOLS_SCM_IGNORE_VCS_ROOTS: ${{ github.workspace }}
jobs:
  postgres:
    name: Python postgres unit tests
    runs-on: ubuntu-latest
    timeout-minutes: 60
    strategy:
      max-parallel: 5
      matrix:
        postgres-version: [13, 14, 15, 16, 17]
    services:
      # Label used to access the service container
      postgres:
        # Docker Hub image
        image: postgres:${{ matrix.postgres-version }}
        # Provide the password for postgres
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: test
        # Set health checks to wait until postgres has started
        options: >-
          --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
        ports:
          # Maps tcp port 5432 on service container to the host
          - 5432:5432
        # Discarded at job end, so durability buys nothing and every COMMIT
        # would otherwise cost an fsync.
        command: >-
          -c fsync=off -c synchronous_commit=off -c full_page_writes=off
    steps:
      - uses: actions/checkout@v7.0.1
        with:
          fetch-depth: 0
      - name: Set up uv
        uses: astral-sh/setup-uv@v10.2.0
        with:
          enable-cache: false
      - name: Install Python 3.9
        run: uv python install 3.9
      - name: Install dependencies
        run: uv sync --group test --extra postgres --python 3.9
      - name: Run tests
        run: |
          uv run python -O -m pytest kolibri --color=no
          uv run python -O -m pytest --color=no -p no:django test
        env:
          KOLIBRI_DATABASE_ENGINE: postgres
          KOLIBRI_DATABASE_USER: postgres
          KOLIBRI_DATABASE_NAME: test
          KOLIBRI_DATABASE_HOST: localhost
          KOLIBRI_DATABASE_PASSWORD: postgres
          KOLIBRI_DATABASE_PORT: "5432"