Merge pull request #32 from Sheldenburg/frontend/dashboard-email #27

	name: Alembic DB Migration and Load Initial Data

	on:
	push:
	branches:
	- main

	jobs:
	alembic-migration:
	runs-on: ubuntu-latest

	env:
	POSTGRES_DB: ${{ secrets.POSTGRES_DB }}
	POSTGRES_USER: ${{ secrets.POSTGRES_USER }}
	POSTGRES_PASSWORD: ${{ secrets.POSTGRES_PASSWORD }}
	POSTGRES_SERVER: ${{ secrets.POSTGRES_SERVER }}
	POSTGRES_PORT: ${{ secrets.POSTGRES_PORT }}
	FIRST_SUPERUSER: ${{ secrets.FIRST_SUPERUSER }}
	FIRST_SUPERUSER_PASSWORD: ${{ secrets.FIRST_SUPERUSER_PASSWORD }}
	ENCRYPTION_KEY: ${{ secrets.ENCRYPTION_KEY }}
	PROJECT_NAME: ${{ vars.PROJECT_NAME }}

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

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

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements.txt

	- name: Start the DB
	working-directory: backend/src
	run: \|
	python backend_pre_start.py

	- name: Run Alembic migrations
	working-directory: backend/src/app
	run: \|
	alembic upgrade head

	- name: Create initial data in the DB
	working-directory: backend/src
	run: \|
	python initial_data.py

Provide feedback