python-pgsql.yaml

name: FastAPI backend with PostgreSQL

permissions: {}

on:
  push:
    branches: [ "main" ]
  pull_request:
    branches: [ "main" ]

jobs:
  build-and-test:
    runs-on: ubuntu-latest

    defaults:
      run:
        working-directory: ./backend

    services:
      postgres:
        image: postgres
        env:
          POSTGRES_PASSWORD: password
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

    steps:
    - uses: actions/checkout@v4
      with:
        sparse-checkout: backend

    - uses: actions/setup-python@v5
      with:
        python-version: '3.12'

    - name: Install backend
      run: |
        pipx install poetry
        poetry sync -E pg

    - name: Create test database
      run: psql -h localhost -U postgres -c 'CREATE DATABASE "acidwatch_test";'
      env:
        PGPASSWORD: password

    - name: Run pytest
      run: |
        poetry run alembic upgrade head
        poetry run pytest tests --test-alembic
      env:
        ACIDWATCH_DATABASE: postgresql://postgres:password@localhost:5432/postgres
        ACIDWATCH_TEST_DATABASE: postgresql://postgres:password@localhost:5432/acidwatch_test