"""DB persistence for ID verification status (no image bytes)."""

from __future__ import annotations

import logging
from dataclasses import asdict

from app.database import SessionLocal
from app.models.gateway_persist import IdVerificationRecordRow
from app.services.id.status_store import IdVerificationRecord

logger = logging.getLogger(__name__)


def upsert_record(rec: IdVerificationRecord) -> None:
    db = SessionLocal()
    try:
        data = asdict(rec)
        row = db.get(IdVerificationRecordRow, rec.verification_id)
        if row is None:
            row = IdVerificationRecordRow(**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 get_record(verification_id: str) -> IdVerificationRecord | None:
    db = SessionLocal()
    try:
        row = db.get(IdVerificationRecordRow, verification_id)
        if row is None:
            return None
        fields = IdVerificationRecord.__dataclass_fields__
        return IdVerificationRecord(**{k: getattr(row, k, None) for k in fields})
    except Exception as exc:  # noqa: BLE001
        logger.warning("DB get ID verification failed %s: %s", verification_id, exc)
        return None
    finally:
        db.close()


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