group premium users by role

gistfile1.js

var db, mongoConnectionString, mongojs, query;


mongojs = require("mongojs");
var ObjectId = mongojs.ObjectId
var async = require("async")
var _ = require("underscore")

mongoConnectionString = "mongodb://127.0.0.1/sharelatex-production";

db = mongojs.connect(mongoConnectionString, ["subscriptions", "users"]);

query = {
  recurlySubscription_id: {
    $exists: true
  }
};


db.subscriptions.find(query, {
  admin_id: 1
}, function(err, subscriptions) {
        async.map(subscriptions, function(sub, cb){
                var userQuery = {_id:sub.admin_id}
                db.users.findOne(userQuery, {email:1, role:1, institution:1}, cb)
        }, function(err, results){
                results = _.groupBy(results, function(result){
                        if(result){
                                return result.role
                        }
                })
                console.log(results)

        });
});