tasklert-api / src /models /stats.py
hashir-qt's picture
initial deploy
507973e
Raw History Blame Contribute Delete
1.47 kB
"""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)