row.update() or row.pk

Hi,

fantastic framework for working with Sqlite3 databases!!!

I tried to update spezific rows in a table and used

for row in db[tablename]:
newValue = row["counter"] * row["prize"]
row.update({"Fieldname": newValue})
print(row)

This updates the value in the printet row, but not in the database. So I switched to

db[tablename].update(id, {"Filedname": newValue})

This works fine. But row.update would be nicer, because no need for the id (its that row), no need for the tablename and the db (all defined in the for row ... loop).

Thx

Start by tracing the row.update() and db[tablename].update(id, {"Filedname": newValue}) entry points described in the issue. Check how row objects retain their table and identifier, then verify the requested behavior against the existing update path. Done means row.update() persists the changed field to the SQLite database.