Coverage for opt/mealie/lib/python3.12/site-packages/mealie/alembic/versions/2024-10-01-14.17.00_602927e1013e_add_the_rest_of_the_schema_org_.py: 72%

18 statements  

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

1"""'add the rest of the schema.org nutrition properties' 

2 

3Revision ID: 602927e1013e 

4Revises: 1fe4bd37ccc8 

5Create Date: 2024-10-01 14:17:00.611398 

6 

7""" 

8 

9import sqlalchemy as sa 1a

10from alembic import op 1a

11 

12# revision identifiers, used by Alembic. 

13revision = "602927e1013e" 1a

14down_revision: str | None = "1fe4bd37ccc8" 1a

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

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

17 

18 

19def upgrade(): 1a

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

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

22 batch_op.add_column(sa.Column("cholesterol_content", sa.String(), nullable=True)) 1a

23 batch_op.add_column(sa.Column("saturated_fat_content", sa.String(), nullable=True)) 1a

24 batch_op.add_column(sa.Column("trans_fat_content", sa.String(), nullable=True)) 1a

25 batch_op.add_column(sa.Column("unsaturated_fat_content", sa.String(), nullable=True)) 1a

26 

27 # ### end Alembic commands ### 

28 

29 

30def downgrade(): 1a

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

32 with op.batch_alter_table("recipe_nutrition", schema=None) as batch_op: 

33 batch_op.drop_column("unsaturated_fat_content") 

34 batch_op.drop_column("trans_fat_content") 

35 batch_op.drop_column("saturated_fat_content") 

36 batch_op.drop_column("cholesterol_content") 

37 

38 # ### end Alembic commands ###