nqm-mongo-parse
v1.0.3
Published
A parser for mongo db queries
Downloads
4
Readme
mongo-parse
A parser for mongo db queries. You can use this to analyze, modify, and match against MongoDb queries.
Example:
var parser = require('mongo-parse')
var query = parser.parse({ "powerlevel": { $gt: 9000 }})
// query.parts contains: [{field: 'powerlevel', operator: '$gt', operand: 9000}]
var query2 = {$and:[{userId: "29g8j3h27fh382dh82ae23"}, {animal: {$in: ['beefalo', 'deerclops']}}]}
var newQuery = parser.parse(query2).mapValues(function(field, stringId) {
if(field === 'userId')
return ObjectId(stringId) // change a string ID into an ObjectId when you need to
})
// newQuery is {$and:[{userId: ObjectId("29g8j3h27fh382dh82ae23")}, {animal: {$in: ['beefalo', 'deerclops']}}]}
newQuery.match({userId: ObjectId("29g8j3h27fh382dh82ae23"), animal: 'deerclops'}) // returns true
Install
npm install mongo-parse
Usage
var parser = require('mongo-parse')
var queryObject = parser.parse(mongoQuery)
- Returns an object that contains a list of query parts, and methods for interacting with the query.
queryObject.parts
- A list of QueryPart objects.
queryObject.mapValues(function(field, value) {...})
- Returns a new mongo query object with values mapped based on the passed in callback. The callback will be called for each leaf-node in the query. For example, in the query {x:1, $and:[{y:2,z:3}]}
, the callback will be called 3 times. Query parts that don't relate to a field may not trigger the callback. The callback's parameters:
field
- The field the query part is for. E.g. for{x:1}
, the field will be"x"
. Can beundefined
for certain query parts that don't relate to a specific field (e.g. the$text
operator).value
- the value that query part is querying with. E.g. for{x:1
, the value will be1
.
queryObject.matches(document)
- returns true if the query matches the passed mongodb document
object. The following mongo operators are supported: basic equality ({field:value}), $gt, $gte, $lt, $lte, $ne, $in, $nin, $all, $mod, $exists, $regex, $size, $elemMatch, $not, $and, $or, $nor, $where (and implicit where - passing a function), $comment. The following mongo operators are not yet supported $geoIntersects, $geoWithin, $nearSphere, $near, $text, projection operators ($, $meta, $slice)
QueryPart
A QueryPart contains the following properties:
field
- The field a query part relates to. Can beundefined
if the queryPart doesn't related to a specific field.operator
- The operator of a query part. Will beundefined
for the basic equality query.operand
- The operand for a query part. This is the whole value or object contained for the given operation. For example, for{x: 2}
the operand is2
, for{x: {$lt:3}}
the operand is{$lt:3}
, and for {$and:[{x:1},{y:2}]}, the operand is[{x:1},{y:2}]
.parts
- A list of QueryPart for parts contained within the given query part. For example, for{a:{$not:{$lt: 4}}}
the parts contains the $lt operator, for{$and:[{x:1},{y:2}]}
there are two elements inparts
: one for{x:1}
and one for{y:2}
.implicitField
- If false, it means that theparts
of this $elemMatch query part contains normal query parts. If true, it means that theparts
of this $elemMatch query part contains field operators (like $gt or $in) that will haveundefined
field
properties.implicitField
will beundefined
for any QueryPart object who'soperator
is not"$elemMatch"
.
DotNotationPointers
var pointers = parser.DotNotationPointers(rootObject, field)
- A function that returns a list of DotNotationPointer objects, which allow you to get and set a nested property inside a mongo document object using dot notation.
rootObject
- an object that may have the givenfield
field
- a fieldname, which can be expressed in dot notation (e.g. 'x' and 'x.y.0.z' are both valid forfield
)
Note that this returns a list because a single field
path can map to many actual properties because of how mongo fans out the matching paths for arrays. For example, DotNotationPointers({a:[{b:1},{b:2}]},"a.b")
will return two pointers, one pointing to "a.0.b" and one pointing to "a.1.b".
DotNotationPointer
A pointer that can get and set a nested property within a mongo document object using dot notation. The object has the following properties:
pointer.val
- a getter/setter value that can be used to both get and set the value selected by the field
passed into the DotNotationPointers
function.
pointer.property
- an array representing the field
, split by '.'. For example, for 'a'
this will hold ['a']
, and for 'a.b'
this will hold ['a','b']
.
pointer.propertyInfo
- an object with the following properties:
obj
- an object reference for use in getting or setting the value pointed to.last
- the property withinobj
that holds the value pointed to.
Todo
- document projection method (and projection operators)
- Support crazier mongo operators ($geoIntersects, $near, etc)
Changelog
- 1.0.2 - removing dependency on proto, since this library doesn't really need much object orientedness
- 1.0.1 - fixing bug in $exists matching
- 1.0.0
- Adding query matching
- Adding DotNotationPointers document traversal utility
- Adding implicitField property for $elemMatch parts
- Fixing a couple bugs in mapValues
- 0.0.1 - first version
How to Contribute!
Anything helps:
- Creating issues (aka tickets/bugs/etc). Please feel free to use issues to report bugs, request features, and discuss changes
- Updating the documentation: ie this readme file. Be bold! Help create amazing documentation!
- Submitting pull requests.
How to submit pull requests:
- Please create an issue and get my input before spending too much time creating a feature. Work with me to ensure your feature or addition is optimal and fits with the purpose of the project.
- Fork the repository
- clone your forked repo onto your machine and run
npm install
at its root - If you're gonna work on multiple separate things, its best to create a separate branch for each of them
- edit!
- If it's a code change, please add to the unit tests (at test/grapetreeTest.js) to verify that your change
- When you're done, run the unit tests and ensure they all pass
- Commit and push your changes
- Submit a pull request: https://help.github.com/articles/creating-a-pull-request
License
Released under the MIT license: http://opensource.org/licenses/MIT