Coverage for opt/mealie/lib/python3.12/site-packages/mealie/alembic/versions/2022-04-03-10.48.51_09dfc897ad62_add_require_all_for_cookbook_filters.py: 81%

1"""add require_all for cookbook filters 

2 

3Revision ID: 09dfc897ad62 

4Revises: 59eb59135381 

5Create Date: 2022-04-03 10:48:51.379968 

6 

7""" 

8 

9import sqlalchemy as sa 1 ctx1a

10 

11import mealie.db.migration_types # noqa: F401 1 ctx1a

12from alembic import op 1 ctx1a

13 

14# revision identifiers, used by Alembic. 

15revision = "09dfc897ad62" 1 ctx1a

16down_revision = "59eb59135381" 1 ctx1a

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

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

19 

20 

21def upgrade(): 1 ctx1a

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

23 op.add_column("cookbooks", sa.Column("require_all_categories", sa.Boolean(), nullable=True)) 1 ctx1a

24 op.add_column("cookbooks", sa.Column("require_all_tags", sa.Boolean(), nullable=True)) 1 ctx1a

25 op.add_column("cookbooks", sa.Column("require_all_tools", sa.Boolean(), nullable=True)) 1 ctx1a

26 

27 # Set Defaults for Existing Cookbooks 

28 op.execute( 1 ctx1a

29 """ 

30 UPDATE cookbooks 

31 SET require_all_categories = TRUE, 

32 require_all_tags = TRUE, 

33 require_all_tools = TRUE 

34 """ 

35 ) 

36 

37 # ### end Alembic commands ### 

38 # ### end Alembic commands ### 

39 

40 

41def downgrade(): 1 ctx1a

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

43 op.drop_column("cookbooks", "require_all_tools") 

44 op.drop_column("cookbooks", "require_all_tags") 

45 op.drop_column("cookbooks", "require_all_categories") 

46 # ### end Alembic commands ###