MongoDB —— 常规操作
Find
db.getCollection('goods').find({'goods_original_price':/ou payez en/}).count();
db.getCollection('goods').find({'sku_id': 'ct8113'}, {'search_key': 1, 'goods_name': 1});
db.getCollection('goods').find({'goods_target':'www.ebay.co.uk'}).sort({'goods_update_time': -1})
db.sms_log.find(
{"$and":[{"createdTime":{"$gt":"2021-07-05 0:0:0"}},{"createdTime":{"$lt":"2021-07-06 0:0:0"}}]}
)
Remove(Delete)
db.getCollection('goods').remove({'goods_original_price':/ou payez en/}).count();
db.url.update({}, {$set: {content:""}}, {multi: 1})。
db.url.update({},{$unset:{'content':''}},false, true)
db.getCollection('metrics_main').update({},{$unset:{"startTime":""}},false,true)
Update
db.getCollection('goods').update(
{'goods_original_price':/ou payez en/},
{$set:{"goods_original_price":""}},
false,
true
);
db.getCollection('metrics_main').update({},
{$rename : {"aveResponseTime" : "avgResponseTime"}}, false, true)
聚合
db.sms_log.aggregate(
[{
$match: {
createdTime: {
$gte: '2021-07-05',
$lte: '2021-07-06'
}
}
}, {
$group: {
_id: null,
SUM: {
$sum: "$price"
},
COUNT: {
$sum: 1
}
}
}]
);
db.sms_log.find(
{"$and":[
{"createdTime":{"$gt":"2021-07-05 0:0:0"}},
{"createdTime":{"$lt":"2021-07-06 0:0:0"}},
{"callBackSize":{"$gt":10}}
]}
)
db.getCollection('goods').aggregate( [
{$unwind:"$goods_name"},
{$group:{_id:"$goods_name",count:{$sum:1}}},
{$project:{_id:0,count:1,userid:"$_id"}}
])
db.getCollection('goods').aggregate( [
{$match: {"sku_id": 'ct8113'}},
{$unwind:"$goods_name"},
{$group:{_id:"$goods_name",count:{$sum:1}}},
{$project:{_id:0,count:1,userid:"$_id"}}
])
db.getCollection('goods').aggregate( [
{$match: {"sku_id": 'ct8113'}},
{$unwind:"$search_key"},
{$group:{_id:"$search_key",count:{$sum:1}}},
{$project:{_id:0,count:1,search_key:"$_id"}}
])
db.getCollection('metrics_main').aggregate(
{
"$group":{
_id: "$serviceName",
avgAmount: { $avg: { $sum: [ "$aveResponseTime"] } },
}
},
{
"$sort":{"avgAmount":1}
}
);
db.getCollection('metrics_main').aggregate(
[{
"$match": {
nowtime: {
$gt: '2021-08-23 16:40:10',
$lt: '2021-08-23 17:10:10'
}
}
},
{
"$group":{
_id: {"serviceName": "$serviceName", "endpointName": "$endpointName"},
avgAmount: { $avg: "$avgResponseTime"},
}
},
{
"$sort":{"avgAmount": -1}
}]
)
db.getCollection('sms_log').aggregate(
{
"$match": {
day: '2021-10-14'
}
},
{
"$group":{
_id: "$day",
sumPrice: { $sum:"$price" },
}
},
{
"$sort":{"day":1}
}
)
db.getCollection('sms_log').aggregate(
{
"$match": {
day:{
$in:["2021-07-02","2021-07-31"]
}
}
},
{
"$group":{
_id: "$day",
sumPrice: { $sum:"$price" },
}
},
{
"$sort":{"day":1}
}
)
db.getCollection('sms_log').aggregate(
{
"$match": {
day:{
$in:["2021-07-02","2021-07-03","2021-07-04","2021-07-05","2021-07-06","2021-07-07","2021-07-08","2021-07-31"]
}
}
},
{
"$group":{
_id: "$day",
count: { $sum: 1},
sumPrice: { $sum:"$price" }
}
}
)