"""DB metadata for evaluation PDF reports (files stay on disk)."""

from __future__ import annotations

import logging
from datetime import datetime, timezone
from pathlib import Path
from typing import Any

from app.database import SessionLocal
from app.models.gateway_persist import EvaluationReportRecord

logger = logging.getLogger(__name__)


def upsert_report(
    *,
    report_id: str,
    storage_path: str,
    interview_id: str | None = None,
    summary_markdown: str | None = None,
    candidate_name: str | None = None,
    role_title: str | None = None,
    company_name: str | None = None,
    meta: dict[str, Any] | None = None,
) -> None:
    db = SessionLocal()
    try:
        row = db.get(EvaluationReportRecord, report_id)
        if row is None:
            row = EvaluationReportRecord(
                report_id=report_id,
                created_at=datetime.now(timezone.utc),
            )
            db.add(row)
        row.storage_path = storage_path
        row.interview_id = interview_id
        row.summary_markdown = summary_markdown
        row.candidate_name = candidate_name
        row.role_title = role_title
        row.company_name = company_name
        row.meta = meta or {}
        db.commit()
    except Exception:
        db.rollback()
        raise
    finally:
        db.close()


def get_storage_path(report_id: str) -> str | None:
    db = SessionLocal()
    try:
        row = db.get(EvaluationReportRecord, report_id)
        return row.storage_path if row else None
    except Exception as exc:  # noqa: BLE001
        logger.warning("DB get report path failed %s: %s", report_id, exc)
        return None
    finally:
        db.close()


def upsert_from_pdf_path(pdf_path: Path, *, interview_id: str | None = None) -> str:
    """Register an existing PDF file. Returns report_id (stem)."""
    report_id = pdf_path.stem
    upsert_report(
        report_id=report_id,
        storage_path=str(pdf_path.resolve()),
        interview_id=interview_id,
        meta={"imported": True},
    )
    return report_id
