Updating/Deleting Data¶
For all the examples in this sections we will use the following Tables for a blog
Adding data¶
Two ways to add items with FySQL, you can user Table.create, or TableInstance.insert.
>>> print User.create('firstname'='TestFirstName', 'lastname'='TestLastName', role='Admin')
{"id": 3, "lastname": "TestLastName", "role": "Admin", "firstname": "TestFirstName"}
user = User()
user.firstname = 'TestFirstName'
user.lastname = 'TestLastName'
user.role = 'Admin'
>>> print user.insert()
{"id": 3, "lastname": "TestLastName", "role": "Admin", "firstname": "TestFirstName"}
Saving data¶
Use TableInstance.save.
user = User.get(User.id==3)
user.role = 'Member'
user.save()
>>> print user
{"id": 3, "lastname": "TestLastName", "role": "Member", "firstname": "TestFirstName"}
