"""Gateway-owned interview creation workflows (setup → persona → questions → preview).

Platform owns candidate CRM, scheduling, invitations. TJ stores AI workflow
config + questions keyed by external user/company/interview string refs.
"""

from __future__ import annotations

from datetime import datetime
from uuid import uuid4

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

from app.database import Base


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


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


class InterviewWorkflowRecord(Base):
    __tablename__ = "interview_workflows"
    __table_args__ = (
        Index("ix_interview_workflows_company_updated", "company_id", "updated_at"),
    )

    workflow_id = Column(String(64), primary_key=True, default=_workflow_id)
    company_id = Column(String(128), nullable=False, default="", index=True)
    user_id = Column(String(128), nullable=True, index=True)
    interview_id = Column(String(128), nullable=True, index=True)

    title = Column(String(512), nullable=False, default="")
    role_title = Column(String(512), nullable=False, default="")
    job_description = Column(Text, nullable=True)
    skills = Column(JSON, nullable=False, default=list)
    experience_level = Column(String(128), nullable=True)
    duration_minutes = Column(Integer, nullable=True)
    language = Column(String(32), nullable=False, default="en")
    difficulty = Column(String(32), nullable=False, default="medium")
    mode = Column(String(64), nullable=False, default="video")  # text|voice|video|AI
    persona_id = Column(String(128), nullable=True)

    status = Column(
        String(64),
        nullable=False,
        default="draft",
        index=True,
    )  # draft|persona_selected|questions_ready|preview_ready|ready_for_scheduling
    version = Column(Integer, nullable=False, default=1)
    meta = Column(JSON, nullable=False, default=dict)

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


class InterviewWorkflowQuestionRecord(Base):
    __tablename__ = "interview_workflow_questions"
    __table_args__ = (
        UniqueConstraint(
            "workflow_id",
            "question_id",
            name="uq_workflow_question_id",
        ),
        Index("ix_workflow_questions_position", "workflow_id", "position"),
    )

    id = Column(String(64), primary_key=True, default=_question_id)
    workflow_id = Column(String(64), nullable=False, index=True)
    question_id = Column(String(128), nullable=False)  # stable public id
    text = Column(Text, nullable=False, default="")
    question_type = Column(String(64), nullable=False, default="short_answer")
    skill = Column(String(256), nullable=True)
    difficulty = Column(String(32), nullable=True)
    category = Column(String(128), nullable=True)
    evaluation_criteria = Column(JSON, nullable=False, default=list)
    source = Column(String(32), nullable=False, default="ai")  # ai|custom
    position = Column(Integer, nullable=False, default=0)
    response_format = Column(String(64), nullable=True)
    response_time_seconds = Column(Integer, nullable=True)
    meta = Column(JSON, nullable=False, default=dict)

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