1 """Add parameters column to deployment schedules
2
3 Revision ID: 67f886da208e
4 Revises: a49711513ad4
5 Create Date: 2025-02-03 12:52:28.370958
6
7 """
8
9 import sqlalchemy as sa 1 ctx 1a
10 from alembic import op 1 ctx 1a
11
12 import prefect 1 ctx 1a
13
14 # revision identifiers, used by Alembic.
15 revision = "67f886da208e" 1 ctx 1a
16 down_revision = "a49711513ad4" 1 ctx 1a
17 branch_labels = None 1 ctx 1a
18 depends_on = None 1 ctx 1a
19
20
21 def upgrade ( ) : 1 ctx 1a
22 op . add_column ( 1 ctx 1a
23 "deployment_schedule" ,
24 sa . Column (
25 "parameters" ,
26 prefect . server . utilities . database . JSON ,
27 server_default = "{}" ,
28 nullable = False ,
29 ) ,
30 )
31
32
33 def downgrade ( ) : 1 ctx 1a
34 op . drop_column ( "deployment_schedule" , "parameters" )