🔎Query operations

Functions that search or sort data by specified criteria

Filter

Returns records that match criteria.

filter(range : str, criteria : str, value* : num)

Example: db.filter("money", "largerThan", 20)

Returns numeric records in money with value larger than 20.

Criterias

largerThan, value

Returns numbers larger than value.

smallerThan, value

Returns numbers smaller than value.

equals, value

Returns numbers equal to value.

max

Returns highest number.

min

Returns lowest number.

average

Returns average number.

isNumber

Returns only numbers.

Examples

// Get values larger than 20 from "money"
db.filter('money', 'largerThan', 20) // [ usd: 40, euro: 50 ]

// Get values smaller than 20 from "money"
db.filter('money', 'smallerThan', 20) // [ pln: 15 ]

// Get values equal 40 from "money"
db.filter('money', 'equal', 40) // [ usd: 40 ]

// Get highest value from "money"
db.filter('money', 'max') // [ euro: 50 ]

// Get lowest value from "money"
db.filter('money', 'min') // [ pln: 15 ]

---

Sort

Sorts records by criteria.

sort(data : json, criteria : str, type*: str)

Example: db.sort(db.get("money"), "largest", "value")

Returns numeric values in money from largest to smallest

Criterias

largest

Sorts from largest to smallest numbers

smallest

Sorts from smallest to largest numbers

Types (optional)

By default type is set to keyAndValue

key

Returns the names of records sorted by their values

value

Returns the values of records sorted by their values

keyAndValue (optional)

Returns the records values and names sorted by their values

Examples

db.sort("money", "largest") // [{euro:50}, {usd:40}, {pln:15}]
db.sort("money", "largest", "value") // [50, 40, 15]
db.sort("money", "largest", "key") // ["euro", "usd", "pln"]

Length

Returns number of records inside a key

db.length(key : str)

Examples

db.length("money") // 3