build: use Poetry as default build system for dependency installation in CI jobs #13

	name: DB Migration Test

	on:
	pull_request:
	branches:
	- main
	paths:
	- api/migrations/**

	concurrency:
	group: db-migration-test-${{ github.ref }}
	cancel-in-progress: true

	jobs:
	db-migration-test:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	python-version:
	- "3.10"

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	cache: 'poetry'
	cache-dependency-path: \|
	./api/pyproject.toml

	- name: Install Poetry
	uses: abatilo/actions-poetry@v3
	with:
	poetry-version: "1.8.1"

	- name: Install dependencies
	run: poetry install -C api

	- name: Set up Middleware
	uses: hoverkraft-tech/compose-action@v2.0.0
	with:
	compose-file: \|
	docker/docker-compose.middleware.yaml
	services: \|
	db

	- name: Prepare configs
	run: \|
	cd api
	cp .env.example .env

	- name: Run DB Migration
	run: \|
	cd api
	flask db upgrade

Provide feedback