object-sql
is a tool for querying javascript objects using a sql like syntax. It was originally inspired from a kata by surtich.
Please see the docs for more informations.
const q = require('src/object-sql.js');
q().select().from([1, 2, 3]).execute(); // [1, 2, 3]
const users = [
{id: 1, name: 'Alice', age: 35},
{id: 2, name: 'Bob', age: 25},
{id: 3, name: 'Charlie', age: 30}
];
const nameAndAge = (user) => ({
name: user.name,
age: user.age
});
const thirtyOrAbove = (user) => user.age >= 30;
q().select(nameAndAge).from(users).where(thirtyOrAbove).execute();
// [
// {name: 'Alice', age: 35},
// {name: 'Charlie', age: 30}
// ]
Tests are running using jasmine-node
. Install and run bin/test
.
npm install
bin/test
- Support joins on multiple objects
- Refactor joins to return format;
{key: [v,a,l,u,e,s]}
instead of[key, [v,a,l,u,e,s]]
.