mongoJS parsing JSON output

Question

I'm playing with nodeJS and mongoJS. I've successfully queried the DB and returned a set of data:

    var databaseUrl = "redirect"; // "username:[email protected]/mydb"
    var collections = ["things", "reports"]
    var db = require("mongojs").connect(databaseUrl, collections);

    db.things.find({url: "google.com"}, function(err, things) {
        if( err || !things) {
            console.log("URL not Found");
        }
        else things.forEach( function(RedirectURL) {
            console.log(RedirectURL);
        } );
    });

This returns this:

{ _id: 4fb2c304f2dc05fe12e8c428,
  url: 'google.com',
  redirect: 
   [ { url: 'www.goolge.com', weight: 10 },
     { url: 'www.google.co.uk', weight: 20 } ] }

What I need to do now is select certain elements of the array such as redirect.weight or redirect.url.

Does mongoJS allow me to do this easily or is there a better way?

Any pointers greatly appreciated as ever!

Ric

patalmypal · Accepted Answer · 2012-05-16 14:01:38Z

1

MongoJS implements the mongo API. Calls to document contents use the dot notation.

So in the example above,

  var weight = RedirectURL.redirect.0.weight

// equal to 10, since it is the first item of the redirect array.

The same principle can be used with the find commands. So if you wish to find documents with weight = 10, use the following command

  db.things.find({redirect.weight: 10})

answered May 16, 2012 at 14:01

patalmypal

6,7124 gold badges27 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ric_Harvey Over a year ago

Thanks almypal, people like you is the reason I love this site!

Collectives™ on Stack Overflow

mongoJS parsing JSON output

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related