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()