name: PostgreSQL integration
on: [push, pull_request]
jobs:
  tests:
    runs-on: ubuntu-24.04
    env:
      DATABASE_URL: postgresql://dashboard:ci-only-password@127.0.0.1:5432/dashboard
      CACHE_URL: redis://127.0.0.1:6379/6
      DJANGO_SETTINGS_MODULE: config.postgres_test_settings
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-python@v5
        with:
          python-version: '3.12'
      - run: |
          sudo apt-get update
          sudo apt-get install -y postgresql
          sudo systemctl start postgresql
          sudo -u postgres psql -v ON_ERROR_STOP=1 -c "CREATE ROLE dashboard LOGIN CREATEDB PASSWORD 'ci-only-password';"
          sudo -u postgres createdb -O dashboard dashboard
      - run: pip install -r requirements-dev.txt
      - run: pytest --ds=config.postgres_test_settings