Stringifies query objects for pasting into the Mongo shell.
MSON.stringify is an alternative for
JSON.stringify. It serializes queries (and data to be inserted or updated) in such a way that they can be pasted into the Mongo shell, with no loss of information. ObjectIds, DBRefs and Dates are not converted to strings, so they'll keep working.
The primary use case is to help with debugging MongoDB queries that are generated by your app.
npm install mongoson
MSON = require 'mongoson'MSONstringify mongoQuery
This returns a serialized query, a "query object literal" if you will. The result can be pasted into the mongo console.
MSON.stringifyencodes ObjectId, DBRef and Date objects. All else should be equivalent to regular JSON.
- Passing a replacer function as second argument is not supported.
- Indentention is not supported.
For the brave-at-heart, there's also
MSON.parseUnsafe serializedQuery. It's called
parseUnsafe for a reason, because it actually uses
eval to instantiate the correct
Date objects, without doing any sanitation beforehand. You do NOT want to use this unattended. Before running it on any serialized query, I recommend scrutinizing it for any fishy stuff inside. It could absolutely execute any kind of code in node.js.
The advantage of
MSON.parseUnsafe over doing eval yourself is that the code gets evaluated in a context where
ISODate functions are defined. This is quicker than importing them from MongoDB's BSON module yourself.
I'd appreciate any hints on how to adjust (for example) the JSON2 parse function to let the specific calls to
ISODate pass through, while disallowing any other kinds of expressions (beyond valid JSON expressions, obviously). Then we could have a safe
Suppose you have build a query using some "native" Mongo object types (DBRef and ObjectId), like so:
bson = require 'bson'ObjectID = bsonBSONPureObjectIDDBRef = bsonBSONPureDBRefsomeQuery =_id: ObjectID"507f1f77bcf86cd799439011"title: "Super"related:ObjectID"507f1f77bcf86cd799439011"ObjectID"507f1f77bcf86cd799439012"ObjectID"507f1f77bcf86cd799439013"owner: DBRef"groups"ObjectID"507f191e810c19729de860ea"updatedAt:$gte: "2012-02-07T18:32:42.692Z"$lte: "2013-02-07T18:32:42.692Z"
You can then do
MSON = require 'mongoson'consolelog MSONstringify someQuery
This is ready to be pasted into the MongoDB shell as part of a command.
The example input and output is taken straight from the (sole) test for this module, so the above should absolutely work.
mongoson is released under the MIT License.
Copyright (c) 2013 Meryn Stol