Coverage for /usr/local/lib/python3.12/site-packages/prefect/server/database/_migrations/versions/sqlite/2022_08_07_154319_53c19b31aa09_fix_name_on_concurrency_limit_tag_idx.py: 77%

13 statements  

« prev     ^ index     » next       coverage.py v7.10.6, created at 2025-12-05 13:38 +0000

1""" 

2Fix name on concurrency_limit.tag index. 

3We prefix unique indexes with 'uq_' instead of 'ix_'. 

4 

5Revision ID: 53c19b31aa09 

6Revises: 24bb2e4a195c 

7Create Date: 2022-08-07 15:43:19.528922 

8 

9""" 

10 

11from alembic import op 1a

12 

13# revision identifiers, used by Alembic. 

14revision = "53c19b31aa09" 1a

15down_revision = "24bb2e4a195c" 1a

16branch_labels = None 1a

17depends_on = None 1a

18 

19 

20def upgrade(): 1a

21 with op.batch_alter_table("concurrency_limit", schema=None) as batch_op: 1a

22 batch_op.drop_index("ix_concurrency_limit__tag") 1a

23 batch_op.create_index("uq_concurrency_limit__tag", ["tag"], unique=True) 1a

24 

25 

26def downgrade(): 1a

27 with op.batch_alter_table("concurrency_limit", schema=None) as batch_op: 

28 batch_op.drop_index("uq_concurrency_limit__tag") 

29 batch_op.create_index("ix_concurrency_limit__tag", ["tag"], unique=False)