"""
BUFF 扫货请求单表模型：用户每次发起扫货生成一条请求单，按 user_id 隔离。
"""
from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Boolean
from app.database import Base
from app.utils.timezone import beijing_now_naive


class BuffSweepRequest(Base):
    """BUFF 扫货请求单表"""
    __tablename__ = "buff_sweep_request"

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
    user_id = Column(Integer, nullable=False, index=True, comment="用户ID，按用户隔离")
    selection_request_id = Column(
        BigInteger,
        nullable=False,
        index=True,
        comment="本次扫货基于的选品请求单ID（最新一次）",
    )
    status = Column(
        String(20),
        nullable=False,
        default="pending",
        comment="状态：pending/running/completed/failed/cancelled",
    )
    cancel_requested = Column(Boolean, nullable=False, default=False, comment="是否已请求停止")
    created_at = Column(DateTime, default=beijing_now_naive, comment="创建时间")
    updated_at = Column(DateTime, default=beijing_now_naive, onupdate=beijing_now_naive, comment="更新时间")