有没有可能在SQLAlchemy中创建一个列,该列在上次插入/更新时会自动填充时间?
我创建了模型,继承自基类
class Base(object):
def __tablename__(self):
return self.__name__.lower()
id = Column(Integer, primary_key=True)
last_time = Column(TIMESTAMP, server_default=func.now())
Base = declarative_base(cls=Base)
class EntityModel(Base):
__tablename__ = 'entities'
settlement_id = Column(Integer, ForeignKey('settlements.id'), nullable=False)
type = Column(String(20), nullable=False)
level = Column(Integer, nullable=False, default=0)
energy = Column(Float, nullable=False, default=0)
position_x = Column(Integer, default=0)
position_y = Column(Integer, default=0)
def __repr__(self):
return "<Entity('%s')>" % (self.type)
每次我更新EntityModel时,我都想在system function.now()
上更新last_time
.我可以用触发器在数据库级别上完成这项工作,但如果可能的话,我更愿意在应用程序级别上完成.