import uuid
from sqlalchemy import Boolean, ForeignKey, Index, String, UniqueConstraint
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.orm import Mapped, mapped_column, relationship
from infrastructure.database.base import Base, UUIDPrimaryKeyMixin, TimestampMixin


class EmojiPack(Base, UUIDPrimaryKeyMixin, TimestampMixin):
    __tablename__ = "emoji_packs"

    name: Mapped[str] = mapped_column(String(128), unique=True, index=True, nullable=False)
    title: Mapped[str] = mapped_column(String(255), nullable=False)
    is_animated: Mapped[bool] = mapped_column(Boolean, default=True, nullable=False)
    is_video: Mapped[bool] = mapped_column(Boolean, default=False, nullable=False)

    emojis: Mapped[list["CustomEmoji"]] = relationship("CustomEmoji", back_populates="pack", cascade="all, delete-orphan")


class CustomEmoji(Base, UUIDPrimaryKeyMixin, TimestampMixin):
    __tablename__ = "custom_emojis"

    pack_id: Mapped[uuid.UUID | None] = mapped_column(
        UUID(as_uuid=True),
        ForeignKey("emoji_packs.id", ondelete="SET NULL"),
        nullable=True,
        index=True,
    )
    # Stored as string to avoid JavaScript float64 precision loss (e.g. 5807868868886009920)
    custom_emoji_id: Mapped[str] = mapped_column(String(64), unique=True, index=True, nullable=False)
    name: Mapped[str] = mapped_column(String(100), nullable=False, index=True)
    fallback_emoji: Mapped[str] = mapped_column(String(16), default="✨", nullable=False)
    category: Mapped[str] = mapped_column(String(50), default="general", index=True, nullable=False)
    is_animated: Mapped[bool] = mapped_column(Boolean, default=True, nullable=False)

    pack: Mapped["EmojiPack | None"] = relationship("EmojiPack", back_populates="emojis")
