« prev ^ index » next coverage.py v7.10.6, created at 2025-12-05 13:38 +0000
1"""Add indexes for partial name matches
3Revision ID: f65b6ad0b869
4Revises: d76326ed0d06
5Create Date: 2022-06-04 10:40:48.710626
7"""
9from alembic import op 1a
11# revision identifiers, used by Alembic.
12revision = "f65b6ad0b869" 1a
13down_revision = "d76326ed0d06" 1a
14branch_labels = None 1a
15depends_on = None 1a
18def upgrade(): 1a
19 op.execute( 1a
20 """
21 CREATE INDEX ix_flow_name_case_insensitive on flow (name COLLATE NOCASE);
22 """
23 )
24 op.execute( 1a
25 """
26 CREATE INDEX ix_flow_run_name_case_insensitive on flow_run (name COLLATE NOCASE);
27 """
28 )
29 op.execute( 1a
30 """
31 CREATE INDEX ix_task_run_name_case_insensitive on task_run (name COLLATE NOCASE);
32 """
33 )
34 op.execute( 1a
35 """
36 CREATE INDEX ix_deployment_name_case_insensitive on deployment (name COLLATE NOCASE);
37 """
38 )
41def downgrade(): 1a
42 op.execute(
43 """
44 DROP INDEX ix_flow_name_case_insensitive;
45 """
46 )
47 op.execute(
48 """
49 DROP INDEX ix_flow_run_name_case_insensitive;
50 """
51 )
52 op.execute(
53 """
54 DROP INDEX ix_task_run_name_case_insensitive;
55 """
56 )
57 op.execute(
58 """
59 DROP INDEX ix_deployment_name_case_insensitive;
60 """
61 )