Where2
A simple lib that converts a object clause into a sql where clause:
ex:
var result = where2({foo: 'bar', baz: { $gt: 'bam'}});
#=> "foo = 'bar' AND baz > 'bam'"
Install
npm install where2
Usage
var where2 = ;var result =
Where Attributes
| Key | Description |
|---|---|
| $lt | Less Than |
| $lte | Less Than or Equal |
| $gt | Greater Than |
| $gte | Greater Than or Equal |
| $ne | Not Equal To |
JSON Examples
Where
where single equals:
{"name":"foo2"}
name = "foo2"
Returns all records where name equals "foo2"
where in collection:
{"name":["foo2", "foo3"]}
name IN ("foo2", "foo3")
Returns all records where name equals "foo2" or "foo3"
where multiple equals:
{"name":"foo","description":"bar"}
name = "foo" AND description = "bar"
Returns all records where name equals "foo" and description equals "bar"
where less than:
{"id":{"$lt":"2"}}
id < 2
Returns all records where id is less than "2"
where less than or equal to:
{"id":{"$lte":"2"}}
id <= 2
Returns all records where id is less than or equal to "2"
where greater than:
{"id":{"$gt":"2"}}
id > 2
Returns all records where id is greater than "2"
where greater than or equal to:
{"id":{"$gte":"2"}}
id >= 2
Returns all records where id is greater than or equal to "2"
where not equal to:
{"name":{"$ne":"bar"}}
name != "bar"
Returns all records where name is not equal to "bar"
Collaborators
- Kevin Collins kevincol54
- Tom Wilson twilson63