postgres.yml

name: postgres

on:
  pull_request:
    branches:
      - main
  workflow_dispatch:

jobs:
  test:
    name: CI on python${{ matrix.python }} via ${{ matrix.os }}
    runs-on: ubuntu-latest
    strategy:
      matrix:
        include:
          - python: "3.10"
          - python: "3.13"
    steps:
      - uses: actions/checkout@v4
      - name: Setup Python
        uses: actions/setup-python@v5
        with:
          python-version: ${{ matrix.python }}
      - name: Install uv
        uses: astral-sh/setup-uv@0c5e2b8115b80b4c7c5ddf6ffdd634974642d182
      - name: Install postgresql
        run: |
          sudo apt-get install -y postgresql
      - name: Allow postgresql to trust all
        run: |
          sudo sed -i -E '/local\s+all\s+/s/peer/trust/' /etc/postgresql/*/main/pg_hba.conf
          sudo sed -i -E '/^host\s+all\s+all\s+/s/scram-sha-256/trust/' /etc/postgresql/*/main/pg_hba.conf
      - name: Start postgresql
        run: |
          sudo systemctl restart postgresql
          pg_isready
      - name: Run unit tests
        run: tox -e py3
      - name: Run tox
        run: uv tool run tox -e postgresql