ENG-91: add multi field select #58

	name: Run backend API tests

	on:
	pull_request:
	branches: [main]
	paths:
	- backend/**
	- .github/workflows/pr-backend.yml

	jobs:
	build:
	defaults:
	run:
	working-directory: backend

	runs-on: ubuntu-latest
	env:
	IMAGE_NAME: incidental/backend

	steps:
	- uses: actions/checkout@v3

	- name: Set up Python 3.11
	uses: actions/setup-python@v4
	with:
	python-version: "3.11"

	- name: Lint with flake8
	run: \|
	pip install flake8
	# stop the build if there are Python syntax errors or undefined names
	flake8 . --count --select=E9,F63,F7,F82 --show-source --statistics
	# exit-zero treats all errors as warnings. The GitHub editor is 127 chars wide
	flake8 . --count --exit-zero --max-complexity=10 --max-line-length=127 --statistics

	- name: Set up Docker Buildx
	uses: docker/setup-buildx-action@v2

	- name: Build image
	uses: docker/build-push-action@v4
	with:
	context: backend
	tags: ${{env.IMAGE_NAME}}:latest
	cache-from: type=gha
	cache-to: type=gha,mode=max
	outputs: type=docker

	- name: Copy env file
	run: cp .env.example .env

	- name: Create the docker compose stack
	run: docker compose -f docker-compose.yml up -d

	- name: Check local running docker containers
	run: docker ps -a

	- name: Migrate db
	run: docker compose -f docker-compose.yml exec -T backend sh -c "alembic upgrade head"

	- name: Runs tests
	run: docker compose -f docker-compose.yml exec -T backend sh -c "coverage run"

	- name: Get coverage report
	run: docker compose -f docker-compose.yml exec -T backend sh -c "coverage report"

Provide feedback