dict的关键名称映射到sqlalchemy对象attrs
例如:
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String)
fullname = Column(String)
password = Column(String)
可以从id = 3 {name: "diana"}
或id = 15更新,{name: "marchel", fullname: "richie marchel"}
发布于 2019-04-15 12:31:52
您可以使用setattr()
动态更新现有SQLAlchemy对象的属性:
user = session.query(User).get(someid)
for key, value in yourdict.iteritems():
setattr(user, key, value)
https://stackoverflow.com/questions/-100006587
复制相似问题