tests.yml

on:
  push:
    branches:
      - main
    tags:
      - '**'
  pull_request:

jobs:

  tests:
    runs-on: ubuntu-22.04
    # We don't fail on dev versions, as those are snapshots
    continue-on-error: ${{ matrix.experimental }}
    strategy:
      matrix:
        postgresql_version: [11, 12, 13, 14, ]
        experimental: [false]
        repo: ["pgdg"]
        pytest_args: ["-m 'not slow'"]
        include:
          # Define the current dev version to be experimental
          - postgresql_version: 16
            experimental: true
            repo: "pgdg-snapshot"
            pytest_args: "-m 'not slow'"
          # For latest stable version, include "slow" tests
          - postgresql_version: 15
            experimental: false
            repo: "pgdg"
            pytest_args: ""
    env:
      PGVERSION: ${{ matrix.postgresql_version }}
      DISTRO: ubuntu
    steps:

      - id: checkout
        uses: actions/checkout@v2
        with:
          # Do not persist the token during execution of this job.
          persist-credentials: false

      - id: dependencies
        run: |
          # Must be installed via the system
          sudo apt update
          sudo apt install curl ca-certificates gnupg
          sudo apt install python3-bpfcc python3-pip libunwind-dev linux-headers-$(uname -r)
          curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg >/dev/null
          sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-${{ matrix.repo }} main ${{ matrix.postgresql_version }}" > /etc/apt/sources.list.d/pgdg.list'
          sudo apt update
          # Install postgresql-common so that update alternatives doesn't fail
          sudo apt install postgresql-common postgresql-client-common
          sudo apt install postgresql-${{matrix.postgresql_version}} postgresql-${{matrix.postgresql_version}}-dbgsym
          sudo pip install -U pip toml
          # Install requirements from pyproject.toml
          sudo pip install -e '.[test]'

      - id: tests
        run: |
          sudo pytest --postgresql-exec /usr/lib/postgresql/${{matrix.postgresql_version}}/bin/pg_ctl --cov src/ --cov-report=xml ${{matrix.pytest_args}}

      - name: Upload coverage reports to Codecov
        uses: codecov/codecov-action@v3
        with:
          env_vars: PGVERSION
          fail_ci_if_error: true
          files: ./coverage.xml
          verbose: true
          name: codecov-umbrella

  tests_fedora_container:
    runs-on: ubuntu-22.04
    env:
      PGVERSION: 13
      DISTRO: fedora
    steps:
      - id: checkout
        uses: actions/checkout@v2
        with:
          persist-credentials: false
      - id: dependencies
        run: |
          sudo apt update
          sudo apt install dnf systemd-container
          sudo apt install postgresql-client
          sudo ./tests/scripts/setup_fedora_container.sh
          sudo apt install curl ca-certificates gnupg
          sudo apt install python3-bpfcc python3-pip libunwind-dev linux-headers-$(uname -r)
          # Also install it in the host, for the tests running outside the
          # container
          sudo pip install -U pip toml
          sudo pip install -e '.[test]'

      - id: fedora_tests
        run: |
          sudo pytest --postgresql-host 172.16.0.1 --container fedora --cov src/ --cov-report=xml -m "not slow"

      - name: Upload coverage reports to Codecov
        uses: codecov/codecov-action@v3
        with:
          env_vars: PGVERSION, DISTRO
          fail_ci_if_error: true
          files: ./coverage.xml
          verbose: true
          name: codecov