from __future__ import annotations import enum import uuid from datetime import datetime, timezone from sqlalchemy import Boolean, DateTime, Enum, String from sqlalchemy.orm import Mapped, mapped_column from .base import Base class UserRole(str, enum.Enum): admin = "admin" operator = "operator" viewer = "viewer" class User(Base): __tablename__ = "users" id: Mapped[str] = mapped_column(String(36), primary_key=True, default=lambda: str(uuid.uuid4())) username: Mapped[str] = mapped_column(String(64), unique=True, nullable=False) email: Mapped[str] = mapped_column(String(255), unique=True, nullable=False) password_hash: Mapped[str] = mapped_column(String(255), nullable=False) role: Mapped[UserRole] = mapped_column(Enum(UserRole), nullable=False, default=UserRole.viewer) created_at: Mapped[datetime] = mapped_column( DateTime(timezone=True), nullable=False, default=lambda: datetime.now(timezone.utc) ) is_active: Mapped[bool] = mapped_column(Boolean, nullable=False, default=True)