alib-aquery

alib-aquery is a high performance, chainable array querying library that is extensible to support any type of filtering. It supports filter (in place of where), limit, offset and order by. It is inspired by the SQL SELECT statement but for arrays of objects.

Install

Install with npm:

$ npm i alib-aquery --save

Usage

import or require:

const aquery = require("alib-aquery");

//or

import aquery from "alib-aquery";

Then:

var data = [
  { color: "blue", size: 44 },
  { color: "green", size: 12 },
  { color: "red", size: 18 },
  { color: "blue", size: 9 },
  { color: "blue", size: 4 },
  { color: "blue", size: 12 },
  { color: "black", size: 12 },
];

var result = aquery(data)
  .filter("size", "gt", 10)
  .run();
// return an array of items having the prop 'size' greater than 10
// [
//     { color: 'blue', size: 44 },
//     { color: 'green', size: 12 },
//     { color: 'red', size: 18 },
//     { color: 'blue', size: 12 },
//     { color: 'black', size: 12 },
// ]

var result = aquery(data)
  .filter("size", "gt", 10)
  .filter("color", "eq", "blue")
  .run();
// return an array of items having the prop 'size' greater than 10 and color blue:
// [
//     { color: 'blue', size: 44 },
//     { color: 'blue', size: 12 },
// ]

var result = aquery(data)
  .filter("size", "gt", 10)
  .orderBy("size", "desc")
  .run();
// return an array of items having the prop 'size' greater than 10 ordered by size descending:
// [
//     { color: 'green', size: 12 },
//     { color: 'blue', size: 12 },
//     { color: 'black', size: 12 },
//     { color: 'red', size: 18 },
//     { color: 'blue', size: 44 },
// ]

var result = aquery(data)
  .filter("size", "gt", 10)
  .orderBy("size", "asc")
  .run();
// return an array of items having the prop 'size' greater than 10 ordered by size ascending:
// [
//     { color: 'blue', size: 44 },
//     { color: 'red', size: 18 },
//     { color: 'green', size: 12 },
//     { color: 'blue', size: 12 },
//     { color: 'black', size: 12 },
// ]

var result = aquery(data)
  .filter("size", "gt", 10)
  .orderBy("size", "asc")
  .offset(1)
  .limit(2)
  .run();
// return an array of items having the prop 'size' greater than 10 ordered by size ascending with an offset and limit:
// [
//     { color: 'red', size: 18 },
//     { color: 'green', size: 12 },
// ]

Built in filter functions are:

• eq - equals
• gt - greater than
• lt - less than
• contains - string contains

You can register your own filter function:

aquery().registerFilter("lengthof", (prop, value) => {
  return prop.length === value ? true : false;
});

You can then use your filter function as follows:

var result = aquery(data3)
  .filter("color", "lengthof", 3)
  .run();
// return an array of items having the prop 'color' with a string length of 3:
// [
//     { color: 'red', size: 18 },
// ]