mongoTemplate聚合操作

来源：互联网发布：今日热点是什么软件编辑：程序博客网时间：2024/06/08 06:26

准备数据 customer 集合，数据类型如下：（只是部分数据，数据量太多就不一一列出）

{ "_id" : ObjectId("594c78a1c5fea52a445b8cd2"), "probMac" : "141FBA789098", "devcMac" : "BC3AEA0E50CB", "inTime" : "20170612133513", "outTime" : "20170612133545", "rssi" : "14" }{ "_id" : ObjectId("594c78a1c5fea52a445b8cd3"), "probMac" : "141FBA7890E8", "devcMac" : "38295A676DA3", "inTime" : "20170612133701", "outTime" : "20170612133716", "rssi" : "3" }{ "_id" : ObjectId("594c78a1c5fea52a445b8cd4"), "probMac" : "141FBA789050", "devcMac" : "18D276C360FF", "inTime" : "20170612133746", "outTime" : "20170612133750", "rssi" : "8" }{ "_id" : ObjectId("594c78a2c5fea52a445b8cd5"), "probMac" : "141FBA789050", "devcMac" : "E8BBA876D18A", "inTime" : "20170612134003", "outTime" : "20170612134012", "rssi" : "9" }{ "_id" : ObjectId("594c78a2c5fea52a445b8cd6"), "probMac" : "141FBA789050", "devcMac" : "3CB6B75AFF3A", "inTime" : "20170612134133", "outTime" : "20170612134141", "rssi" : "11" }{ "_id" : ObjectId("594c78a2c5fea52a445b8cd7"), "probMac" : "141FBA789050", "devcMac" : "D03742643B6D", "inTime" : "20170612134215", "outTime" : "20170612134247", "rssi" : "11" }{ "_id" : ObjectId("594c78a2c5fea52a445b8cd8"), "probMac" : "141FBA789050", "devcMac" : "C09F054B6DB8", "inTime" : "20170612134217", "outTime" : "20170612134253", "rssi" : "27" }

1 通过mongoTemplate.group方法

public <T> GroupByResults<T> group(String inputCollectionName, GroupBy groupBy, Class<T> entityClass)

public <T> GroupByResults<T> group(Criteria criteria, String inputCollectionName, GroupBy groupBy,
Class<T> entityClass)

一种可以带过滤条件一种全集合分组查询

使用第一种不带条件的查询

@RequestMapping("/test")@ResponseBodypublic Object test(){//多个key组合分组，一个key分组掺入一个参数即可GroupBy groupBy = GroupBy.key("devcMac","probMac").initialDocument("{total:0}")          .reduceFunction("function(doc, prev){prev.total+=1}");          GroupByResults<BasicDBObject> gbr = mongoTemplate.group("customer", groupBy, BasicDBObject.class); return gbr.iterator();}

返回结果：

[{"devcMac":"BC3AEA0E50CB","probMac":"141FBA789098","total":8.0},{"devcMac":"38295A676DA3","probMac":"141FBA7890E8","total":1.0},{"devcMac":"18D276C360FF","probMac":"141FBA789050","total":1.0},{"devcMac":"E8BBA876D18A","probMac":"141FBA789050","total":2.0},{"devcMac":"3CB6B75AFF3A","probMac":"141FBA789050","total":6.0},{"devcMac":"D03742643B6D","probMac":"141FBA789050","total":1.0}]

如果想返回其他的字段可以更改reduce函数，和 initialDocument 参数

比如加上inTime值的数组内容

@RequestMapping("/groupByMutiKeyOther")@ResponseBodypublic Object groupByMutiKeyOther(String... key) {// 多个key组合分组，一个key分组掺入一个参数即可GroupBy groupBy = GroupBy.key("probMac","devcMac").initialDocument("{inTime:[],count:0}").reduceFunction("function(doc, prev){"+ "prev.inTime.push(doc.inTime);"+ "prev.count+=1}");GroupByResults<BasicDBObject> gbr = mongoTemplate.group("customer",groupBy, BasicDBObject.class);return gbr.iterator();}

返回结果:

[{"probMac":"141FBA789098","devcMac":"BC3AEA0E50CB","inTime":["20170612133513","20170612172022","20170612185417","20170613021023","20170628034820","20170628054026","20170628102731","20170628142909"],"count":8.0},{"probMac":"141FBA7890E8","devcMac":"38295A676DA3","inTime":["20170612133701"],"count":1.0},{"probMac":"141FBA789050","devcMac":"18D276C360FF","inTime":["20170612133746"],"count":1.0},{"probMac":"141FBA789050","devcMac":"E8BBA876D18A","inTime":["20170612134003","20170617151506"],"count":2.0},{"probMac":"141FBA789050","devcMac":"3CB6B75AFF3A","inTime":["20170612134133","20170616215301","20170619002323","20170625061702","20170625200712","20170627235117"],"count":6.0},{"probMac":"141FBA789050","devcMac":"D03742643B6D","inTime":["20170612134215"],"count":1.0}]

2 mapreduce分组统计

@RequestMapping("/groupByMapReduce")@ResponseBodypublic Object groupByMapReduce(String key) {    String map = "function() { emit(this.probMac, {count:1});}";    String reduce = "function(key, values) {"    + "var total = 0;"    + "for(var i=0;i<values.length;i++){total += values[i].count;}"    + "return {count:total};}";        MapReduceResults<BasicDBObject> mrr = mongoTemplate.mapReduce("customer", map, reduce, BasicDBObject.class);return mrr.iterator();}

返回结果内容：

[{"_id":"141FBA789010","value":{"count":505.0}},{"_id":"141FBA789050","value":{"count":18287.0}},{"_id":"141FBA789098","value":{"count":7489.0}},{"_id":"141FBA7890E8","value":{"count":8626.0}}]

3 通过 mongoTemplate.aggregate方法

@RequestMapping("/groupByAggregation")@ResponseBodypublic Object groupByAggregation(String key) {AggregationResults<BasicDBObject> a = mongoTemplate.aggregate(Aggregation.newAggregation(Aggregation.group("probMac").count().as("count")), Customer.class, BasicDBObject.class);return a.iterator();}

返回结果：

[{"_id":"141FBA789010","count":505},{"_id":"141FBA789050","count":18291},{"_id":"141FBA7890E8","count":8644},{"_id":"141FBA789098","count":7493}]

阅读全文

0 0