Coverage for opt/mealie/lib/python3.12/site-packages/mealie/db/models/household/household.py: 88%
39 statements
« prev ^ index » next coverage.py v7.10.6, created at 2025-11-25 17:29 +0000
1from typing import TYPE_CHECKING 1a
3import sqlalchemy as sa 1a
4import sqlalchemy.orm as orm 1a
5from pydantic import ConfigDict 1a
6from sqlalchemy.orm import Mapped, mapped_column 1a
8from .._model_base import BaseMixins, SqlAlchemyBase 1a
9from .._model_utils.auto_init import auto_init 1a
10from .._model_utils.guid import GUID 1a
11from ..recipe.ingredient import households_to_ingredient_foods 1a
12from ..recipe.tool import households_to_tools 1a
13from .household_to_recipe import HouseholdToRecipe 1a
15if TYPE_CHECKING: 15 ↛ 16line 15 didn't jump to line 16 because the condition on line 15 was never true1a
16 from ..group import Group
17 from ..recipe import IngredientFoodModel, RecipeModel, Tool
18 from ..users import User
19 from . import (
20 CookBook,
21 GroupEventNotifierModel,
22 GroupInviteToken,
23 GroupRecipeAction,
24 GroupWebhooksModel,
25 HouseholdPreferencesModel,
26 )
29class Household(SqlAlchemyBase, BaseMixins): 1a
30 __tablename__ = "households" 1a
31 __table_args__ = ( 1a
32 sa.UniqueConstraint("group_id", "name", name="household_name_group_id_key"),
33 sa.UniqueConstraint("group_id", "slug", name="household_slug_group_id_key"),
34 )
36 id: Mapped[GUID] = mapped_column(GUID, primary_key=True, default=GUID.generate) 1a
37 name: Mapped[str] = mapped_column(sa.String, index=True, nullable=False) 1a
38 slug: Mapped[str | None] = mapped_column(sa.String, index=True) 1a
40 invite_tokens: Mapped[list["GroupInviteToken"]] = orm.relationship( 1a
41 "GroupInviteToken", back_populates="household", cascade="all, delete-orphan"
42 )
43 preferences: Mapped["HouseholdPreferencesModel"] = orm.relationship( 1a
44 "HouseholdPreferencesModel",
45 back_populates="household",
46 uselist=False,
47 single_parent=True,
48 cascade="all, delete-orphan",
49 )
51 group_id: Mapped[GUID] = mapped_column(GUID, sa.ForeignKey("groups.id"), nullable=False, index=True) 1a
52 group: Mapped["Group"] = orm.relationship("Group", back_populates="households") 1a
53 users: Mapped[list["User"]] = orm.relationship("User", back_populates="household") 1a
55 COMMON_ARGS = { 1a
56 "back_populates": "household",
57 "cascade": "all, delete-orphan",
58 "single_parent": True,
59 }
61 recipe_actions: Mapped[list["GroupRecipeAction"]] = orm.relationship("GroupRecipeAction", **COMMON_ARGS) 1a
62 cookbooks: Mapped[list["CookBook"]] = orm.relationship("CookBook", **COMMON_ARGS) 1a
64 webhooks: Mapped[list["GroupWebhooksModel"]] = orm.relationship("GroupWebhooksModel", **COMMON_ARGS) 1a
65 group_event_notifiers: Mapped[list["GroupEventNotifierModel"]] = orm.relationship( 1a
66 "GroupEventNotifierModel", **COMMON_ARGS
67 )
69 made_recipes: Mapped[list["RecipeModel"]] = orm.relationship( 1a
70 "RecipeModel", secondary=HouseholdToRecipe.__tablename__, back_populates="made_by"
71 )
72 ingredient_foods_on_hand: Mapped[list["IngredientFoodModel"]] = orm.relationship( 1a
73 "IngredientFoodModel",
74 secondary=households_to_ingredient_foods,
75 back_populates="households_with_ingredient_food",
76 )
77 tools_on_hand: Mapped[list["Tool"]] = orm.relationship( 1a
78 "Tool", secondary=households_to_tools, back_populates="households_with_tool"
79 )
81 model_config = ConfigDict( 1a
82 exclude={
83 "users",
84 "webhooks",
85 "recipe_actions",
86 "cookbooks",
87 "preferences",
88 "invite_tokens",
89 "group_event_notifiers",
90 "group",
91 "made_recipes",
92 }
93 )
95 @auto_init() 1a
96 def __init__(self, **_) -> None: 1a
97 pass 1ab