File size: 1,470 Bytes
507973e
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
"""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)