"""
SQLAlchemy resume model (Phase 5).
"""
import uuid
from datetime import datetime, timezone

from sqlalchemy import Column, DateTime, Integer, String, Text

from app.core.db import Base


def _new_id() -> str:
    return f"res_{uuid.uuid4().hex[:12]}"


class ResumeRecord(Base):
    __tablename__ = "resumes"

    id = Column(String, primary_key=True, default=_new_id)
    session_id = Column(String, index=True, nullable=False)
    file_name = Column(String, nullable=False)
    file_path = Column(String, nullable=False)
    extracted_text = Column(Text, nullable=False)
    pages = Column(Integer, nullable=False)
    uploaded_at = Column(
        DateTime(timezone=True), 
        default=lambda: datetime.now(timezone.utc), 
        nullable=False
    )