如果属性不等于 None,我想更新我的 SQLAlchemy 数据库中列的值。
此方法有效,但似乎不遵循 DRY 原则
def editObject(object_id, name, picture, metaTitle,
metaKeywords, metaDescription):
object = session.query(Object).filter_by(id = object_id).one()
if name:
object.name = name
if picture:
object.picture = picture
if metaTitle:
object.metaTitle = metaTitle
if metaKeywords:
object.metaKeywords = metaKeywords
if metaDescription:
object.metaDescription = metaDescription
session.add(object)
session.commit()
谢谢
请您参考如下方法:
您可以使用关键字参数和 setattr()
def editObject(object_id, **kwargs):
object = session.query(Object).filter_by(id = object_id).one()
for attr, value in kwargs.iteritems():
if value:
setattr(object, attr, value)
session.add(object)
session.commit()
