Mongoose get document as an array of arrays based on a key

Question

I don't really know how to frame the question but what I have is the following schema in mongoose

new Schema({

                        gatewayId: { type: String, index: true },
                        timestamp: { type: Date, index: true },
                        curr_property:Number,
                        curr_property_cost:Number,
                        day_property:Number,
                        day_property_cost: Number,
                        curr_solar_generating: Number,
                        curr_solar_export:Number,
                        day_solar_generated:Number,
                        day_solar_export:Number,
                        curr_chan1:Number,
                        curr_chan2:Number,
                        curr_chan3:Number,
                        day_chan1:Number,
                        day_chan2:Number,
                        day_chan3:Number
},{
    collection: 'owlelecmonitor'
});

and I want to be able to query all the documents in the collection but the data should be arranged inside the array in the following format

[ [{
    gatewayId: 1,
    timestamp: time
    ....
   },
   {

    gatewayId: 1,
    timestamp: time2
    ....
   }],
  [{
    gatewayId: 2,
    timestamp: time
    ....
   },
   {

    gatewayId: 2,
    timestamp: time2
    ....

   }],
  [{
    gatewayId: 3,
    timestamp: time
    ....

   },
   {

    gatewayId: 3,
    timestamp: time2
    ....

   }] 
];

Is there a way that I can do this in mongoose instead of retrieving the documents and processing them again ?

Besides the extra array, what is the difference?

Thomas Bormans
– Thomas Bormans

2015-11-10 19:10:26 +00:00
Commented Nov 10, 2015 at 19:10 — Thomas Bormans
– Thomas Bormans, Commented Nov 10, 2015 at 19:10

chridam · Accepted Answer · 2015-11-10 21:47:57Z

2

Yes, it's possible. Consider the following aggregation pipeline in mongo shell. This uses a single pipeline stream comprising of just the $group operator, grouping all the documents by gatewayId and creating another array field that holds all the grouped documents. This extra field uses the accumulator operator $push on the system variable $$ROOT which returns the root document, i.e. the top-level document, currently being processed in the aggregation pipeline stage.

With the cursor returned from the aggregate() method, you can then use its map() method to create the desired final array. The following mongo shell demonstration describes the above concept:

var result = db.owlelecmonitor.aggregate([
    {
        "$group": {
            "_id": "$gatewayId",
            "doc": {
                "$push": "$$ROOT"
            }
        }
    }
]).map(function (res){ return res.doc; });
printjson(result);

This will output to shell the desired result.

To implement this in Mongoose, use the following aggregation pipeline builder:

OwlelecMonitorModel
    .aggregate()
    .group({
        "_id": "$gatewayId",
        "doc": {
            "$push": "$$ROOT"
        }        
    })
    .exec(function (err, result) {
        var res = result.map(function (r){return r.doc;});
        console.log(res);
    });

answered Nov 10, 2015 at 21:47

chridam

104k26 gold badges246 silver badges243 bronze badges

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

2 Comments

Bazinga777 Over a year ago

Thanks, I'll try this out.

chridam Over a year ago

@Bazinga777 No worries, happy to help :)

Collectives™ on Stack Overflow

Mongoose get document as an array of arrays based on a key

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related