python - Alembic --autogenerate tries to recreate every table -

python - Alembic --autogenerate tries to recreate every table -

i trying autogenerate alembic revision first time against pre-existing database when run next command

alembic revision --autogenerate

it generates migration attempts create every table , index in database. similar this:

def upgrade(): ### commands auto generated alembic - please adjust! ### op.create_table('table1', sa.column('id', sa.smallinteger(), nullable=false), sa.column('name', sa.string(length=100), nullable=true), sa.column('desc', sa.text(), nullable=true), sa.primarykeyconstraint('id'), sa.uniqueconstraint('name'), schema='schema1' ) op.create_index(op.f('ix_index1'), 'table1', ['name'], unique=false, schema='schema1') ... other tables/indexes .. def downgrade(): ### commands auto generated alembic - please adjust! ### op.drop_index(op.f('ix_index1'), table_name='table1', schema='schema1') op.drop_table('table1', schema='schema1') ... other tables/indexes ..

then if seek , run migration fails because objects exist:

sqlalchemy.exc.programmingerror: (programmingerror) relation "table1" exists

so looks me alembic thinks database doesn't contain tables, does.

any ideas why might happening?

python alembic