CRUD
Create (add), Read (select), Update, Delete.
Last updated
Create (add), Read (select), Update, Delete.
Last updated
db.add()
Inserts rows into tables. See for more information.
A database model instance.
db.all()
Returns all rows from a table. See for more information.
- None
db.get()
The id/primary key
Same datatype as the primary key in the model (usually an integer).
db.get_by()
A series of named parameters.
db.get_by(column=value, other_column=other_value)
db.save()
- None
db.delete()
Query object
Selects rows by id/primary key. See for more information.
Selects all rows from a table that matches one or more columns. See for more information.
Saves/commits changes made to a table. You need to save after updating or deleting a row. See for more information.
Deletes rows in tables. See for more information.