"""Repository for wardrobe items.""" from __future__ import annotations import json from typing import Any from backend.dto.wardrobe_dto import WardrobeItem from database.db_helper import Database WARDROBE_COLUMNS = """ wardrobe_item_id, profile_id, material_id, wardrobe_category, tags_json, season, style, is_favorite, usage_count, last_used_at, created_at, updated_at """ WARDROBE_TABLES = frozenset({"wardrobe_items", "advanced_wardrobe_items"}) class WardrobeRepository: def __init__( self, database: Database, *, table_name: str = "wardrobe_items", library_kind: str = "standard", ): if table_name not in WARDROBE_TABLES: raise ValueError(f"unsupported wardrobe table: {table_name}") self.database = database self.table_name = table_name self.library_kind = library_kind @property def placeholder(self) -> str: return self.database._placeholder def create(self, payload: dict[str, Any]) -> WardrobeItem: placeholder = self.placeholder conn = self.database.connect() try: conn.execute( f""" INSERT INTO {self.table_name} ( wardrobe_item_id, profile_id, material_id, wardrobe_category, tags_json, season, style, is_favorite ) VALUES ( {placeholder}, {placeholder}, {placeholder}, {placeholder}, {placeholder}, {placeholder}, {placeholder}, {placeholder} ) """, ( payload["wardrobe_item_id"], payload["profile_id"], payload["material_id"], payload["wardrobe_category"], _json_or_none(payload.get("tags") or []), payload.get("season"), payload.get("style"), 1 if payload.get("is_favorite") else 0, ), ) conn.commit() finally: conn.close() item = self.get(payload["wardrobe_item_id"]) if item is None: raise RuntimeError("wardrobe item was inserted but could not be read back") return item def get(self, wardrobe_item_id: str) -> WardrobeItem | None: placeholder = self.placeholder conn = self.database.connect() try: row = conn.execute( f"SELECT {WARDROBE_COLUMNS} FROM {self.table_name} WHERE wardrobe_item_id = {placeholder}", (wardrobe_item_id,), ).fetchone() finally: conn.close() return _row_to_item(row, library_kind=self.library_kind) if row else None def list_by_profile(self, profile_id: str, wardrobe_category: str | None = None) -> list[WardrobeItem]: placeholder = self.placeholder where = [f"profile_id = {placeholder}"] params: list[Any] = [profile_id] if wardrobe_category: where.append(f"wardrobe_category = {placeholder}") params.append(wardrobe_category) conn = self.database.connect() try: rows = conn.execute( f""" SELECT {WARDROBE_COLUMNS} FROM {self.table_name} WHERE {" AND ".join(where)} ORDER BY is_favorite DESC, usage_count ASC, created_at ASC """, tuple(params), ).fetchall() finally: conn.close() return [_row_to_item(row, library_kind=self.library_kind) for row in rows] def delete(self, wardrobe_item_id: str) -> WardrobeItem | None: before = self.get(wardrobe_item_id) if before is None: return None placeholder = self.placeholder conn = self.database.connect() try: conn.execute(f"DELETE FROM {self.table_name} WHERE wardrobe_item_id = {placeholder}", (wardrobe_item_id,)) conn.commit() finally: conn.close() return before def mark_used(self, wardrobe_item_id: str) -> WardrobeItem | None: placeholder = self.placeholder conn = self.database.connect() try: conn.execute( f""" UPDATE {self.table_name} SET usage_count = usage_count + 1, last_used_at = CURRENT_TIMESTAMP, updated_at = CURRENT_TIMESTAMP WHERE wardrobe_item_id = {placeholder} """, (wardrobe_item_id,), ) conn.commit() finally: conn.close() return self.get(wardrobe_item_id) class AdvancedWardrobeRepository(WardrobeRepository): """Wardrobe storage whose material FK targets verified advanced assets.""" def __init__(self, database: Database): super().__init__( database, table_name="advanced_wardrobe_items", library_kind="advanced", ) def _row_to_item(row, *, library_kind: str = "standard") -> WardrobeItem: return WardrobeItem( wardrobe_item_id=row["wardrobe_item_id"], profile_id=row["profile_id"], material_id=row["material_id"], wardrobe_category=row["wardrobe_category"], tags=_json_loads_list(row["tags_json"]), season=row["season"], style=row["style"], is_favorite=bool(row["is_favorite"]), usage_count=int(row["usage_count"] or 0), last_used_at=str(row["last_used_at"]) if row["last_used_at"] else None, created_at=str(row["created_at"]), updated_at=str(row["updated_at"]), library_kind=library_kind, ) def _json_or_none(value: Any | None) -> str | None: if value is None: return None return json.dumps(value, ensure_ascii=False, sort_keys=True) def _json_loads_list(value: str | None) -> list[str]: if not value: return [] loaded = json.loads(value) return [str(item) for item in loaded] if isinstance(loaded, list) else []