"""人格版本模型。"""

from datetime import datetime

from sqlalchemy import DateTime, ForeignKey, Integer, String, Text
from sqlalchemy.orm import Mapped, mapped_column

from app.core.ids import new_personality_id, new_personality_proposal_id
from app.core.time import utc_now
from app.db.base import Base


class PersonalityVersion(Base):
    __tablename__ = "personality_versions"

    id: Mapped[str] = mapped_column(String(80), primary_key=True, default=new_personality_id)
    character_id: Mapped[str] = mapped_column(String(80), ForeignKey("characters.id"), index=True)
    version: Mapped[int] = mapped_column(Integer, nullable=False, default=1)
    identity_profile: Mapped[str] = mapped_column(Text, nullable=False)
    role_destiny: Mapped[str] = mapped_column(Text, nullable=False, default="")
    personality_seed: Mapped[str] = mapped_column(Text, nullable=False, default="")
    traits: Mapped[str] = mapped_column(Text, nullable=False, default="{}")
    expression_style: Mapped[str] = mapped_column(Text, nullable=False, default="")
    values: Mapped[str] = mapped_column(Text, nullable=False, default="{}")
    relationship_pattern: Mapped[str] = mapped_column(Text, nullable=False, default="")
    emotion_baseline: Mapped[str] = mapped_column(Text, nullable=False, default="{}")
    reason: Mapped[str] = mapped_column(Text, nullable=False, default="system_seed")
    evidence_ids_json: Mapped[str] = mapped_column(Text, nullable=False, default="[]")
    created_by: Mapped[str] = mapped_column(String(80), nullable=False, default="system")
    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=utc_now)
    rolled_back_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True))


class PersonalityProposal(Base):
    """灵核枢人格修改建议（契约字典 §10.6 candidate.status；api-spec §11）。

    提议提交后为 ``pending``，经审核批准后派生新人格版本（status=``applied``），
    驳回则标记 ``rejected``；本地单用户边界下审核者即用户，写操作均记审计。
    """

    __tablename__ = "personality_proposals"

    id: Mapped[str] = mapped_column(
        String(80), primary_key=True, default=new_personality_proposal_id
    )
    character_id: Mapped[str] = mapped_column(String(80), ForeignKey("characters.id"), index=True)
    fields_json: Mapped[str] = mapped_column(Text, nullable=False, default="{}")
    reason: Mapped[str] = mapped_column(Text, nullable=False)
    status: Mapped[str] = mapped_column(String(40), nullable=False, default="pending", index=True)
    resulting_version_id: Mapped[str | None] = mapped_column(
        String(80), ForeignKey("personality_versions.id")
    )
    reviewed_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True))
    reviewed_by: Mapped[str] = mapped_column(String(80), nullable=False, default="system")
    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=utc_now)