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

9 statements  

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

1"""Add trgm index to block_document.name 

2 

3Revision ID: 9c493c02ca6d 

4Revises: 22ef3915ccd8 

5Create Date: 2023-11-20 08:47:08.929487 

6 

7""" 

8 

9from alembic import op 1a

10 

11# revision identifiers, used by Alembic. 

12revision = "9c493c02ca6d" 1a

13down_revision = "22ef3915ccd8" 1a

14branch_labels = None 1a

15depends_on = None 1a

16 

17 

18def upgrade(): 1a

19 op.execute( 1a

20 """ 

21 CREATE INDEX ix_block_document_name_case_insensitive on block_document (name COLLATE NOCASE); 

22 """ 

23 ) 

24 

25 

26def downgrade(): 1a

27 op.execute("DROP INDEX ix_block_document_name_case_insensitive;")