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

1"""Adds indexes for block filtering 

2 

3Revision ID: a205b458d997 

4Revises: 9e2a1c08c6f1 

5Create Date: 2022-06-21 09:36:40.029598 

6 

7""" 

8 

9from alembic import op 1 ctx1a

10 

11# revision identifiers, used by Alembic. 

12revision = "a205b458d997" 1 ctx1a

13down_revision = "9e2a1c08c6f1" 1 ctx1a

14branch_labels = None 1 ctx1a

15depends_on = None 1 ctx1a

16 

17 

18def upgrade(): 1 ctx1a

19 op.execute( 1 ctx1a

20 """ 

21 CREATE INDEX ix_block_type_name_case_insensitive on block_type (name COLLATE NOCASE); 

22 """ 

23 ) 

24 

25 

26def downgrade(): 1 ctx1a

27 op.execute( 

28 """ 

29 DROP INDEX ix_block_type_name_case_insensitive; 

30 """ 

31 )