"""
BUFF 选品配置表模型：用户检索条件 + 选品条件，支持多套配置与默认配置
"""
from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Boolean, Text
from app.database import Base
from app.utils.timezone import beijing_now_naive


class BuffSelectionConfig(Base):
    """BUFF 选品配置表"""
    __tablename__ = "buff_selection_config"

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
    user_id = Column(Integer, nullable=False, comment="用户ID，关联 users.id")
    name = Column(String(64), nullable=False, comment="配置名称，同用户下未删除时唯一")
    config_json = Column(Text, nullable=False, comment="整份配置 JSON：检索条件+选品条件")
    is_default = Column(Boolean, nullable=False, default=False, comment="是否默认配置：同用户至多一个为 True")
    is_deleted = Column(Boolean, nullable=False, default=False, comment="软删：0-否，1-是")
    created_at = Column(DateTime, default=beijing_now_naive, comment="创建时间")
    updated_at = Column(DateTime, default=beijing_now_naive, onupdate=beijing_now_naive, comment="更新时间")