backend-tests.yaml

name: Backend API tests and code coverage

on:
  push:
    paths-ignore:
      - training-front-end/**

jobs:
  test:

    runs-on: ubuntu-latest

    strategy:
      matrix:
        python-version:
          - "3.10"

    services:
      postgres:
        image: postgres:12  # For best results, match version in use by cloud.gov RDS
        ports:
          - 5432:5432
        env:
          POSTGRES_PASSWORD: postgres
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

    steps:
      - name: Checkout
        uses: actions/checkout@v3

      - name: Set up Python ${{ matrix.python-version }}
        uses: actions/setup-python@v4
        with:
          python-version: ${{ matrix.python-version }}
          cache: pip

      - name: Install pip
        run: python -m pip install --upgrade pip

      - name: Install prerequisites
        run: pip install -r requirements.txt -r requirements.dev.txt

      - name: Set up environment variables
        run: cp .env_example .env

      - name: Run database migrations
        run: alembic upgrade head

      - name: Seed the database
        run: python -m training.database.seed

      - name: Run linter
        run: flake8 training --show-source --statistics

      - name: Run unit tests with test coverage checking
        run: coverage run -m pytest

      - name: Verify >= 90% test coverage
        run: coverage report --fail-under=90