Alembic

Operations

alembic init

alembic init a project

alembic revision -m "***"

create a version/新建版本

alembic upgrade head

upgrade/升级版本

alembic downgrade -1/-2/-...

downgrade/降级版本

Commands

• create-table

op.create_table("table_name",
sa.Column(),
sa.Column())

• drop-table

op.drop_table("table_name")

• unique-constraint

op.create_unique_constraint("uq_name", "table", ["col1", "col2"])

• primary-key

op.create_primary_key("pk_name", "table", ["col1", "col2"])

• add/drop column

op.add_column('t_celery_task', sa.Column('related_files', sa.JSON))

op.drop_column('t_celery_task', 'related_files')