from sqlalchemy import Column, ForeignKey, String, Integer
from sqlalchemy.dialects.mysql import BIGINT, INTEGER, TINYINT, VARCHAR, TEXT
from sqlalchemy.orm import relationship
from app.db.base_class import Base

class GeneratedTattooHistory(Base):
    __tablename__ = "generated_tattoo_history"

    history_id = Column(INTEGER, primary_key=True, autoincrement=True)
    user_id = Column(INTEGER, ForeignKey("users.user_id"), nullable=True, index=True)
    user_device_id = Column(
        INTEGER,
        ForeignKey("user_devices.user_device_id", ondelete="SET NULL", onupdate="CASCADE"),
        nullable=True,
        index=True
    )

    name = Column(VARCHAR(255), nullable=True)
    search_name = Column(VARCHAR(255), nullable=True)
    image_url = Column(VARCHAR(8192), nullable=False)
    bg_url = Column(TEXT, nullable=True)
    tattoo_type = Column(VARCHAR(255), nullable=True)
    category_type = Column(VARCHAR(255), nullable=True)
    is_delete = Column(TINYINT(1), nullable=False, default=0)
    is_history = Column(TINYINT(1), nullable=False, default=1)
    is_template = Column(TINYINT(1), nullable=True, default=1)
    tattoo_style_id = Column(INTEGER(11), nullable=True, default=None)
    created_at = Column(BIGINT, nullable=False)
    updated_at = Column(BIGINT, nullable=False)

    placement_name = Column(VARCHAR(255), nullable=True)
    text_content = Column(TEXT, nullable=True)
    font_family = Column(VARCHAR(255), nullable=True)
    size = Column(INTEGER, nullable=True)
    alignment = Column(VARCHAR(50), nullable=True)
    color = Column(VARCHAR(50), nullable=True)
    color_name = Column(VARCHAR(100), nullable=True)

    # Relationships
    user = relationship("User", back_populates="histories")
    user_device = relationship("UserDevice", back_populates="tattoo_histories")

    def __repr__(self) -> str:
        return f"<GeneratedTattooHistory id={self.history_id} user_id={self.user_id} device_id={self.user_device_id}>"
