Below code for bulk update is working where benefits_dict
is my list of dictionaries.
conn.execute(MedicalPlanBenefit.__table__.update()
.where(MedicalPlanBenefit.__table__.c.user_id == bindparam('user_id')),
benefits_dict)
Now when I go and add multiple conditions to my where clause like below, it doesn't work.
conn.execute(MedicalPlanBenefit.__table__.update()
.where(MedicalPlanBenefit.__table__.c.user_id == bindparam('user_id') & MedicalPlanBenefit.__table__.c.test_id == bindparam('test_id')),
benefits_dict)
How do you add multiple conditions in this case?
My benefits_dict
:
{'user_id': 1, 'email_address' : '[email protected]', 'id':12, 'test_id': 31},
{'user_id': 1, 'email_address' : '[email protected]', 'id':13, 'test_id': 31},
{'user_id': 2, 'email_address' : '[email protected]', 'id':14, 'test_id': 31},
{'user_id': 2, 'email_address' : '[email protected]', 'id':15, 'test_id': 31}