紧接着上篇来,这篇主要讲,mongodb的group功能,做的还是挺强大的,相当对于find(),skip(),distinct()等,用法比较复杂。

测试数据:
复制代码 代码如下:
> db.fruit.find(); 
{ "_id" : 1, "category" : "fruit", "name" : "apple" } 
{ "_id" : 2, "category" : "fruit", "name" : "peach" } 
{ "_id" : 3, "category" : "fruit", "name" : "banana" } 
{ "_id" : 4, "category" : "veggie", "name" : "corn" } 
{ "_id" : 5, "category" : "veggie", "name" : "broccoli" } 

1、根据category分组
复制代码 代码如下:
> db.fruit.group( 
       { 
         key: { category: 1}, 
         reduce: function(obj, prev) { 
                     prev.items.push(obj.name); 
                 }, 
         initial: { items : [] } 
       } 
    ); 

        { 
                "category" : "fruit", 
                "items" : [ 
                        "apple", 
                        "peach", 
                        "banana" 
                ] 
        }, 
        { 
                "category" : "veggie", 
                "items" : [ 
                        "corn", 
                        "broccoli" 
                ] 
        } 
]

php代码如下:
复制代码 代码如下:
$keys = array("category" => 1); 
$initial = array("items" => array()); 
$reduce = "function (obj, prev) { prev.items.push(obj.name); }"; 
$g = $collection->group($keys, $initial, $reduce); 
 
print_r($g);   //结果如下。 
 
Array 

    [retval] => Array 
        ( 
            [0] => Array 
                ( 
                    [category] => fruit 
                    [items] => Array 
                        ( 
                            [0] => apple 
                            [1] => peach 
                            [2] => banana 
                        ) 
 
                ) 
 
            [1] => Array 
                ( 
                    [category] => veggie 
                    [items] => Array 
                        ( 
                            [0] => corn 
                            [1] => broccoli 
                        ) 
 
                ) 
 
        ) 
 
    [count] => 5 
    [keys] => 2 
    [ok] => 1 
)

2、根据category来分组,并统计count

复制代码 代码如下:
> db.fruit.group( 
           { 
             key: { category: 1}, 
             cond: { _id: { $gt: 2 } }, 
             reduce: function(obj, prev) { 
                prev.items.push(obj.name); 
                prev.count++; 
             }, 
             initial: { items : [] ,count:0} 
           } 
        ); 

    { 
        "category" : "fruit", 
        "items" : [ 
            "banana" 
        ], 
        "count" : 1 
    }, 
    { 
        "category" : "veggie", 
        "items" : [ 
            "corn", 
            "broccoli" 
        ], 
        "count" : 2 
    } 
]

php代码如下:

复制代码 代码如下:
$keys = array("category" => 1); 
$initial = array("items" => array(),'count'=>0); 
$reduce = "function (obj, prev) { " . 
              "prev.items.push(obj.name); " . 
              "prev.count++;" . 
          "}"; 
$condition = array('condition' => array("_id" => array( '$gt' => 2))); 
$g = $collection->group($keys, $initial, $reduce, $condition); 
 
print_r($g);   //结果如下。 
 
Array 

    [retval] => Array 
        ( 
            [0] => Array 
                ( 
                    [category] => fruit 
                    [items] => Array 
                        ( 
                            [0] => banana 
                        ) 
 
                    [count] => 1 
                ) 
 
            [1] => Array 
                ( 
                    [category] => veggie 
                    [items] => Array 
                        ( 
                            [0] => corn 
                            [1] => broccoli 
                        ) 
 
                    [count] => 2 
                ) 
        ) 
 
    [count] => 3 
    [keys] => 2 
    [ok] => 1 

3、利用aggregate group功能,也挺强大

复制代码 代码如下:
> db.fruit.aggregate([ 
                     { $match: { _id: {$gt:0} } }, 
                     { $group: { _id: "$category", count: { $sum: 1 } } }, 
                     { $sort: { count: -1 } } 
                   ]); 
{ "_id" : "fruit", "count" : 3 } 
{ "_id" : "veggie", "count" : 2 } 

php代码如下:
复制代码 代码如下:
$cond = array( 
    array( 
        '$match' => array('_id' => array('$gt' => 0)), 
    ), 
    array( 
        '$group' => array( 
            '_id' => '$category', 
           'count' => array('$sum' => 1), 
        ), 
    ), 
    array( 
        '$sort' => array("count" => -1), 
    ), 
); 
$result = $collection->aggregate($cond); 
print_r($result);    //结果如下: 
 
Array 

    [result] => Array 
        ( 
            [0] => Array 
                ( 
                    [_id] => fruit 
                    [count] => 3 
                ) 
 
            [1] => Array 
                ( 
                    [_id] => veggie 
                    [count] => 2 
                ) 
 
        ) 
 
    [ok] => 1 

mongodb 的select 操作有很多,在这里,只是说了一些常用的功能。

标签:
PHP,mongodb,group操作

免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
白云城资源网 Copyright www.dyhadc.com

评论“PHP中的mongodb group操作实例”

暂无“PHP中的mongodb group操作实例”评论...

稳了!魔兽国服回归的3条重磅消息!官宣时间再确认!

昨天有一位朋友在大神群里分享,自己亚服账号被封号之后居然弹出了国服的封号信息对话框。

这里面让他访问的是一个国服的战网网址,com.cn和后面的zh都非常明白地表明这就是国服战网。

而他在复制这个网址并且进行登录之后,确实是网易的网址,也就是我们熟悉的停服之后国服发布的暴雪游戏产品运营到期开放退款的说明。这是一件比较奇怪的事情,因为以前都没有出现这样的情况,现在突然提示跳转到国服战网的网址,是不是说明了简体中文客户端已经开始进行更新了呢?