seneca-store-query v0.0.5

A Seneca.js data storage plugin

seneca-store-query

seneca-store-query is a plugin for the Seneca MVP toolkit that extends the query capabilites of the seneca-standard-query. It currently works with seneca-postgres-store and seneca-mysql-store

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')
      ...
    })
    ...

Seneca extended query format

This plugin extends the basic standard store functionality with support for more complex queries.

Comparison query operators

list$ is extended with the following comparison operators:

• ne$: .list$({ f1: {ne$: v1} }) for not-equal.
• eq$: .list$({ f1: {eq$: v1} }) for equal.
• lte$: .list$({ f1: {lte$: 5} }) for less than or equal.
• lt$: .list$({ f1: {lt$: 5} }) for less than.
• gte$: .list$({ f1: {gte$: 5} }) for greater than or equal.
• gt$: .list$({ f1: {gt$: 5} }) for greater than.
• in$: .list$({ f1: {in$: [10, 20]} }) for in. in$ operator accepts only values of type array.
• nin$: .list$({ f1: {nin$: ['v1', 'v2']} }) 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

Logical query operators

list$ is extended with the following logical operators:

• or$: .list$({ or$: [{name: 'something'}, {price: 200}]})
• and$: .list$({ and$: [{name: 'something'}, {price: 200}]})

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:

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...
  } )

Limits

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.

Fields

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.

Contributing

We encourage participation. If you feel you can help in any way, be it with examples, extra testing, or new features please get in touch.