"""DB persistence for voice profile metadata."""

from __future__ import annotations

import logging
from dataclasses import asdict

from app.database import SessionLocal
from app.models.gateway_persist import VoiceProfileRecord
from app.services.voice.voice_store import VoiceProfile

logger = logging.getLogger(__name__)


def upsert_profile(profile: VoiceProfile) -> None:
    db = SessionLocal()
    try:
        data = asdict(profile)
        row = db.get(VoiceProfileRecord, profile.voice_id)
        if row is None:
            row = VoiceProfileRecord(**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_profile(voice_id: str) -> VoiceProfile | None:
    db = SessionLocal()
    try:
        row = db.get(VoiceProfileRecord, voice_id)
        if row is None:
            return None
        fields = VoiceProfile.__dataclass_fields__
        return VoiceProfile(**{k: getattr(row, k, None) for k in fields})
    except Exception as exc:  # noqa: BLE001
        logger.warning("DB get voice profile failed %s: %s", voice_id, exc)
        return None
    finally:
        db.close()
