mongo分组查询，统计 Group.grouping(),Group.first(),Accumulator(“$sum“, new Integer(1) 含义解释

最新推荐文章于 2024-08-28 02:46:37 发布

李子怡

最新推荐文章于 2024-08-28 02:46:37 发布

阅读量883

点赞数 1

分类专栏： MongoDB 文章标签： mongodb

本文链接：https://blog.csdn.net/Ciel_Y/article/details/122476076

版权

MongoDB 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

同一个接口，两种方法，结果相同。

1.mongoTemplate

  /**
     * 文章阅读排行榜
     *
     * @param platformId
     * @return
     */
    public Map<String, Integer> getPharamacistArticleStudyRank(String platformId) {
        Map<String, Integer> dataMap = new HashMap<String, Integer>(16);
        Integer studyYear = LmsConfig.getRealStudyYear();
        String pharmacistStudyYearPeriod = LmsConfig.getPharmacistStudyYearPeriod(studyYear);
        String[] pharmacistStudyYear = pharmacistStudyYearPeriod.split("#");
        String startDate = pharmacistStudyYear[0];
        String endDate = pharmacistStudyYear[1];
        // 查询条件
        MatchOperation matchOperation = Aggregation.match(Criteria.where("createTime")
                .gte(DateUtil.getDate(startDate, DateUtil.SECONDFORMAT))
                .lte(DateUtil.getDate(endDate, DateUtil.SECONDFORMAT))
                .and("platformId").is(platformId));
        // 分组条件：按articleId分组，并统计每个分组的数据条数存储到studyYear中
        GroupOperation groupOperation = Aggregation.group("articleId")
                .count().as("studyYear");
        // 查询
        Aggregation agg = Aggregation.newAggregation(matchOperation, groupOperation);
        AggregationResults<PharmacistArticleVo> groupResults = mongoTemplate.aggregate(agg,
                "PharmacistArticleVo", PharmacistArticleVo.class);
        List<PharmacistArticleVo> pharmacistUserPointResults = groupResults.getMappedResults();
        for (PharmacistArticleVo pharmacistArticleVo : pharmacistUserPointResults) {
            dataMap.put(pharmacistArticleVo.getId(), pharmacistArticleVo.getStudyYear());
        }
        return dataMap;
    }

Aggregation agg = Aggregation.newAggregation(    
            Aggregation.match(criteria),//条件  
            Aggregation.group("a","b","c","d","e").count().as("f"),//分组字段    
            Aggregation.sort(sort),//排序  
            Aggregation.skip(page.getFirstResult()),//过滤  
            Aggregation.limit(pageSize)//页数  
         );    
    AggregationResults<Test> outputType=mongoTemplate.aggregate(agg,"test",Test.class);    
    List<Test> list=outputType.getMappedResults();

2.Morphia

   /**
     * 文章阅读排行榜
     * @param platformId
     * @return
     */
    public Map<String, Integer> getPharamacistArticleStudyRank(String platformId) {
        Map<String, Integer> dataMap = new HashMap<String, Integer>();
        Datastore datastore = pharmacistArticleDao.getDatastore();
        Query<PharmacistArticleVo> query = datastore.createQuery(PharmacistArticleVo.class);
        query.field("platformId").equal(platformId);

		Integer studyYear  = SystemConfig.getRealStudyYear();
		String pharmacistStudyYearPeriod = SystemConfig.getPharmacistStudyYearPeriod(studyYear);
		String[] pharmacistStudyYear = pharmacistStudyYearPeriod.split("#");
		String startDate = pharmacistStudyYear[0];
		String endDate = pharmacistStudyYear[1];
        query.filter("createTime >=", DateUtil.getDate(startDate,DateUtil.SECONDFORMAT));
        query.filter("createTime <=",DateUtil.getDate(endDate,DateUtil.SECONDFORMAT));

        AggregationOptions build = AggregationOptions.builder().outputMode(AggregationOptions.OutputMode.CURSOR).allowDiskUse(true).build();
        AggregationPipeline pipeline = datastore.createAggregation(PharmacistArticleVo.class).match(query).group(
// 通过articleId进行分类查询得到分组
            Group.id(Group.grouping("articleId")), Group.grouping("articleId", Group.first("articleId")),
// 统计每个分组的数据条数存储到studyYear中
            Group.grouping("studyYear", Group.first("studyYear")), Group.grouping("count", new Accumulator("$sum", new Integer(1))));
// 查询
        Iterator<PharmacistUserPointResult> iterator = pipeline.aggregate(PharmacistUserPointResult.class, build);
        while (iterator.hasNext()) {
            PharmacistUserPointResult result = iterator.next();
            if (result.getArticleId() == null) {
                continue;
            }
            dataMap.put(result.getArticleId(), result.getCount());
        }
        return dataMap;
    }

结果：

他们结果相同，如下：

结合查询条件和分组条件，和计数条件对应数据库看：

方法含义介绍：

下面两句代码实现相同功能：

// 按userId分组，并将它在返回结果中，以id的形式存储。并统计每个分组的数据条数，存储到返回结果的userId中。如下图所示：
GroupOperation groupOperation = Aggregation.group("userId").count().as("userId");

// 按userId进行分组，并在返回结果中，把它作为id进行存储。
 AggregationPipeline pipeline = datastore.createAggregation(GetPointDayVo.class).match(query).group(Group.id(Group.grouping("userId")),
// 统计每个分组中数据个数，并在返回结果中，把它作为count进行存储。
            Group.grouping("userId", Group.first("userId")), Group.grouping("count", new Accumulator("$sum", new Integer(1))));