usermod/crud.py

from sqlalchemy import Column, String, Float, Integer, DateTime, func
from Utils.CrudUtils import auto_create_crud
from Utils.SqlAlchemyUtils import Base


class ItemModel(Base):
    __tablename__ = 'items'
    id = Column(Integer, primary_key=True, index=True)
    thickness = Column(Float)
    mass = Column(Float)
    color = Column(String(32))
    type = Column(String(32))
    create_time = Column(DateTime, server_default=func.now(), comment='创建时间')
    update_time = Column(DateTime, server_default=func.now(), onupdate=func.now(), comment='修改时间')

    def to_dict(self):
        return {c.name: getattr(self, c.name) for c in self.__table__.columns}


item_crud = auto_create_crud(ItemModel, 'item', '条目')