Coverage for opt/mealie/lib/python3.12/site-packages/mealie/alembic/versions/2025-08-09-19.32.37_e6bb583aac2d_add_label_notifier_crud_bools.py: 75%

1"""'Add label notifier CRUD bools' 

2 

3Revision ID: e6bb583aac2d 

4Revises: d7b3ce6fa31a 

5Create Date: 2025-08-09 19:32:37.285172 

6 

7""" 

8 

9import sqlalchemy as sa 1 ctx1a

10from alembic import op 1 ctx1a

11 

12# revision identifiers, used by Alembic. 

13revision = "e6bb583aac2d" 1 ctx1a

14down_revision: str | None = "d7b3ce6fa31a" 1 ctx1a

15branch_labels: str | tuple[str, ...] | None = None 1 ctx1a

16depends_on: str | tuple[str, ...] | None = None 1 ctx1a

17 

18 

19def upgrade(): 1 ctx1a

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

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

22 batch_op.add_column( 1 ctx1a

23 sa.Column( 

24 "label_created", sa.Boolean(), nullable=False, default=False, server_default=sa.sql.expression.false() 

25 ) 

26 ) 

27 batch_op.add_column( 1 ctx1a

28 sa.Column( 

29 "label_updated", sa.Boolean(), nullable=False, default=False, server_default=sa.sql.expression.false() 

30 ) 

31 ) 

32 batch_op.add_column( 1 ctx1a

33 sa.Column( 

34 "label_deleted", sa.Boolean(), nullable=False, default=False, server_default=sa.sql.expression.false() 

35 ) 

36 ) 

37 

38 # ### end Alembic commands ### 

39 

40 

41def downgrade(): 1 ctx1a

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

43 with op.batch_alter_table("group_events_notifier_options", schema=None) as batch_op: 

44 batch_op.drop_column("label_deleted") 

45 batch_op.drop_column("label_updated") 

46 batch_op.drop_column("label_created") 

47 

48 # ### end Alembic commands ###