CODEWITHSUNDEEP
mongodbgoaggregation-framework
Daemon1313
Daemon1313

Reputation: 279

Aggregation in Golang mgo for Mongodb

Anybody knows what’s the equivalent of aggregate command we use in mongodb shell for golang mgo/bson?

Something like that:

aggregate([{$match:{my_id:ObjectId("543d171c5b2c1242fe0019")}},{$sort:{my_id:1, dateInfo:1, name:1}},{$group:{_id:"$my_id", lastEntry:{$max: "$dateInfo"},nm:{$last:"$name"}}}])

Upvotes: 13

Views: 22060

Answers (2)

George
George

Reputation: 3022

Sample Code:

pipe := c.Pipe([]bson.M{bson.M{"$match": bson.M{"type": "stamp"}},
        bson.M{"$group": bson.M{"_id": "$userid",
            "count": bson.M{"$sum": "$noofsr"}}}})

resp := []bson.M{}
iter := pipe.Iter()
err = iter.All(&resp)

Note:

Please note that the line should end with (,) if you are not breaking in (,) it will throw error message even if your query is correct.

Output:

{
    "transactions": [
        {
            "_id": "[email protected]",
            "count": 10
        },
        {
            "_id": "[email protected]",
            "count": 12
        }
    ]
}

Upvotes: 2

Jarema
Jarema

Reputation: 3586

Assuming that c is your Collection:

pipe := c.Pipe([]bson.M{{"$match": bson.M{"name":"John"}}})
resp := []bson.M{}
err := pipe.All(&resp)
if err != nil {
  //handle error
}
fmt.Println(resp) // simple print proving it's working

GoDoc references:

Upvotes: 27

Related Questions