Collection

Represents a collection of database objects. Note that it will not contain any objects by itself. The contained object can only be accessable by calling methods like toArray() or each()

Construction

Collection constructor is private. Instances are returned from the WhereClause methods and some of the Table methods.

Sample

var collection = db.friends.where("name").equalsIgnoreCase("david");

collection.each(function(friend) {
    console.log("Found: " + friend.name + " with phone number " + friend.phone);
});

Methods

and()

Add JS based criteria to collection

count()

Get the number of items in the collection

desc()

Sort in descending order

distinct()

Remove duplicates of items with same primary key

each()

Execute query and call a function for each item

eachKey()

Execute query on the index or primary key being used and call a function for each key

eachUniqueKey()

Execute query on the index or primary key being used and call a function for each unique key

first()

Get the first item in the collection

keys()

Retrieve an array containing all keys of the collection (index or primary key depending on where() clause)

last()

Get the last item in the collection

limit()

Limit the result to given number of items

offset()

Ignore N items before given offset and return the rest

or()

Logical OR operation

sortBy()

Execute query and get an array with the results sorted by given property

toArray()

Execute query and get an array with the results sorted by the index used in the where() clause

uniqueKeys()

Retrieve an array containing all unique keys of the collection (index or primary key depending on where() clause)