"""Gateway-owned candidate performance snapshots (AI eval + assessment attempts).

Platform owns CRM candidate rows, filters, and recruiter actions. TJ stores
only AI/assessment performance artifacts keyed by external ``candidate_id`` /
``company_id`` string refs — no FKs into Prisma tables.
"""

from __future__ import annotations

from datetime import datetime
from uuid import uuid4

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

from app.database import Base


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


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


class CandidateAiEvaluationRecord(Base):
    """Persisted AI Performance snapshot for a candidate (0–100 scores)."""

    __tablename__ = "candidate_ai_evaluations"
    __table_args__ = (
        UniqueConstraint(
            "company_id",
            "candidate_id",
            "source_key",
            name="uq_ai_eval_company_candidate_source",
        ),
        Index("ix_ai_eval_candidate_recorded", "candidate_id", "recorded_at"),
    )

    evaluation_id = Column(String(64), primary_key=True, default=_ai_eval_id)
    company_id = Column(String(128), nullable=False, default="", index=True)
    candidate_id = Column(String(128), nullable=False, index=True)
    # Stable upsert key: interview:<id> | scoring:<id> | ingest:<id>
    source_key = Column(String(256), nullable=False)
    source_type = Column(
        String(64),
        nullable=False,
        default="mock_interview",
        index=True,
    )  # mock_interview | recruiter_interview | candidate_scoring | ingest
    interview_id = Column(String(128), nullable=True, index=True)
    role_title = Column(String(512), nullable=True)

    overall_score = Column(Float, nullable=True)
    technical_score = Column(Float, nullable=True)
    confidence_score = Column(Float, nullable=True)
    communication_score = Column(Float, nullable=True)
    culture_fit_score = Column(Float, nullable=True)
    match_percent = Column(Float, nullable=True)

    recommendation_label = Column(String(64), nullable=True)
    recommendation_display = Column(String(128), nullable=True)
    recommendation_confidence = Column(Float, nullable=True)

    strengths = Column(JSON, nullable=False, default=list)
    growth_areas = Column(JSON, nullable=False, default=list)
    verified_skills = Column(JSON, nullable=False, default=list)
    meta = Column(JSON, nullable=False, default=dict)

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


class CandidateAssessmentAttemptRecord(Base):
    """Persisted assessment attempt for a candidate (0–100 score + status)."""

    __tablename__ = "candidate_assessment_attempts"
    __table_args__ = (
        UniqueConstraint(
            "company_id",
            "candidate_id",
            "assessment_id",
            "attempt_number",
            name="uq_assessment_attempt_identity",
        ),
        Index("ix_assessment_attempt_candidate", "candidate_id", "recorded_at"),
    )

    attempt_id = Column(String(64), primary_key=True, default=_attempt_id)
    company_id = Column(String(128), nullable=False, default="", index=True)
    candidate_id = Column(String(128), nullable=False, index=True)
    assessment_id = Column(String(128), nullable=False, index=True)
    attempt_number = Column(Integer, nullable=False, default=1)
    kind = Column(String(64), nullable=True)
    role_title = Column(String(512), nullable=True)

    score = Column(Float, nullable=True)
    status = Column(
        String(32),
        nullable=False,
        default="in_progress",
        index=True,
    )  # not_started | in_progress | passed | failed | expired
    passed = Column(Boolean, nullable=True)
    skill_scores = Column(JSON, nullable=False, default=list)
    feedback_markdown = Column(Text, nullable=True)
    meta = Column(JSON, nullable=False, default=dict)

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