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

9 statements  

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

1"""Add index for scheduled deployments 

2 

3Revision ID: a0284438370e 

4Revises: af52717cf201 

5Create Date: 2022-11-05 18:06:19.568896 

6 

7""" 

8 

9from alembic import op 1a

10 

11# revision identifiers, used by Alembic. 

12revision = "a0284438370e" 1a

13down_revision = "af52717cf201" 1a

14branch_labels = None 1a

15depends_on = None 1a

16 

17 

18def upgrade(): 1a

19 op.execute( 1a

20 """ 

21 CREATE INDEX ix_flow_run__scheduler_deployment_id_auto_scheduled_next_scheduled_start_time  

22 ON flow_run (deployment_id, auto_scheduled, next_scheduled_start_time)  

23 WHERE state_type = 'SCHEDULED'; 

24 """ 

25 ) 

26 

27 

28def downgrade(): 1a

29 op.execute( 

30 """ 

31 DROP INDEX ix_flow_run__scheduler_deployment_id_auto_scheduled_next_scheduled_start_time; 

32 """ 

33 )