"""DB persistence for face verification audits (metadata only)."""

from __future__ import annotations

import logging
from dataclasses import asdict

from app.database import SessionLocal
from app.models.gateway_persist import FaceVerificationAuditRecord
from app.services.face.audit_store import FaceAuditRecord

logger = logging.getLogger(__name__)


def _to_row_kwargs(rec: FaceAuditRecord) -> dict:
    return asdict(rec)


def upsert_audit(rec: FaceAuditRecord) -> None:
    db = SessionLocal()
    try:
        row = db.get(FaceVerificationAuditRecord, rec.audit_id)
        data = _to_row_kwargs(rec)
        if row is None:
            row = FaceVerificationAuditRecord(**data)
            db.add(row)
        else:
            for k, v in data.items():
                setattr(row, k, v)
        db.commit()
    except Exception:
        db.rollback()
        raise
    finally:
        db.close()


def list_for_interview(interview_id: str) -> list[FaceAuditRecord]:
    db = SessionLocal()
    try:
        rows = (
            db.query(FaceVerificationAuditRecord)
            .filter(FaceVerificationAuditRecord.interview_id == interview_id)
            .order_by(FaceVerificationAuditRecord.created_at.asc())
            .all()
        )
        fields = FaceAuditRecord.__dataclass_fields__
        out: list[FaceAuditRecord] = []
        for row in rows:
            data = {k: getattr(row, k, None) for k in fields}
            out.append(FaceAuditRecord(**data))
        return out
    except Exception as exc:  # noqa: BLE001
        logger.warning("DB list face audits failed for %s: %s", interview_id, exc)
        return []
    finally:
        db.close()


def count_for_interview(interview_id: str) -> int:
    db = SessionLocal()
    try:
        return (
            db.query(FaceVerificationAuditRecord)
            .filter(FaceVerificationAuditRecord.interview_id == interview_id)
            .count()
        )
    except Exception as exc:  # noqa: BLE001
        logger.warning("DB count face audits failed for %s: %s", interview_id, exc)
        return 0
    finally:
        db.close()
