photo_record.py 908 B

1234567891011121314151617181920
  1. from sqlmodel import SQLModel, Field
  2. from datetime import datetime
  3. from typing import Optional
  4. import pytz
  5. TIME_ZONE = pytz.timezone("Asia/Shanghai")
  6. class PhotoRecord(SQLModel, table=True):
  7. __tablename__ = "photo_record"
  8. id: Optional[int] = Field(default=None, primary_key=True, index=True)
  9. action_id: Optional[int] = Field(default=None)
  10. goods_art_no: Optional[str] = Field(max_length=128, nullable=False)
  11. image_path: Optional[str] = Field(default=None)
  12. image_index: Optional[int] = Field(default=None)
  13. image_deal_mode: Optional[int] = Field(default=None)
  14. photo_create_time: Optional[datetime] = Field(default=None)
  15. update_time: Optional[datetime] = Field(
  16. default_factory=lambda: datetime.now(TIME_ZONE)
  17. )
  18. create_time: Optional[datetime] = Field(default_factory=lambda: datetime.now(TIME_ZONE))
  19. delete_time: Optional[datetime] = Field(default=None)