如何通过python dict更新sqlalchemy orm对象 [英] How to update sqlalchemy orm object by a python dict

问题描述

dict的键名映射到sqlalchemy对象attrs

the dict's key names are mapping to the sqlalchemy object 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"}

can update from id = 3, {name: "diana"} or id = 15, {name: "marchel", fullname: "richie marchel"}

推荐答案

您可以使用setattr()动态更新现有SQLAlchemy对象上的属性:

You can use setattr() to update attributes on an existing SQLAlchemy object dynamically:

user = session.query(User).get(someid)

for key, value in yourdict.iteritems():
    setattr(user, key, value)

这篇关于如何通过python dict更新sqlalchemy orm对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！