# HG changeset patch
# User Mads Kiilerich <mads@kiilerich.com>
# Date 1584400612 -3600
# Node ID e98f6338829cc795ce067c8c4ec6831887b890cc
# Parent  8d663d23ab85bdd823788fc449aba484bfd33aa4
hg: fix db migration after 802fdeefc8cc - index name changed in 1a080d4e926e

diff -r 8d663d23ab85 -r e98f6338829c kallithea/alembic/versions/a0a1bf09c143_db_add_ui_composite_index_and_drop_.py
--- a/kallithea/alembic/versions/a0a1bf09c143_db_add_ui_composite_index_and_drop_.py	Thu Mar 12 23:21:01 2020 +0100
+++ b/kallithea/alembic/versions/a0a1bf09c143_db_add_ui_composite_index_and_drop_.py	Tue Mar 17 00:16:52 2020 +0100
@@ -26,13 +26,20 @@
 branch_labels = None
 depends_on = None
 
+import sqlalchemy as sa
 from alembic import op
 
 
 def upgrade():
+    meta = sa.MetaData()
+    meta.reflect(bind=op.get_bind())
+
     with op.batch_alter_table('ui', schema=None) as batch_op:
         batch_op.create_index('ui_ui_section_ui_key_idx', ['ui_section', 'ui_key'], unique=False)
-        batch_op.drop_constraint('uq_ui_ui_key', type_='unique')
+        if any(i.name == 'uq_ui_ui_key' for i in meta.tables['ui'].constraints):
+            batch_op.drop_constraint('uq_ui_ui_key', type_='unique')
+        elif any(i.name == 'ui_ui_key_key' for i in meta.tables['ui'].constraints):  # table was created with old naming before 1a080d4e926e
+            batch_op.drop_constraint('ui_ui_key_key', type_='unique')
 
 
 def downgrade():