Coverage for opt/mealie/lib/python3.12/site-packages/mealie/db/models/labels.py: 85%

1from typing import TYPE_CHECKING 

2 

3from sqlalchemy import ForeignKey, String, UniqueConstraint, orm 

4from sqlalchemy.orm import Mapped, mapped_column 

5 

6from mealie.db.models._model_base import BaseMixins, SqlAlchemyBase 

7 

8from ._model_utils.auto_init import auto_init 

9from ._model_utils.guid import GUID 

10 

11if TYPE_CHECKING: 11 ↛ 12line 11 didn't jump to line 12 because the condition on line 11 was never true

12 from .group.group import Group 

13 from .household.shopping_list import ShoppingListItem, ShoppingListMultiPurposeLabel 

14 from .recipe import IngredientFoodModel 

15 

16 

17class MultiPurposeLabel(SqlAlchemyBase, BaseMixins): 

18 __tablename__ = "multi_purpose_labels" 

19 __table_args__ = (UniqueConstraint("name", "group_id", name="multi_purpose_labels_name_group_id_key"),) 

20 

21 id: Mapped[GUID] = mapped_column(GUID, default=GUID.generate, primary_key=True) 

22 name: Mapped[str] = mapped_column(String(255), nullable=False) 

23 color: Mapped[str] = mapped_column(String(10), nullable=False, default="") 

24 

25 group_id: Mapped[GUID] = mapped_column(GUID, ForeignKey("groups.id"), nullable=False, index=True) 

26 group: Mapped["Group"] = orm.relationship("Group", back_populates="labels") 

27 

28 shopping_list_items: Mapped["ShoppingListItem"] = orm.relationship("ShoppingListItem", back_populates="label") 

29 foods: Mapped["IngredientFoodModel"] = orm.relationship("IngredientFoodModel", back_populates="label") 

30 shopping_lists_label_settings: Mapped[list["ShoppingListMultiPurposeLabel"]] = orm.relationship( 

31 "ShoppingListMultiPurposeLabel", back_populates="label", cascade="all, delete, delete-orphan" 

32 ) 

33 

34 @auto_init() 

35 def __init__(self, **_) -> None: 

36 pass