srhyne / shelly

Make building queries and updating MongoDB documents in the Mongo shell much easier. Written in JS for MongoDB's JS Shell.

Shelly.js

What is it?

Make building queries and updating MongoDB documents in the Mongo shell much easier. Written in JS for MongoDB's JS Shell.

Why did you build it?

I just got tired of writing really difficult queries for updating a few records. I got tired of hitting the shell window width and flubbing bracket placement.

What can I do with it?

• Build up queries with and_where, and_has
• Easily set your scope, call .set('key', value), then save to make editing documents painless
• Update documents like an ORM class
• Pluck out values from ambiguaous paths .get('my.really.deep.path')

Example use..

Find a single record by id

Mongo

db.contacts.find({ _id : ObjectId('5489ea63c96a880167462784') })`

Shelly

var c = Shelly('contacts')
c.find('5489ea63c96a880167462784')

//or
c.first('5489ea63c96a880167462784')

Find records that have 'triggers' key

Mongo

db.contacts.find({ 'triggers' : { $exists : true } })

Shelly

var c = Shelly('contacts')
c.has('triggers')
c.each...

Updating a records

Mongo

db.contacts.update({ 'triggers.email' : { $exists : false } }, { 
	$set : { 'triggers.email' : true }
}, { $multi : true });

Shelly

var c = Shelly('contacts');
c.has('triggers.email', false);
c.set('triggers.email', true);
c.update({ multi : true });

Other Nice Stuff

Inspect your current state

var c = Shelly('contacts');
c.where(query)
c.and_where(query)

//what does that look like?
c.inspect()
//oh yeah!

get/set values out of objects

var c = Shelly('contacts')
c.where(query)
c.get()
c.forEach(function(contact){
	var path = 'meta.phones.mobile.0';
	var mobile = contact.get('meta.emails.mobile.0');
	mobile =  mobile ? myFormatter(mobile) : 'some other value';
	contact.set(path, mobile);
	contact.save();
});

Why no chaining?

Because this will be printed to the shell. If you know a way to mute this let me know!!

TODO

• Support for and/or conjections with and_where or_where
• Support building queries with other Shelly queries
• map reduce, stuff
• Easy join builder

Logo by Natalypaint and not part of license