Spaces:
Sleeping
Sleeping
Download src/models/stats.py from hashir-qt/tasklert-api: direct link, hf CLI and curl.
- Browser
- Download file 1.47 kB
-
https://huggingface.co/spaces/hashir-qt/tasklert-api/resolve/main/src/models/stats.py
- Command line
-
hf download hf://spaces/hashir-qt/tasklert-api/src/models/stats.py
-
curl -L -o stats.py https://huggingface.co/spaces/hashir-qt/tasklert-api/resolve/main/src/models/stats.py
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) | |