Full-Size Alembic Integration

Goal

The goal is to establish a standardized structure for dealing with the database structure. This should be achieved by representing the database structure using versionable migrations.

Current Setup: Alembic is supposed to be used for this. Alembic is already integrated in the current setup. However, Flask migrations and SQL Alchemy are also used. The different frameworks used are not properly configured.

To Dos

• Find out how the current structure is set up
• Remove all faulty configurations
• Creating an initial migration
• Configure the models.py so that new migrations are automatically created from changes
• Write a small readme for the process to create new migrations
• Open problem: After creating the migration, the database must be completely reset once on each system. Does this lead to problems on productive systems? (@larsmeiendresch ?)
  • --> If yes (I suppose): Work out a manual solution, which then has to be executed manually once in the productive database.

Other

Modifications will need to be made to the file src/docker-entrypoint.sh