"""
BUFF 扫货请求单-扫货日志模型：记录每个饰品的扫货判断过程。
"""
from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Numeric, Boolean
from app.database import Base
from app.utils.timezone import beijing_now_naive


class BuffSweepRequestLog(Base):
    """BUFF 扫货请求单-扫货日志表"""
    __tablename__ = "buff_sweep_request_log"

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
    sweep_request_id = Column(BigInteger, nullable=False, index=True, comment="扫货请求单ID")
    user_id = Column(Integer, nullable=False, index=True, comment="用户ID")
    goods_id = Column(String(64), nullable=False, comment="BUFF饰品ID")
    goods_name = Column(String(256), nullable=True, comment="饰品名称")
    sequence_no = Column(Integer, nullable=False, default=0, comment="处理序号")
    result = Column(
        String(32),
        nullable=False,
        comment="结果：success-成功购买, skipped-跳过, failed-失败, stopped-已停止",
    )
    message = Column(String(512), nullable=True, comment="日志描述")
    retry_attempts = Column(Integer, nullable=False, default=0, comment="代理重试次数")
    proxy_refreshed = Column(Boolean, nullable=False, default=False, comment="是否刷新过代理")
    target_price_usd = Column(Numeric(12, 2), nullable=True, comment="目标扫货价（美元）")
    purchase_price_usd = Column(Numeric(12, 2), nullable=True, comment="实际购买价（美元）")
    created_at = Column(DateTime, default=beijing_now_naive, comment="创建时间")