from __future__ import annotations from datetime import datetime from enum import Enum from sqlalchemy import BigInteger, DateTime, Enum as SqlEnum, Index, String, Text from sqlalchemy.orm import Mapped, mapped_column, relationship from sakura_cloud.core.config import settings from sakura_cloud.db.base import Base from sakura_cloud.models.mixins import TimestampMixin, UUIDPrimaryKeyMixin class UserRole(str, Enum): ADMIN = "admin" SUPER_ADMIN = "super_admin" USER = "user" class User(UUIDPrimaryKeyMixin, TimestampMixin, Base): __tablename__ = "users" username: Mapped[str] = mapped_column(String(50), nullable=False, unique=True) email: Mapped[str] = mapped_column(String(100), nullable=False, unique=True) password_hash: Mapped[str] = mapped_column(String(255), nullable=False) avatar: Mapped[str | None] = mapped_column(Text, nullable=True) storage_used: Mapped[int] = mapped_column(BigInteger, default=0, nullable=False) storage_limit: Mapped[int] = mapped_column( BigInteger, default=lambda: settings.default_storage_limit_bytes, nullable=False, ) role: Mapped[UserRole] = mapped_column(SqlEnum(UserRole), default=UserRole.USER, nullable=False) is_active: Mapped[bool] = mapped_column(default=True, nullable=False, index=True) disabled_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True) disabled_reason: Mapped[str | None] = mapped_column(Text, nullable=True) token_version: Mapped[int] = mapped_column(default=0, nullable=False) reminder_enabled: Mapped[bool] = mapped_column(default=True, nullable=False) reminder_hour: Mapped[int] = mapped_column(default=9, nullable=False) reminder_minute: Mapped[int] = mapped_column(default=0, nullable=False) reminder_timezone: Mapped[str] = mapped_column(String(64), default="Asia/Shanghai", nullable=False) last_reminder_sent_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True) artworks = relationship("Artwork", back_populates="user", cascade="all, delete-orphan") novels = relationship("Novel", back_populates="user", cascade="all, delete-orphan") devices = relationship("Device", back_populates="user", cascade="all, delete-orphan") files = relationship("UserFile", back_populates="user", cascade="all, delete-orphan") creator_follows = relationship("CreatorFollow", back_populates="user", cascade="all, delete-orphan") update_alerts = relationship("UpdateAlert", back_populates="user", cascade="all, delete-orphan") push_device_tokens = relationship("PushDeviceToken", back_populates="user", cascade="all, delete-orphan") artwork_ocr_texts = relationship("ArtworkOcrText", back_populates="user", cascade="all, delete-orphan") __table_args__ = ( Index("idx_users_username", "username"), Index("idx_users_email", "email"), )