Trying to auto generate initial Alembic files.
I have a flask app and I need to set up Alembic to keep track of the database.
I generated a fresh dbmodels.py
file with the current schema using
sqlacodegen postgresql://scott:tiger@localhost/mydatabase
I tried running:
alembic --autogenerate -m "first"
but the generated file is empty:
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
pass
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
pass
# ### end Alembic commands ###
My env.py looks like this:
import os, sys
sys.path.append(os.path.join(os.path.dirname(os.path.dirname(os.path.realpath(''))), 'App'))
from
target_metadata = dbmodels.Base.metadata
I tried to examine target_metadata in idle:
from manager import dbmodels
from manager.dbmodels import Base
x = Base.metadata
x
MetaData(bind=None)