PRIMARY> db.orders.find().forEach(printjson)
{
"_id" : ObjectId("513466b691390735f2237119"),
"category" : "blue",
"recordDate" : ISODate("2012-04-02T17:04:11.105Z"),
"status" : "A",
"price" : 50
}
{
"_id" : ObjectId("513466e591390735f223711a"),
"category" : "red",
"recordDate" : ISODate("2012-04-02T10:05:11.105Z"),
"status" : "A",
"price" : 60
}
{
"_id" : ObjectId("5134689291390735f223711b"),
"category" : "red",
"recordDate" : ISODate("2012-04-02T10:05:11.105Z"),
"status" : "A",
"price" : 60
}
java test code :
@Test
public void testAggregation(){
DBCollection collection = MongoDBFactory.getCollection("test","orders");
DBObject mathcObjects = new BasicDBObject();
//mathcObjects.put("category", null);
mathcObjects.put("status", "A");
DBObject match = new BasicDBObject("$match", mathcObjects );
// Now the $group operation
DBObject groupFields = new BasicDBObject( "_id", "$category");
groupFields.put("sum", new BasicDBObject( "$sum", "$price"));
DBObject group = new BasicDBObject("$group", groupFields);
// run aggregation
AggregationOutput output = null;
try {
output = collection.aggregate( match, group );
} catch (MongoException e) {
e.printStackTrace();
}
CommandResult commandResult = output.getCommandResult();
BasicDBList photosDbObjectList = (BasicDBList) commandResult.get("result");
Iterator<Object> it = photosDbObjectList.iterator();
while ( it.hasNext()) {
BasicDBObject basicDBObject = (BasicDBObject) it.next();
String key = basicDBObject.get("_id").toString();
String sum = basicDBObject.get("sum").toString();
System.out.println(key + " : " + sum);
}
}
output
red: 120.0
blue: 50.0
Comments
Post a Comment