Coverage for opt/mealie/lib/python3.12/site-packages/mealie/alembic/versions/2023-01-21-16.54.44_165d943c64ee_add_related_user_to_mealplan.py: 71%

1"""add related user to mealplan 

2 

3Revision ID: 165d943c64ee 

4Revises: 167eb69066ad 

5Create Date: 2023-01-21 16:54:44.368768 

6 

7""" 

8 

9import sqlalchemy as sa 1 ctx1a

10 

11import mealie.db.migration_types 1 ctx1a

12from alembic import op 1 ctx1a

13 

14# revision identifiers, used by Alembic. 

15revision = "165d943c64ee" 1 ctx1a

16down_revision = "167eb69066ad" 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 with op.batch_alter_table("group_meal_plans", schema=None) as batch_op: 1 ctx1a

24 batch_op.add_column(sa.Column("user_id", mealie.db.migration_types.GUID(), nullable=True)) 1 ctx1a

25 batch_op.create_index(batch_op.f("ix_group_meal_plans_user_id"), ["user_id"], unique=False) 1 ctx1a

26 batch_op.create_foreign_key("fk_user_mealplans", "users", ["user_id"], ["id"]) 1 ctx1a

27 

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

29 batch_op.alter_column("recipe_scale", existing_type=sa.FLOAT(), nullable=False) 1 ctx1a

30 

31 # ### end Alembic commands ### 

32 

33 

34def downgrade(): 1 ctx1a

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

36 with op.batch_alter_table("shopping_list_item_recipe_reference", schema=None) as batch_op: 

37 batch_op.alter_column("recipe_scale", existing_type=sa.FLOAT(), nullable=True) 

38 

39 with op.batch_alter_table("group_meal_plans", schema=None) as batch_op: 

40 batch_op.drop_constraint("fk_user_mealplans", type_="foreignkey") 

41 batch_op.drop_index(batch_op.f("ix_group_meal_plans_user_id")) 

42 batch_op.drop_column("user_id") 

43 

44 # ### end Alembic commands ###