"""Versioned parsed resume profiles keyed by external candidate_id."""

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 _profile_id() -> str:
    return f"rprof-{uuid4().hex[:16]}"


class CandidateResumeProfileRecord(Base):
    """One versioned parsed resume snapshot for a Platform candidate."""

    __tablename__ = "candidate_resume_profiles"
    __table_args__ = (
        UniqueConstraint(
            "candidate_id",
            "content_hash",
            name="uq_resume_profile_candidate_hash",
        ),
        Index("ix_resume_profiles_candidate_version", "candidate_id", "resume_version"),
        Index("ix_resume_profiles_updated", "updated_at"),
    )

    profile_id = Column(String(64), primary_key=True, default=_profile_id)
    candidate_id = Column(String(128), nullable=False, index=True)
    company_id = Column(String(128), nullable=True, index=True)

    # Monotonic per candidate; latest is current
    resume_version = Column(Integer, nullable=False, default=1)
    content_hash = Column(String(64), nullable=False, index=True)

    source_url = Column(String(2048), nullable=True)
    filename = Column(String(512), nullable=True)
    document_type = Column(String(32), nullable=True)

    raw_text = Column(Text, nullable=True)
    structured = Column(JSON, nullable=False, default=dict)
    blocks = Column(JSON, nullable=False, default=list)
    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)
