$cond统计个数

最新推荐文章于 2023-04-24 07:30:00 发布

iteye_15461

最新推荐文章于 2023-04-24 07:30:00 发布

阅读量392

点赞数

CC 4.0 BY-SA版权

分类专栏： mongodb

本文链接：https://blog.youkuaiyun.com/iteye_15461/article/details/82549694

mongodb 专栏收录该内容

23 篇文章

订阅专栏

{ $cond: [ <boolean-expression>, <true-case>, <false-case> ] }
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 01, 2013'), "status": "success"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 01, 2013'), "status": "success"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 01, 2013'), "status": "error"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 01, 2013'), "status": "unavailable"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 02, 2013'), "status": "success"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 02, 2013'), "status": "error"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 02, 2013'), "status": "error"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 02, 2013'), "status": "unavailable"})
db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" : new Date('Jan 02, 2013'), "status": "unavailable"})

db.activity.aggregate(
    { $group: {
        _id: { date: '$requestTime' },
        success : {
            $sum: { $cond: [ { $eq: [ 'success', '$status' ] } , 1, 0 ] }
        },
        error : {
            $sum: { $cond: [ { $eq: [ 'error', '$status' ] } , 1, 0 ] }
        },
        unavailable : {
            $sum: { $cond: [ { $eq: [ 'unavailable', '$status' ] } , 1, 0 ] }
        }
    } }
);

结果
{
    "result" : [
        {
            "_id" : {
                "date" : ISODate("2013-01-02T00:00:00Z")
            },
            "success" : 1,
            "error" : 2,
            "unavailable" : 2
        },
        {
            "_id" : {
                "date" : ISODate("2013-01-01T00:00:00Z")
            },
            "success" : 2,
            "error" : 1,
            "unavailable" : 1
        }
    ],
    "ok" : 1
}