Changeset - e98f6338829c
[Not reviewed]
default
0 1 0
Mads Kiilerich (mads) - 6 years ago 2020-03-17 00:16:52
mads@kiilerich.com
hg: fix db migration after 802fdeefc8cc - index name changed in 1a080d4e926e
1 file changed with 8 insertions and 1 deletions:
0 comments (0 inline, 0 general)
kallithea/alembic/versions/a0a1bf09c143_db_add_ui_composite_index_and_drop_.py
Show inline comments
 
@@ -26,13 +26,20 @@ down_revision = 'd7ec25b66e47'
 
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():
0 comments (0 inline, 0 general)