Modifying data

The Update method

Update is a little bit more complicated. Here is an example to get you going:

db.Update("Table name", db.Select("Table name", favColour = 0xffffff), UID = 12, Username = "test")

This is the same as the SQL statement:

UPDATE `Table name` SET `UID` = 12, `Username` = 'test' WHERE `favColour` = 0xffffff;

Lambdas may be used in the select statement, but not the update statement. To achieve something similar, you can do this:

for datapoint in db.Select("Table name", favColour = 0xffffff):
    db.Update("Table name", [datapoint], UID = datapoint["UID"] + 1)

That would increment the UIDs of every user with the favourite colour of white.

It can also be combined with the Dump method:

db.Update("Table name", db.Dump("Table name"), username = "newusername")

That would change every user’s username to “newusername”

Just as with inserts, you may use lists to update data.