Database

For this project we use an Azure SQL database hosted on Azure.

SQLAlchemy

For the communication with the database we make use of SQLAlchemy.

Migrations

Migrations are handled by alembic. Migrations are automatically applied when the app container starts. All functions from Alembic that are used by us are wrapped in the CLI, see the CLI docs for more info.

Testing

During tests an Azure SQL database in a separate resource group is used.

Local development

In the docker-compose.yml a 'db' service is defined. If you want to make use of a local Azure SQL database instead of the one hosted by Azure, uncomment this service and optionally alter the environment variables inside it.