from schema import db, CustomerTable as GF
db.connect()
#this works
query = GF.update(Priority=88).where(GF.CustomerID==1)
query.execute()
can someone help me with this please? The above code works fine in updating an sqlite database. The bottom doesn't.
#this doesn't work and help needed...
#JSON string
customers = '{ "name":"john john", "mobile":12345678, "email":"[email protected]"}'
pycustomers = json.loads(customers)
# print(pycustomers["name"])
for keys in pycustomers:
print("This is the key: ", keys, "\t\tThis is the value: ", pycustomers[keys])
query = GF.update({keys: pycustomers[keys]}).where(GF.Mobile==pycustomers["mobile"])
CodePudding user response:
If all the keys of the JSON dict correspond to fields on the model, you can just pass the data right in:
customers = '{ "name":"john john", "mobile":12345678, "email":"[email protected]"}'
pycustomers = json.loads(customers)
# print(pycustomers["name"])
nrows = (GF.update(pycustomers)
.where(GF.Mobile==pycustomers["mobile"])
.execute())
Docs that may be helpful: