Collections API

When querying multiple objects via users, flows, and table.

get(object_id)

Return an object associated with the object_id.

filter(**conditions, order_by=[])

Return a list of objects matching the filters provided:
c1, c2, ... , cN and orderer by the fields provided in order_by

update(object_id, data)

Update the object's data, but not overwriting other data.

put(object_id, data)

Update and overwrite the object completely.

delete(object_id)

Delete the objects.

all()

Return a list of all objects for the collection.

add(data)

Add a new objects to the collection.

self.db.users.get("Uxxxxxxxxx")
{
  'id': 'Uxxxxxxxxx',
  'name': 'Nikola',
  'dob': 'July 10, 1856'
}
self.db.table('products').filter(
  price__lt=100,
  category='toys'
  order_by=['-price', 'name']
)
[
  {
    "id": "O111111111",
    "category": "toys",
    "price": 45.12
    "name": "Bop-it"
  },
  {
    "id": "O222222222",
    "category": "toys",
    "price": 15.99
    "name": "Bubble mower"
  }
]
import time
order = {
  'item': 'Fish burrito',
  'price': 8.99,
  'created_at': time.time(),
  'user_id': self.db.user.id
}
id = self.db.table('orders').add(order)