alembic

Alembic main commands

Following main guidelines, following commands should be run within a running container using docker-compose: $ PORT=8002 docker-compose exec -T web alembic ...

Manually created revision

-> $ alembic revision -m "create account table"
generates template "alembic/{id}_create_account_table.py"

-> implement upgrade() & downgrade() functions using SQLAlchemy operations (op.create_table, op.add_column, etc.)

-> $ alembic upgrade head applies all pending revisions to database

Auto generated revision

Alternative using auto generated revision (https://alembic.sqlalchemy.org/en/latest/autogenerate.html)

-> $ alembic revision --autogenerate -m "Add account ts column" generates filled "alembic/{id}_add_account_ts_column.py"

-> review and adjust generated script