Mongodb查询语句

最新推荐文章于 2024-11-15 18:38:47 发布

aitui8236

最新推荐文章于 2024-11-15 18:38:47 发布

阅读量96

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/yjq-code/p/9035644.html

版权

db.getCollection('RpcMonitor_Request').find(
{
"RequestStartTime" :
{
$gt :ISODate("2018-05-14 02:00"),
$lt:ISODate("2018-05-14 04:00")
},
"_id":ObjectId("5af8fc5809d8d057f6a734e4")
})

db.getCollection('RpcMonitor_Request').aggregate(
[
{
$group:
{
RequestCount:{$sum:1},
_id:
{
"RequestDay": { $dateToString: { format: "%Y-%m-%d", date: "$RequestStartTime" } },
"RequestTypeName":"$RequestTypeName",
"RequestMethodName":"$RequestMethodName"
}
}
},
{ $project : {"_id": 0, "RequestDay" : "$_id.RequestDay", "RequestTypeName" : "$_id.RequestTypeName", "count" : "$RequestCount","RequestMethodName":"$_id.RequestMethodName"}}
])

db.getCollection('RpcMonitor_Request').aggregate(
[
{$match:{
"RequestStartTime" :
{
$gt :ISODate("2018-05-14 02:00"),
$lt:ISODate("2018-05-14 04:00")
}
}},
{
$group:
{
RequestCount:{$sum:1},
_id:
{
"RequestDay": { $dateToString: { format: "%Y-%m-%d", date: "$RequestStartTime" } },
"RequestTypeName":"$RequestTypeName",
"RequestMethodName":"$RequestMethodName"
}
}
},
{ $project : {"_id": 0, "RequestDay" : "$_id.RequestDay", "RequestTypeName" : "$_id.RequestTypeName", "count" : "$RequestCount","RequestMethodName":"$_id.RequestMethodName"}}
])

var group = new BsonDocument
{
{ "_id", new BsonDocument
{
{ "Month", new BsonDocument("$month", "$RequestStartTime") },
{ "Day", new BsonDocument("$dayOfMonth", "$RequestStartTime") },
{ "Year", new BsonDocument("$year", "$RequestStartTime") },
{ "RequestMethodName", "$RequestMethodName" },
{ "RequestTypeName", "$RequestTypeName" },
{ "IsSuccess", "$IsSuccess" },
}
},
{ "Count", new BsonDocument("$sum", 1) } };
var project = new BsonDocument
{
{
"_id",0
},
{
"RequestMethodName","$_id.RequestMethodName"
},
{
"RequestTypeName","$_id.RequestTypeName"
},
{
"IsSuccess","$_id.IsSuccess"
},
{
"TotalCount","$Count"
}
};

var group = new BsonDocument
{
{ "_id", new BsonDocument
{
{ "RequestTime",new BsonDocument{
{
"$dateToString",new BsonDocument{
{ "format","%Y-%m-%d %H:%M"},
{"date", "$RequestStartTime" }
}
}
} },
{ "Day", new BsonDocument("$dayOfMonth", "$RequestStartTime") },
{ "Year", new BsonDocument("$year", "$RequestStartTime") },
{ "RequestMethodName", "$RequestMethodName" },
{ "RequestTypeName", "$RequestTypeName" },
{ "IsSuccess", "$IsSuccess" },
}
},
{ "Count", new BsonDocument("$sum", 1) } };