Spaces:
Running
Running
File size: 2,701 Bytes
fba30db d23039a fba30db d23039a fba30db d23039a fba30db d23039a fba30db d23039a fba30db d23039a fba30db d23039a fba30db | 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 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | from datetime import datetime, timezone
from sqlalchemy import DateTime, ForeignKey, Index, Integer, String, Text
from sqlalchemy.orm import Mapped, mapped_column, relationship
from db.database import Base
class User(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(Integer, primary_key=True, index=True)
email: Mapped[str] = mapped_column(String(255), unique=True, index=True, nullable=False)
password_hash: Mapped[str] = mapped_column(String(255), nullable=False)
name: Mapped[str | None] = mapped_column(String(255), nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=lambda: datetime.now(timezone.utc))
analyses: Mapped[list["AnalysisRecord"]] = relationship(back_populates="user")
class AnalysisRecord(Base):
__tablename__ = "analyses"
id: Mapped[int] = mapped_column(Integer, primary_key=True, index=True)
user_id: Mapped[int | None] = mapped_column(
ForeignKey("users.id", ondelete="SET NULL"), nullable=True,
)
media_type: Mapped[str] = mapped_column(String(32), nullable=False) # image|video|text|screenshot
verdict: Mapped[str] = mapped_column(String(32), nullable=False)
authenticity_score: Mapped[float] = mapped_column(nullable=False)
result_json: Mapped[str] = mapped_column(Text, nullable=False)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=lambda: datetime.now(timezone.utc))
# Phase 19.1 / 19.2 — SHA-256 dedup + object storage
media_hash: Mapped[str | None] = mapped_column(String(64), nullable=True, index=True)
media_path: Mapped[str | None] = mapped_column(String(512), nullable=True)
thumbnail_url: Mapped[str | None] = mapped_column(String(512), nullable=True)
user: Mapped["User | None"] = relationship(back_populates="analyses")
report: Mapped["Report | None"] = relationship(back_populates="analysis", uselist=False)
__table_args__ = (
Index("ix_record_user_created", "user_id", "created_at"),
)
class Report(Base):
__tablename__ = "reports"
id: Mapped[int] = mapped_column(Integer, primary_key=True, index=True)
analysis_id: Mapped[int] = mapped_column(ForeignKey("analyses.id"), nullable=False)
file_path: Mapped[str] = mapped_column(String(512), nullable=False)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=lambda: datetime.now(timezone.utc))
expires_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True)
analysis: Mapped["AnalysisRecord"] = relationship(back_populates="report")
__table_args__ = (
Index("ix_report_analysis", "analysis_id"),
)
|