Spaces:
Running on Zero
Running on Zero
| from datetime import date, datetime | |
| from typing import Optional | |
| from sqlalchemy import BigInteger, Boolean, Date, DateTime, Integer, String, func | |
| from sqlalchemy.orm import Mapped, mapped_column | |
| from app.db.base import Base | |
| class User(Base): | |
| __tablename__ = "users" | |
| id: Mapped[int] = mapped_column(BigInteger, primary_key=True, autoincrement=False) | |
| username: Mapped[Optional[str]] = mapped_column(String(64)) | |
| full_name: Mapped[str] = mapped_column(String(256), default="") | |
| lang: Mapped[str] = mapped_column(String(2), default="am") | |
| stream: Mapped[Optional[str]] = mapped_column(String(16)) | |
| year: Mapped[Optional[int]] = mapped_column(Integer) | |
| referred_by: Mapped[Optional[int]] = mapped_column(BigInteger) | |
| gate_passed: Mapped[bool] = mapped_column(Boolean, default=False) | |
| points: Mapped[int] = mapped_column(Integer, default=0) | |
| streak: Mapped[int] = mapped_column(Integer, default=0, server_default="0") | |
| best_streak: Mapped[int] = mapped_column(Integer, default=0, server_default="0") | |
| last_active_on: Mapped[Optional[date]] = mapped_column(Date) | |
| active_days: Mapped[int] = mapped_column(Integer, default=0, server_default="0") | |
| week_key: Mapped[Optional[str]] = mapped_column(String(8)) | |
| week_xp: Mapped[int] = mapped_column(Integer, default=0, server_default="0") | |
| day_key: Mapped[Optional[str]] = mapped_column(String(10)) | |
| day_xp: Mapped[int] = mapped_column(Integer, default=0, server_default="0") | |
| trust: Mapped[int] = mapped_column(Integer, default=100, server_default="100") | |
| source: Mapped[Optional[str]] = mapped_column(String(24)) # where they came from (poster, inline, referral...) | |
| pending_link: Mapped[Optional[str]] = mapped_column(String(16)) # deep link to open after joining/onboarding | |
| share_prompt_day: Mapped[Optional[str]] = mapped_column(String(10)) # last day we suggested sharing | |
| credit_name: Mapped[bool] = mapped_column(Boolean, default=False, server_default="false") # name on files they give | |
| gate_missing: Mapped[Optional[str]] = mapped_column(String(80)) # which join-gate places they were last missing | |
| is_banned: Mapped[bool] = mapped_column(Boolean, default=False) | |
| created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now()) | |