Coverage for opt/mealie/lib/python3.12/site-packages/mealie/db/models/recipe/nutrition.py: 100%

1import sqlalchemy as sa 1 ctx1a

2from sqlalchemy.orm import Mapped, mapped_column 1 ctx1a

3 

4from mealie.db.models._model_base import SqlAlchemyBase 1 ctx1a

5from mealie.db.models._model_utils.guid import GUID 1 ctx1a

6 

7 

8class Nutrition(SqlAlchemyBase): 1 ctx1a

9 __tablename__ = "recipe_nutrition" 1 ctx1a

10 id: Mapped[int] = mapped_column(sa.Integer, primary_key=True) 1 ctx1a

11 recipe_id: Mapped[GUID | None] = mapped_column(GUID, sa.ForeignKey("recipes.id"), index=True) 1 ctx1a

12 

13 calories: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

14 carbohydrate_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

15 cholesterol_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

16 fat_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

17 fiber_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

18 protein_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

19 saturated_fat_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

20 

21 # `serving_size` is not a scaling factor, but a per-serving volume or mass 

22 # according to schema.org. E.g., "2 L", "500 g", "5 cups", etc. 

23 # 

24 # Ignoring for now because it's too difficult to work around variable units 

25 # in translation for the frontend. Also, it causes cognitive dissonance wrt 

26 # "servings" (i.e., "serves 2" etc.), which is an unrelated concept that 

27 # might cause confusion. 

28 # 

29 # serving_size: Mapped[str | None] = mapped_column(sa.String) 

30 

31 sodium_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

32 sugar_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

33 trans_fat_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

34 unsaturated_fat_content: Mapped[str | None] = mapped_column(sa.String) 1 ctx1a

35 

36 def __init__( 1 ctx1a

37 self, 

38 calories=None, 

39 carbohydrate_content=None, 

40 cholesterol_content=None, 

41 fat_content=None, 

42 fiber_content=None, 

43 protein_content=None, 

44 saturated_fat_content=None, 

45 sodium_content=None, 

46 sugar_content=None, 

47 trans_fat_content=None, 

48 unsaturated_fat_content=None, 

49 ) -> None: 

50 self.calories = calories 2 ctx1bc

51 self.carbohydrate_content = carbohydrate_content 2 ctx1bc

52 self.cholesterol_content = cholesterol_content 2 ctx1bc

53 self.fat_content = fat_content 2 ctx1bc

54 self.fiber_content = fiber_content 2 ctx1bc

55 self.protein_content = protein_content 2 ctx1bc

56 self.saturated_fat_content = saturated_fat_content 2 ctx1bc

57 self.sodium_content = sodium_content 2 ctx1bc

58 self.sugar_content = sugar_content 2 ctx1bc

59 self.trans_fat_content = trans_fat_content 2 ctx1bc

60 self.unsaturated_fat_content = unsaturated_fat_content 2 ctx1bc