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

1"""Add protected column for block types 

2 

3Revision ID: dff8da7a6c2c 

4Revises: 9e2a1c08c6f1 

5Create Date: 2022-06-20 12:38:23.657760 

6 

7""" 

8 

9import sqlalchemy as sa 1 ctx1a

10from alembic import op 1 ctx1a

11 

12# revision identifiers, used by Alembic. 

13revision = "dff8da7a6c2c" 1 ctx1a

14down_revision = "a205b458d997" 1 ctx1a

15branch_labels = None 1 ctx1a

16depends_on = None 1 ctx1a

17 

18 

19def upgrade(): 1 ctx1a

20 # ### commands auto generated by Alembic - please adjust! ### 

21 with op.batch_alter_table("block_type", schema=None) as batch_op: 1 ctx1a

22 batch_op.add_column( 1 ctx1a

23 sa.Column("is_protected", sa.Boolean(), server_default="0", nullable=False) 

24 ) 

25 # ### end Alembic commands ### 

26 

27 

28def downgrade(): 1 ctx1a

29 # ### commands auto generated by Alembic - please adjust! ### 

30 with op.batch_alter_table("block_type", schema=None) as batch_op: 

31 batch_op.drop_column("is_protected") 

32 # ### end Alembic commands ###