JAVA mongodb 聚合查询

最新推荐文章于 2024-04-27 03:36:25 发布

true?success:fail

最新推荐文章于 2024-04-27 03:36:25 发布

阅读量386

点赞数

分类专栏： NOSQL 文章标签： mongodb java nosql

转载请附上原文出处链接和本声明。

本文链接：https://blog.csdn.net/qq_41453424/article/details/128562372

版权

NOSQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

区分先后条件顺序，这是个坑！

 /**
     * 测试聚合
     */
    @Test
    public void testAggregation() {
        String format_DateTime = "yyyy-MM-dd HH:mm:ss";
        DateTimeFormatter df = DateTimeFormatter.ofPattern(format_DateTime);
        LocalDateTime localDateTime = LocalDateTime.parse("2023-11-23 12:13:08", df);

        LocalDateTime endTime = LocalDateTime.parse("2022-11-23 12:13:08", df);

//        Query query = new Query();
//        query.fields().exclude("_id");
        Criteria criteria = Criteria.where("name").is("a");
//        criteria.andOperator(
//            Criteria.where("time").gte(localDateTime),
//            Criteria.where("time").lte(endTime));
//        query.addCriteria(criteria);

        AggregationOperation match = Aggregation.match(criteria);
      
        List<AggregationOperation> operations = new ArrayList<>();
        operations.add(match); //区分先后条件顺序，这是个坑！
        operations.add(Aggregation.group("sex")/*.first("equipmentId").as("equipmentId")*/
            .sum("sex").as("sex")
            .sum("age").as("age")
        );
        Aggregation aggregation = Aggregation.newAggregation(operations);
        AggregationResults<Document> aggregate = mongoTemplate.aggregate(aggregation, "c3", Document.class);
        List<Document> mappedResults = aggregate.getMappedResults();
        log.debug("BaBiaoChongQingCeBaoYiQuery 聚合合计查询结果 {}", JSONUtil.toJsonStr(aggregate));
        System.out.println("-----------------" + (CollectionUtils.isEmpty(mappedResults) ? null : mappedResults.get(0)));
        System.out.println("==============" + mappedResults);
    }