Queries

The queries interface is inspired in Django-ORM, so you can expect a familiar interface if you are used to Django.

i.e: If you want to find a specific book, you can query by title

var books = Book.filter({title: “Fight Club”}).all()

If you want to list all books sorted by title:

var books = Book.order(‘title’).all()

You can use special operators for things like “greater than, less than” adding double underscore and the operator as the dict key:

If you want to list all books with the word “World” in the title

var books = Book.filter({title__like:’World’}).all()

If you want to list only the books with more than 100 pages

var books = Book.filter({pages__gt:100}).all()

All operators: like: The column contains the string startswith: The column starts with the string endswith: The column ends with the string gt: Greater than ge: Greater than or equal lt: Less than le: Less than or equal null: is NULL

If you want to list only the books from a specific author

var author = Author.filter({name: “Isaac Asimov”}).get() var books = Book.filter({author:author.id}).all()

If you want to update an item or a list of items you just need to filter first and call update with the new parameters

Author.filter({name: “Isac Asimov”}).update({name: “Isaac Asimov”});

The same approach to exclude an item

Author.filter({title: ‘Foundation’}).remove();