ci.yml

name: CI

on:
  push:
    branches:
      - main
    tags:
      - "**"
  pull_request:

env:
  PYTEST_ADDOPTS: --color=yes

jobs:
  tests:
    runs-on: ubuntu-latest
    strategy:
      matrix:
        python-version: ["3.12"]
        db: [sqlite, postgres]

    services:
      db:
        image: postgres
        env:
          POSTGRES_PASSWORD: pep
          POSTGRES_USER: pep
          POSTGRES_DB: memberdb
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

    steps:
      - uses: actions/checkout@v2

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

      - name: Install dependencies
        run: |
          pip install poetry
          poetry install -E deploy

      - name: Prepare sqlite env
        if: matrix.db == 'sqlite'
        run: |
          sed < env-template -e "s:dbpath:$HOME/pep.sqlite:" > .env

      - name: Prepare postgres env
        if: matrix.db == 'postgres'
        run: |
          sed < env-template -e 's|DATABASE_URL=.*$|DATABASE_URL=postgresql://pep:pep@localhost/memberdb|' > .env

      - name: "Perform migrations"
        run: poetry run flask db upgrade

      - name: "Check for schema changes"
        run: |
          poetry run flask db migrate 2>&1 | tee migrate.log
          grep 'No changes in schema detected.' migrate.log

      - name: tests
        run: |
          export USE_CONFIG_DB=1
          poetry run python -m pytest --cov member_database --cov-report=xml

      - uses: codecov/codecov-action@v1
        if: matrix.db == 'postgres'