mongo聚合操作

来源:互联网 发布:江苏网络测速 编辑:程序博客网 时间:2024/06/18 13:28

1、distinct操作

db.runCommand({"distinct":"test", "key":"age"})


2、聚合操作

db.doctors.group({

   key:{hospital:true},

   initial:{count:0},

   reduce:function(obj,prev){prev.count++},

})


3、修改键实例

> db.test.group( {
    ... key: { day: true},
    ... initial: {count: 0},
    ... reduce: function(obj,prev){ prev.count++;},
    ... finalize: function(out){ out.scaledCount = out.count * 10 } --在结果文档中新增一个键。
    ... } )

结果:
    [
        {
            "day" : "2012-08-20",
            "count" : 2,
            "scaledCount" : 20
        },
        {
            "day" : "2012-08-21",
            "count" : 2,
            "scaledCount" : 20
        },
        {
            "day" : "2012-08-22",
            "count" : 1,
            "scaledCount" : 10
        }    
    ]

0 0
原创粉丝点击