"""LEGACY — interview session checkpoints (Postgres).

Public ``/interviews/sessions/*`` APIs were removed (Platform owns live sessions).
This table is retained for historical rows / possible re-enable; Gateway HTTP
paths no longer write to it. Prefer not to DROP without an explicit migration.
"""

from __future__ import annotations

from datetime import datetime

from sqlalchemy import Boolean, Column, DateTime, Float, Integer, JSON, String, Text

from app.database import Base


class InterviewSessionRecord(Base):
    """LEGACY durable live-interview checkpoint (unused by current public APIs).

    ``owner_id`` / platform refs are plain strings — no FK into Prisma User tables.
    """

    __tablename__ = "interview_sessions"

    interview_id = Column(String(128), primary_key=True)
    role_title = Column(String(512), nullable=False, default="")
    job_description = Column(Text, nullable=False, default="")
    persona = Column(String(128), nullable=False, default="technical")
    language = Column(String(16), nullable=False, default="en")

    status = Column(String(32), nullable=False, default="active", index=True)
    phase = Column(String(64), nullable=False, default="awaiting_answer")
    turn_count = Column(Integer, nullable=False, default=0)
    last_score = Column(Float, nullable=True)

    face_verified = Column(Boolean, nullable=False, default=False)
    face_audit_id = Column(String(128), nullable=True)
    face_verified_at = Column(String(64), nullable=True)

    access_token = Column(String(256), nullable=True)
    owner_id = Column(String(128), nullable=True, index=True)

    max_follow_ups_per_question = Column(Integer, nullable=False, default=1)
    follow_up_score_threshold = Column(Float, nullable=False, default=0.75)

    skills_focus = Column(JSON, nullable=False, default=list)
    planned_questions = Column(JSON, nullable=False, default=list)
    asked_question_ids = Column(JSON, nullable=False, default=list)
    asked_question_texts_norm = Column(JSON, nullable=False, default=list)
    current_question = Column(JSON, nullable=True)
    transcript = Column(JSON, nullable=False, default=list)
    evaluations = Column(JSON, nullable=False, default=list)
    processed_answer_keys = Column(JSON, nullable=False, default=list)
    follow_ups_for_parent = Column(JSON, nullable=False, default=dict)

    checkpoint_version = Column(Integer, nullable=False, default=0)
    created_at = Column(DateTime(timezone=True), nullable=False)
    updated_at = Column(DateTime(timezone=True), nullable=False, index=True)
