"""Phase V stats models: heatmap, streaks, achievements.""" from datetime import date as Date, datetime from typing import Optional from sqlalchemy import UniqueConstraint from sqlmodel import Field, SQLModel class DailyCompletion(SQLModel, table=True): __tablename__ = "daily_completion" __table_args__ = (UniqueConstraint("user_id", "date"),) id: int | None = Field(default=None, primary_key=True) user_id: str = Field(foreign_key="user.id", index=True) date: Date = Field(index=True) # YYYY-MM-DD calendar date count: int = Field(default=0) class UserStats(SQLModel, table=True): __tablename__ = "user_stats" id: int | None = Field(default=None, primary_key=True) user_id: str = Field(foreign_key="user.id", unique=True, index=True) total_completed: int = Field(default=0) current_streak: int = Field(default=0) longest_streak: int = Field(default=0) last_active_date: Optional[Date] = Field(default=None) updated_at: datetime = Field(default_factory=datetime.utcnow) class Achievement(SQLModel, table=True): __tablename__ = "achievement" __table_args__ = (UniqueConstraint("user_id", "achievement_type"),) id: int | None = Field(default=None, primary_key=True) user_id: str = Field(foreign_key="user.id", index=True) achievement_type: str # on_fire | centurion | speed_runner | night_owl | planner | consistent unlocked_at: datetime = Field(default_factory=datetime.utcnow)