Coverage for opt/mealie/lib/python3.12/site-packages/mealie/alembic/versions/2022-11-22-03.42.45_167eb69066ad_add_recipe_scale_to_shopping_list_item_.py: 91%

11 statements  

« prev     ^ index     » next       coverage.py v7.10.6, created at 2025-12-05 14:03 +0000

1"""add recipe_scale to shopping list item ref 

2 

3Revision ID: 167eb69066ad 

4Revises: 1923519381ad 

5Create Date: 2022-11-22 03:42:45.494567 

6 

7""" 

8 

9import sqlalchemy as sa 1a

10 

11from alembic import op 1a

12 

13# revision identifiers, used by Alembic. 

14revision = "167eb69066ad" 1a

15down_revision = "1923519381ad" 1a

16branch_labels: str | tuple[str, ...] | None = None 1a

17depends_on: str | tuple[str, ...] | None = None 1a

18 

19 

20def upgrade(): 1a

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

22 op.add_column("shopping_list_item_recipe_reference", sa.Column("recipe_scale", sa.Float(), nullable=True)) 1a

23 op.execute("UPDATE shopping_list_item_recipe_reference SET recipe_scale = 1") 1a

24 # ### end Alembic commands ### 

25 

26 

27def downgrade(): 1a

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

29 op.drop_column("shopping_list_item_recipe_reference", "recipe_scale") 

30 # ### end Alembic commands ###