Java 实现MongoDB Group 操作

最新推荐文章于 2024-07-24 01:44:55 发布

chkaka

最新推荐文章于 2024-07-24 01:44:55 发布

阅读量1w

点赞数

分类专栏： MongoDB 文章标签： mongodb java function javascript string

本文链接：https://blog.csdn.net/h70614959/article/details/7790370

版权

MongoDB 专栏收录该内容

14 篇文章 1 订阅

订阅专栏

在Java For  MongoDB 中时通过 DBCollectino对象的group 方法来实现Group 操作。
官方IPA:http://api.mongodb.org/java/2.7.3/
方法解释：
group

public DBObject group(DBObject key,
                      DBObject cond,
                      DBObject initial,
                      String reduce,
                      String finalize)
               throws MongoException

Applies a group operation

Parameters:

key - - { a : true }

cond - - optional condition on query

reduce - javascript reduce function

initial - initial value for first match on a key

finalize - An optional function that can operate on the result(s) of the reduce function.

Returns:

Throws:

MongoException

案例实现：

final List<String> targetTerms = Arrays.asList("dogs", "cats");
final Datastore ds = ….
final DBCollection coll = ds.getCollection(Example.class);
BasicDBObject key = new BasicDBObject("_id", true);
BasicDBObject cond = new BasicDBObject();
cond.append("indices", new BasicDBObject("$in", targetTerms));
BasicDBObject initial = new BasicDBObject();
initial.append("score", 0);
initial.append("targetTerms", targetTerms);
String reduce = "function (obj, prev) { " +
        "  for (i in prev.targetTerms) {" +
        "    targetTerm = prev.targetTerms[i];"+
        "      for (j in obj.indices) {" +
        "        var index = obj.indices[j];"+
        "        if (targetTerm === index) prev.score++;" +
        "    }" +
        "  }" +
        "}";
String fn = null;
final BasicDBList group = (BasicDBList) coll.group(key, cond, initial, reduce, fn);