"""Persisted Phase-5 interview evaluations (text / voice / video).

Platform owns live sessions. Gateway stores structured final-evaluation
results keyed by candidate_id + interview_id for deterministic PDF reports.
"""

from __future__ import annotations

from datetime import datetime
from uuid import uuid4

from sqlalchemy import (
    Column,
    DateTime,
    Float,
    Index,
    Integer,
    JSON,
    String,
    Text,
    UniqueConstraint,
)

from app.database import Base


def _evaluation_id() -> str:
    return f"ieval-{uuid4().hex[:16]}"


class InterviewEvaluationRecord(Base):
    __tablename__ = "interview_evaluations"
    __table_args__ = (
        UniqueConstraint(
            "candidate_id",
            "interview_id",
            name="uq_interview_eval_candidate_interview",
        ),
        Index("ix_interview_eval_status", "evaluation_status"),
        Index("ix_interview_eval_updated", "updated_at"),
    )

    evaluation_id = Column(String(64), primary_key=True, default=_evaluation_id)
    candidate_id = Column(String(128), nullable=False, index=True)
    interview_id = Column(String(128), nullable=False, index=True)
    interview_mode = Column(String(32), nullable=False)  # text | voice | video
    company_name = Column(String(512), nullable=True)
    role_title = Column(String(512), nullable=False, default="")

    evaluation_status = Column(
        String(32),
        nullable=False,
        default="pending",
        index=True,
    )  # pending | processing | completed | failed
    processing_stage = Column(String(64), nullable=True)
    evaluation_version = Column(Integer, nullable=False, default=1)

    overall_score = Column(Float, nullable=True)
    competency_scores = Column(JSON, nullable=False, default=list)
    question_evaluations = Column(JSON, nullable=False, default=list)
    strengths = Column(JSON, nullable=False, default=list)
    improvement_areas = Column(JSON, nullable=False, default=list)
    evaluation_summary = Column(Text, nullable=True)
    final_recommendation = Column(JSON, nullable=True)
    result_payload = Column(JSON, nullable=True)

    transcription_refs = Column(JSON, nullable=False, default=list)
    video_analysis_refs = Column(JSON, nullable=False, default=list)
    meta = Column(JSON, nullable=False, default=dict)

    error_code = Column(String(128), nullable=True)
    error_message = Column(Text, nullable=True)

    created_at = Column(DateTime(timezone=True), nullable=False, default=datetime.utcnow)
    updated_at = Column(DateTime(timezone=True), nullable=False, default=datetime.utcnow)
