2. Alembic ‐ Updating the DB Schema

Keeping track of changes to the database without messing it up is hard, sorry! If you want to make any changes, you'll have to learn about how alembic does migrations here https://alembic.sqlalchemy.org/en/latest/tutorial.html

Feel free to ask anyone in the W3 committee for help though!

Creating a database revision

source .venv/bin/activate
cd src
alembic revision -m "description"
# TODO: edit the new revision file in versions/
alembic upgrade head

Creating a database revision using --autogenerate

source .venv/bin/activate
cd src
# ensure you're connected to the correct database by using the following
python database.py
# TODO: ensure your models are loaded in src/alembic/env.py (import <path>.models)
alembic revision --autogenerate -m "description"
# TODO: confirm / edit changes
alembic upgrade head