Wednesday 17 October 2018

function to query multiple Mongodb collections

So i'm new to nodejs/mongo but i'm trying to figure out a way I can query multiple collections and return the results of each of the querys into one variable. Is this possible?​function getblacklistdata(datasets, start, end) { MongoClient.connect('mongodb://localhost:27017/', { useNewUrlParser: true }, function (err, client) { if (err) throw err; var db = client.db('blacklist'); var rdata = []; for (var i = 0; i < datasets.length; i++) { db.collection(dataset[i]).aggregate( { "$match": { "ipaddr" : { "$gte" : start, "$lte" : end } } }, { "$group" : { "_id":"$ip_str", "lists_count":{ "$sum":1 }, "blacklists": { "$addToSet": '$list' } } }, { "$project": { "ip":"$ip_str", "lists_count":"$lists_count", "blacklists":"$blacklists" } } ).toArray( function( err, data ) { if ( err ) throw err; // append data to rdata array here } ); }; }); //return rdata for the function at the end } ​

Submitted October 17, 2018 at 09:01PM by PaymentRequired402

No comments:

Post a Comment