Extended query for Seneca framework stores
npm install seneca-store-query!Seneca
> A Seneca.js data storage plugin
seneca-store-query
=======================
[![npm version][npm-badge]][npm-url]
[![Build Status][travis-badge]][travis-url]
[![Dependency Status][david-badge]][david-url]
[![Gitter][gitter-badge]][gitter-url]
seneca-store-query is a plugin for the [Seneca][seneca] MVP toolkit that extends the query capabilites of the [seneca-standard-query][standard-query]. It currently works with [seneca-postgres-store][postgres-store] and [seneca-mysql-store][mysql-store]
``js
Usage:
var Seneca = require('seneca')
var si = Seneca()
var DBConfig = {
name: 'senecatest',
host: 'localhost',
username: 'senecatest',
password: 'senecatest',
port: 5432
}
...
si.use(require('seneca-postgres-store'), DBConfig)
si.use(require('seneca-store-query'))
si.ready(function() {
var product = si.make('product')
...
})
...
`
This plugin extends the basic standard store functionality with support for more complex queries.
list$ is extended with the following comparison operators:
- ne$: .list$({ f1: {ne$: v1} }) for not-equal. .list$({ f1: {eq$: v1} })
- eq$: for equal. .list$({ f1: {lte$: 5} })
- lte$: for less than or equal. .list$({ f1: {lt$: 5} })
- lt$: for less than. .list$({ f1: {gte$: 5} })
- gte$: for greater than or equal. .list$({ f1: {gt$: 5} })
- gt$: for greater than. .list$({ f1: {in$: [10, 20]} })
- in$: for in. in$ operator accepts only values of type array. .list$({ f1: {nin$: ['v1', 'v2']} })
- nin$: for not-in. nin$ operator accepts only values of type array.
Notes:
- the sort$, limit$, skip$ and fields$ can be used together.
- the operators described above can be used together
list$ is extended with the following logical operators:
- or$: .list$({ or$: [{name: 'something'}, {price: 200}]}).list$({ and$: [{name: 'something'}, {price: 200}]})
- and$:
Notes:
- These logical operators accepts only arrays as values.
- These operators can be used together to build more complex queries
- These logical operators can be used also with any Comparison query operators described above.
A complex example:
`js`
ent.list$(
{
or$: [
{name: 'something'},
{
and$: [
{price: {gte$: 100}},
{name: 'other'}
]
},
{color: { ne$: 'red' }}
],
sort$: {name: 1},
fields$: ['name', 'color']
}, function(err, list){
// do something with result...
} )
By default queries are limited to 20 values. This can be bypassed by passing the nolimit option, which if set to true will not limit any queries.
To filter the fields returned from the list operation, pass a fields$ array of column names to return. If no fields$ are passed, all fields are returned (i.e. select *` is used). e.g.
query.fields$ = ['id', 'name']
Note: The implicit id that is generated on save$ has an uuid value. To override this you must provide entity.id$ with a desired value.
[npm-badge]: https://img.shields.io/npm/v/seneca-store-query.svg
[npm-url]: https://npmjs.com/package/seneca-store-query
[travis-badge]: https://api.travis-ci.org/senecajs/seneca-store-query.svg
[travis-url]: https://travis-ci.org/senecajs/seneca-store-query
[david-badge]: https://david-dm.org/senecajs/seneca-store-query.svg
[david-url]: https://david-dm.org/senecajs/seneca-store-query
[gitter-badge]: https://badges.gitter.im/Join%20Chat.svg
[gitter-url]: https://gitter.im/senecajs/seneca
[seneca]: http://senecajs.org/
[postgres-store]: https://github.com/senecajs/seneca-postgres-store
[mysql-store]: https://github.com/senecajs/seneca-mysql-store
[standard-query]: https://github.com/senecajs/seneca-standard-query