| 1234567891011121314151617181920212223242526272829 |
- """
- 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="创建时间")
|
