1,746
社区成员
发帖
与我相关
我的任务
分享
{
"_id" : "5771eb88b7d99727257fb584",
"device_token" : "0",
"status" : 1,
"update_time" : ISODate("2016-08-10T22:20:08.330Z"),
"uid" : 145630097,
"suid" : "1004244",
"app_key" : 123456789,
"device_token_length" : 0,
"create_time" : ISODate("2016-06-28T11:14:16.349Z"),
"app_os" : "0"
}
db.app_user.aggregate([
{'$match': {'create_time': {'$lt': datetime.datetime(2016, 9, 10, 0, 0)}}},
{"$group":{
"_id": {
'x1':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 3, 10, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 4, 11, 0, 0)]}]},
'x2':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 4, 11, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 5, 12, 0, 0)]}]},
'x3':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 6, 1, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 6, 15, 0, 0)]}]},
'x4':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 6, 15, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 6, 30, 0, 0)]}]},
'x5':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 7, 1, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 7, 15, 0, 0)]}]},
'x6':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 7, 15, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 7, 30, 0, 0)]}]},
'x7':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 8, 1, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 8, 15, 0, 0)]}]},
'x8':{'$and':[{'$gt': ['$create_time', datetime.datetime(2016, 8, 15, 0, 0)]}, {'$lt': ['$create_time', datetime.datetime(2016, 8, 30, 0, 0)]}]},
'b': '$app_key'
},
"count": {"$sum": 1}
}},
])
{u'ok': 1.0, u'waitedMS': 0L, u'result': [{u'count': 33, u'_id': {u'b': 186984681, u'x8': False, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': True, u'x4': False, u'x5': False}}, {u'count': 993, u'_id': {u'b': 123456789, u'x8': False, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': False, u'x4': False, u'x5': True}}, {u'count': 1675586, u'_id': {u'b': 123456789, u'x8': False, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': False, u'x4': True, u'x5': False}}, {u'count': 553, u'_id': {u'b': 123456789, u'x8': False, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': False, u'x4': False, u'x5': False}}, {u'count': 2741, u'_id': {u'b': 123456789, u'x8': False, u'x2': False, u'x3': False, u'x1': False, u'x6': True, u'x7': False, u'x4': False, u'x5': False}}, {u'count': 637, u'_id': {u'b': 186984681, u'x8': True, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': False, u'x4': False, u'x5': False}}, {u'count': 404, u'_id': {u'b': 123456789, u'x8': True, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': False, u'x4': False, u'x5': False}}, {u'count': 1106, u'_id': {u'b': 123456789, u'x8': False, u'x2': False, u'x3': False, u'x1': False, u'x6': False, u'x7': True, u'x4': False, u'x5': False}}]}