test-databases.yml

name: Test Database Setup

on:
  push:
    branches: [ Antoine ]
  pull_request:
    branches: [ Antoine ]

jobs:
  test:
    runs-on: ubuntu-latest

    services:
      postgres:
        image: postgres:16-alpine
        env:
          POSTGRES_USER: test_user
          POSTGRES_PASSWORD: test_password
          POSTGRES_DB: test_db
        ports:
          - 5432:5432
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

    steps:
      - uses: actions/checkout@v3

      - name: Set up Python
        uses: actions/setup-python@v4
        with:
          python-version: '3.10'

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r tests/requirements-test.txt

      - name: Create database tables
        run: |
          psql postgresql://test_user:test_password@localhost:5432/test_db -f tests/test_db_creation.sql

      - name: Run database tests
        run: |
          pytest tests/test_db.py