Selecting data¶

Get¶

Get a single document by its primary key

Query('movies').get('08d56946-372d-4e7f-b227-157f6d70f84f')

new Query('movies').get('08d56946-372d-4e7f-b227-157f6d70f84f')

Get all documents where the given value matches the requested index

Query('movies').get_all(
    '08d56946-372d-4e7f-b227-157f6d70f84f',
    '8a1c7d43-419c-4ee7-81f4-47f7c7583f9e'
)

new Query('movies').getAll(
    '08d56946-372d-4e7f-b227-157f6d70f84f',
    '8a1c7d43-419c-4ee7-81f4-47f7c7583f9e'
)

Get all the documents for which the specified sequence is true

query = Query('movies').filter(
    Field('year') >= 1990,
    Field('year') <= 2000,
)

new Query('movies').getAll(
    new Field('year').gt(1990),
    new Field('year').lt(2000),
)

For more informations, see Filtering.

Get all the documents where the specified index falls between two values.

query = Query('movies').between(1990, 2000, 'year')

new Query('movies').between(1990, 2000, 'year')