Merge pull request #225 from pep-dortmund/dependabot/pip/dnspython-2.6.1 #416

	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'

Provide feedback