前因
项目中有查询MongoDB单表统计相关功能,涉及到MongoDB数据聚合相关操做,其中在多字段分组去重计数相关操做API上资料较少,spring-data-mongodb相关的API介绍也不够直给java
需求
查询XX的ID下全部任务的数量mysql
查询XX的ID下每一个用户对应的任务数spring
实现
Mysql
这样的需求在mysql中很是只是很是简单的两句查询sql
select count(1) as count , medalId from XXTask group by medalId;
select count(distinct userId) as count,medalId from XXTask group by medalId;
MongoDB
第一个需求比较简单,采用Aggregation进行数据聚合便可mongodb
Criteria criteria = Criteria.where("medalId").in({"id1","id2"});
if (start != null && end != null) {
criteria.and("submitTime").gte(start).lt(end);
}
/*认证次数数据聚合*/
Aggregation aggregation = Aggregation.newAggregation(
Aggregation.match(criteria),
Aggregation.group("medalId").count().as("count").last("medalId").as("medalId")
);
List verifyCounts = mongoTemplate.aggregate(aggregation, MedalTask.class, MedalTaskCount.class).getMappedResults();
第二个需求也比较简单,也是采用Aggregation进行数据聚合,不过须要稍微转个弯app
Criteria criteria = Criteria.where("medalId").in({"id1","id2"});
if (start != null && end != null) {
criteria.and("submitTime").gte(start).lt(end);
}
/*认证次数数据聚合*/
Aggregation aggregation = Aggregation.newAggregation(
Aggregation.match(criteria),
Aggregation.group("medalId", "userId"),
Aggregation.group("medalId").last("medalId").as("medalId").count().as("count")
);
List verifyCounts = mongoTemplate.aggregate(aggregation, MedalTask.class, MedalTaskCount.class).getMappedResults();
其中第一次按照双字段分组,第一层group取得medalId和userId的分组信息,第二层group再以medalId为分组对象,则能count出想要的答案code