"""Voice domain — SQLAlchemy models (policy owned by Core)."""
from __future__ import annotations

from datetime import datetime
from typing import Optional
from uuid import UUID, uuid4

from sqlalchemy import Boolean, ForeignKey, Integer, String, Text, UniqueConstraint
from sqlalchemy.dialects.postgresql import JSONB, UUID as PGUUID
from sqlalchemy.orm import Mapped, mapped_column
from sqlalchemy.sql import func
from sqlalchemy.types import DateTime

from src.core.database import Base


class ProjectVoiceConfig(Base):
    """One row per project. Cloud executes; this row is the entitlement snapshot."""

    __tablename__ = "project_voice_config"

    id: Mapped[UUID] = mapped_column(PGUUID(as_uuid=True), primary_key=True, default=uuid4)
    project_id: Mapped[UUID] = mapped_column(
        PGUUID(as_uuid=True),
        ForeignKey("projects.id", ondelete="CASCADE"),
        nullable=False,
        unique=True,
    )
    enabled: Mapped[bool] = mapped_column(Boolean, nullable=False, default=False)
    billing_mode: Mapped[str] = mapped_column(String(16), nullable=False, default="managed")
    credential_ref: Mapped[Optional[str]] = mapped_column(String(128), nullable=True)
    max_concurrent_calls: Mapped[int] = mapped_column(Integer, nullable=False, default=1)
    default_agent_id: Mapped[Optional[UUID]] = mapped_column(PGUUID(as_uuid=True), nullable=True)
    updated_at: Mapped[datetime] = mapped_column(
        DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
    )


class ProjectVoiceAgent(Base):
    """Versioned voice agent config pushed to Cloud as a snapshot at call authorize time."""

    __tablename__ = "project_voice_agents"

    id: Mapped[UUID] = mapped_column(PGUUID(as_uuid=True), primary_key=True, default=uuid4)
    project_id: Mapped[UUID] = mapped_column(
        PGUUID(as_uuid=True),
        ForeignKey("projects.id", ondelete="CASCADE"),
        nullable=False,
        index=True,
    )
    name: Mapped[str] = mapped_column(String(128), nullable=False)
    version: Mapped[str] = mapped_column(String(32), nullable=False, default="1")
    provider: Mapped[str] = mapped_column(String(32), nullable=False, default="openai_realtime")
    model: Mapped[Optional[str]] = mapped_column(String(128), nullable=True)
    voice: Mapped[Optional[str]] = mapped_column(String(64), nullable=True)
    instructions: Mapped[Optional[str]] = mapped_column(Text, nullable=True)
    tools_json: Mapped[Optional[list]] = mapped_column(JSONB, nullable=True)
    transfer_targets_json: Mapped[Optional[list]] = mapped_column(JSONB, nullable=True)
    secret_ref: Mapped[Optional[str]] = mapped_column(String(128), nullable=True)
    status: Mapped[str] = mapped_column(String(20), nullable=False, default="active")
    updated_at: Mapped[datetime] = mapped_column(
        DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
    )


class ProjectPhoneNumber(Base):
    """E.164 inventory. Inbound routing decides which agent answers."""

    __tablename__ = "project_phone_numbers"

    id: Mapped[UUID] = mapped_column(PGUUID(as_uuid=True), primary_key=True, default=uuid4)
    project_id: Mapped[UUID] = mapped_column(
        PGUUID(as_uuid=True),
        ForeignKey("projects.id", ondelete="CASCADE"),
        nullable=False,
        index=True,
    )
    e164: Mapped[str] = mapped_column(String(32), nullable=False)
    provider: Mapped[str] = mapped_column(String(32), nullable=False, default="twilio")
    provider_sid: Mapped[Optional[str]] = mapped_column(String(64), nullable=True)
    inbound_agent_id: Mapped[Optional[UUID]] = mapped_column(PGUUID(as_uuid=True), nullable=True)
    outbound_agent_id: Mapped[Optional[UUID]] = mapped_column(PGUUID(as_uuid=True), nullable=True)
    status: Mapped[str] = mapped_column(String(20), nullable=False, default="active")
    updated_at: Mapped[datetime] = mapped_column(
        DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
    )

    __table_args__ = (
        UniqueConstraint("project_id", "e164", name="uq_project_phone_e164"),
    )