[Alembic Cheatsheet] Some basic commands for Alembic #python #database #alembic

alembic.py

# initiate alembic in project
alembic init alembic

#####################################
# need to edit alembic/env.py so that gets connection string from settings/local_config python module
# add in below around about line 17
# add parent project to sys path
import sys, os
sys.path.insert(0, os.path.dirname(os.path.dirname(__file__)))

# source db uri
import <settings/config_module> as my_config
config.set_main_option('sqlalchemy.url', my_config.<whatever the connection string object is called>)

# get SQLalchemy model declarative base
from models import Base
target_metadata = Base.metadata
#####################################
# run below to create the alembic_version table so we can start tracking revisions (version)
alembic stamp head

# run below when making revisions
alembic revision --autogenerate -m "<revision message>"

Adding to this
https://stackoverflow.com/questions/52121596/creating-zero-state-migration-for-existing-db-with-sqlalchemy-alembic-and-fak