oqo
TypeScript icon, indicating that this package has built-in type declarations

1.0.1 • Public • Published

JavaScript Object Query Object

OQO is a package which can help you to query from JavaScript objects. It is inspired by SQL.

Installation

npm install oqo

Example

Usage

const OQO = require('oqo');
 
const people = [
    { name: 'John',     age: 25,    gender: 'male'   },
    { name: 'Alice',    age: 14,    gender: 'female' },
    { name: 'Bob',      age: 19,    gender: 'male'   },
    { name: 'Charlie',  age: 20,    gender: 'female' },
    { name: 'David',    age: 21,    gender: 'male'   }
];
 
const result = OQO
    .select(['name', 'gender'])
    .from(people)
    .where('age >= 20')
    .order('age', 'desc')
    .run();
 
console.log(result);

Result

[
    { name: 'John',     gender: 'male'   },
    { name: 'David',    gender: 'male'   },
    { name: 'Charlie',  gender: 'female' }
]

Details

select

select is always needed. An array of keys should be passed.

from

from is always needed. A single object or an array of objects is needed. The objects should have the keys listed in select.

where

where can be used to give a condition. The condition should look like key operator operand(2 spaces are necessary). Currently, 5 operators (>, >=, =, <, <=) are supported.

order

order can be used to order the result objects by a key. asc or desc should be passed as a second value.

run

run is used to finish the query and get the results.

Readme

Keywords

Package Sidebar

Install

npm i oqo

Weekly Downloads

1

Version

1.0.1

License

MIT

Unpacked Size

7.84 kB

Total Files

7

Last publish

Collaborators

  • rulyox