sqlalchemy查询更新时,字段太多如何简写(setattr)

119 阅读1分钟

sqlalchemy查询更新时,字段太多如何简写

old_data = db.session.query(HospitalizationInformation).filter_by(IPID=row[1][0], patient_id=row[1][1]).first()

if old_data:
    data_dict = {
        'column1': new_value1,
        'column2': new_value2,
        # ...
    }

    for attr, value in data_dict.items():
        setattr(old_data, attr, value)

    db.session.commit()