Spaces:
Runtime error
Runtime error
| """`label_runs` table — audit trail of LLM-generated labels (PRD §7, §15).""" | |
| from __future__ import annotations | |
| from datetime import datetime | |
| from typing import Any | |
| from sqlalchemy import DateTime, Float, Index, Integer, String, func | |
| from sqlalchemy.orm import Mapped, mapped_column | |
| from app.database import Base, JSONType | |
| class LabelRun(Base): | |
| __tablename__ = "label_runs" | |
| __table_args__ = (Index("idx_label_runs_hash", "review_text_hash"),) | |
| id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True) | |
| review_text_hash: Mapped[str] = mapped_column(String(64), nullable=False) # sha256 hex | |
| labeler: Mapped[str] = mapped_column(String(100), nullable=False) | |
| experience_score: Mapped[float | None] = mapped_column(Float) | |
| aspects: Mapped[dict[str, Any] | None] = mapped_column(JSONType) | |
| has_irony: Mapped[bool | None] = mapped_column() | |
| review_quality: Mapped[str | None] = mapped_column(String(10)) | |
| raw_response: Mapped[dict[str, Any] | None] = mapped_column(JSONType) | |
| created_at: Mapped[datetime] = mapped_column( | |
| DateTime(timezone=True), server_default=func.now(), nullable=False | |
| ) | |