""" auth/models.py — SQLAlchemy ORM models for users, sessions, and audit logs. """ import uuid from datetime import datetime from sqlalchemy import ( BigInteger, Boolean, Column, DateTime, ForeignKey, Index, Integer, String, Text, ) from sqlalchemy.orm import relationship from auth.database import Base class User(Base): __tablename__ = "users" id = Column(String, primary_key=True, default=lambda: str(uuid.uuid4())) username = Column(String(100), unique=True, nullable=False, index=True) email = Column(String(200), unique=True, nullable=True) hashed_password = Column(Text, nullable=False) full_name = Column(String(200), nullable=True) role = Column(String(50), nullable=False, default="tester") # 'tester' | 'admin' | 'manager' is_active = Column(Boolean, nullable=False, default=True) created_at = Column(DateTime, nullable=False, default=datetime.utcnow) last_login_at = Column(DateTime, nullable=True) sessions = relationship("UserSession", back_populates="user", cascade="all, delete-orphan") audit_logs = relationship("AuditLog", back_populates="user") def __repr__(self) -> str: return f"" class UserSession(Base): __tablename__ = "user_sessions" id = Column(String, primary_key=True, default=lambda: str(uuid.uuid4())) user_id = Column(String, ForeignKey("users.id"), nullable=False, index=True) token_jti = Column(String(200), unique=True, nullable=False) # JWT jti claim created_at = Column(DateTime, nullable=False, default=datetime.utcnow) expires_at = Column(DateTime, nullable=False) is_revoked = Column(Boolean, nullable=False, default=False) ip_address = Column(String(50), nullable=True) user_agent = Column(Text, nullable=True) user = relationship("User", back_populates="sessions") def __repr__(self) -> str: return f"" class AuditLog(Base): __tablename__ = "audit_logs" id = Column(BigInteger, primary_key=True, autoincrement=True) user_id = Column(String, ForeignKey("users.id"), nullable=True, index=True) username = Column(String(100), nullable=True) # denormalised copy action = Column(String(200), nullable=False) resource_type = Column(String(100), nullable=True) resource_id = Column(String(200), nullable=True) http_method = Column(String(10), nullable=True) endpoint = Column(String(300), nullable=True) request_summary = Column(Text, nullable=True) response_status = Column(Integer, nullable=True) ip_address = Column(String(50), nullable=True) user_agent = Column(Text, nullable=True) occurred_at = Column(DateTime, nullable=False, default=datetime.utcnow, index=True) duration_ms = Column(Integer, nullable=True) # ── UAT audit enrichments ───────────────────────────────────────────────── extra_data = Column(Text, nullable=True) # JSON blob: file names, tx counts, export format … session_duration_seconds = Column(Integer, nullable=True) # login→logout delta (set on logout) user = relationship("User", back_populates="audit_logs") def __repr__(self) -> str: return f""