mongodb 查询
forEach(某个字段除以3)
db.stat_delivery_201712.find({"day":20171212,"hour":{$gt:16}}).forEach(doc => {
db.stat_delivery_201712.update({_id: doc._id}, {$set: {number: NumberLong(doc.number / 3)}});
})
aggregate查询
db.stat_delivery_201704.aggregate(
[{
'$match' : {
//"ad_id":{$in:[1535,1536,2250,2251,2252,2253]},
"day": {$in:[20170406,20170407]}
}
},
{
$group : {_id: "$day",
广告投放次数 : {$sum : "$number"}
}
}
]).sort({_id:-1})