语句解释:返回指定时间段内,每个来源下的每个媒体的文章总数
match:匹配pub_time大于等于+小于条件
project:返回的列
group:_id内的为分组的列,nums为聚合后的列名称,$sum为求和,1表示求和的是行数(如果把1替换成某列名称则为该列求和)
ps:其他聚合条件参考文档
mongdb客户端操作:
db.article.aggregate([
{ $match:{pub_time:{$gte:1546819200,$lt:1546905600}}},
{$project:{source:1,media:1}},
{$group:{_id:{source:'$source',media:'$media'}, nums:{$sum:1}}}
]);
PHP7操作:
$command = [
'aggregate' => 'article',
'pipeline' => [
['$match' => [ 'pub_time' => ['$gte'=>1546819200, '$lt'=>1546905600] ]],
['$group' => [ '_id' => ['source'=>'$source','media'=>'$media'], 'nums' => ['$sum'=>1] ] ],
['$limit' => 10],
],
'cursor' => new \stdClass,
];
$cursor = $mongo->command($command);
foreach ($cursor as $document) {
var_dump($document);
}
PS:如果要更新某个字段嵌套的对象(fields数组中某一字段用field.key)
其中用到的PHP7+mongodb的类库参考:https://blog.csdn.net/why444216978/article/details/85329366