Coverage for /usr/local/lib/python3.12/site-packages/prefect/server/database/_migrations/versions/postgresql/2022_10_31_161719_41e5ed9e1034_.py: 83%

1"""empty message 

2 

3Revision ID: 41e5ed9e1034 

4Revises: 8ea825da948d 

5Create Date: 2022-10-31 16:17:19.166384 

6 

7""" 

8 

9from alembic import op 

10 

11# revision identifiers, used by Alembic. 

12revision = "41e5ed9e1034" 

13down_revision = "8ea825da948d" 

14branch_labels = None 

15depends_on = None 

16 

17 

18def upgrade(): 

19 # install pg_trgm 

20 op.execute("CREATE EXTENSION IF NOT EXISTS pg_trgm;") 

21 

22 with op.get_context().autocommit_block(): 

23 op.execute( 

24 """ 

25 CREATE INDEX CONCURRENTLY 

26 trgm_ix_work_queue_name 

27 ON work_queue USING gin (name gin_trgm_ops); 

28 """ 

29 ) 

30 

31 

32def downgrade(): 

33 with op.get_context().autocommit_block(): 

34 op.execute( 

35 """ 

36 DROP INDEX CONCURRENTLY trgm_ix_work_queue_name; 

37 """ 

38 )