CODEWITHSUNDEEP
sqlalchemyflask-sqlalchemyalembic
m0ngr31
m0ngr31

Reputation: 830

Removing un-named unique constraint

I'm using Alembic with Flask-SQLAlchemy, and I'm trying to remove a unique constraint on a column in one of my tables. Looking over the migrations - this constraint was never named: sa.UniqueConstraint('title'), obviously when I update the model, Alembic can't pick up that I removed unique=True off of it.

How do I create a migration that removes the constraint?

I tried this, but it didn't work:

with op.batch_alter_table('note', schema=None) as batch_op:
    batch_op.create_unique_constraint('title_uniq', 'title')
    batch_op.drop_constraint('title_uniq', type_='unique')

Upvotes: 2

Views: 999

Answers (1)

m0ngr31
m0ngr31

Reputation: 830

What ended up working was I had to have two migrations - one to create a named index and one to remove it.

Upvotes: 1

Related Questions