2019獨角獸企業重金招聘Python工程師標準>>>

游標
> for(i=0;i<100;i++){
... db.c.insert({x:i})
... }
WriteResult({ "nInserted" : 1 })
?var cursor=db.c.find();
> while(cursor.has
cursor.hasNext(???????? cursor.hasOwnProperty(
> while(cursor.hasNext()){
... obj=cursor.next();
... print(obj.x);
... }
> db.c.find().limit(3)
{ "_id" : ObjectId("56a226a66efa22a91f284361"), "x" : 0 }
{ "_id" : ObjectId("56a226a66efa22a91f284362"), "x" : 1 }
{ "_id" : ObjectId("56a226a66efa22a91f284363"), "x" : 2 }
> var cursor=db.c.find().skip(10).limit(5)
> var cursor=db.c.find().skip(10).limit(5)
>? while(cursor.hasNext()){
... ... obj=cursor.next();
... ... print(obj.x);
... }
10
11
12
13
14
> var cursor=db.c.find().skip(10).limit(6).sort({"x":1})
> var cursor=db.c.find().skip(10).limit(6).sort({"x":1})1是升序-1降序
> while(cursor.hasNext()){
... ... ... obj=cursor.next();
... ... ... print(obj.x);
}
10
11
12
13
14
15
用skip實現分頁
var page1=db.find().sort({"date":-1}).limit(100)
var latest=null;
while(page1.hasNext()){
latest=page1.next();
display(latest);
}
//get next page
var page2=db.foo.find({"date":{"$gt":latest.date}});
page2.sort({"date":-1}).limit(100)

mongodb索引
可以任意列建索引
索引構造和使用與傳統關系型數據庫幾乎一樣
使用索引可以加快查詢，但會降低修改，插入等的性能
內嵌文檔也可以建立索引
db.people.insert([
{"username":"hello","age":23,"user_id":0},
{"username":"hello","age":23,"user_id":1},
{"username":"hello","age":23,"user_id":2},
{"username":"hello","age":23,"user_id":3},
{"username":"hello","age":23,"user_id":4},
{"username":"hello","age":23,"user_id":5},
{"username":"hello","age":23,"user_id":6},
{"username":"hello","age":23,"user_id":7},
{"username":"hello","age":23,"user_id":8},
{"username":"hello","age":23,"user_id":9},
{"username":"hello","age":23,"user_id":10}
])
建立索引
db.people.ensureIndex({"username":1})
db.people.ensureIndex({"username":1,"age":-1})
explain查看
> db.people.find().explain();
{
?? ?"cursor" : "BasicCursor",
?? ?"isMultiKey" : false,
?? ?"n" : 11,
?? ?"nscannedObjects" : 11,
?? ?"nscanned" : 11,
?? ?"nscannedObjectsAllPlans" : 11,
?? ?"nscannedAllPlans" : 11,
?? ?"scanAndOrder" : false,
?? ?"indexOnly" : false,
?? ?"nYields" : 0,
?? ?"nChunkSkips" : 0,
?? ?"millis" : 0,
?? ?"server" : "localhost.localdomain:27017",
?? ?"filterSet" : false
}
> db.system.indexes.find();
{ "v" : 1, "key" : { "_id" : 1 }, "name" : "_id_", "ns" : "db.abc" }
{ "v" : 1, "key" : { "_id" : 1 }, "name" : "_id_", "ns" : "db.c" }
{ "v" : 1, "key" : { "_id" : 1 }, "name" : "_id_", "ns" : "db.people" }
{ "v" : 1, "key" : { "username" : 1 }, "name" : "username_1", "ns" : "db.people" }
{ "v" : 1, "key" : { "username" : 1, "age" : -1 }, "name" : "username_1_age_-1", "ns" : "db.people" }
> db.runCommand({"dropIndexes":"people","index":"*"});
{
?? ?"nIndexesWas" : 3,
?? ?"msg" : "non-_id indexes dropped for collection",
?? ?"ok" : 1
}
聚合：count
db.people.count()
> db.runCommand({"distinct":"people","key":"age"})
{
?? ?"values" : [
?? ??? ?23
?? ?],
?? ?"stats" : {
?? ??? ?"n" : 11,
?? ??? ?"nscanned" : 11,
?? ??? ?"nscannedObjects" : 11,
?? ??? ?"timems" : 0,
?? ??? ?"cursor" : "BasicCursor"
?? ?},
?? ?"ok" : 1
}

聚合操作
db.people.group(
{
"key":{"username":true},
"initial":{"csum":0},
"reduce":function(obj,prev){
prev.sum+=obj.age
}
})

db.runCommand({"group":{
"ns":"people",
"key":"username",
"initial":{"csum":0},
"$reduce":function(obj,prev){
prev.sum+=obj.age
}

}})

db.runCommand({"group":{
... "ns":"people",
... "key":"username",
... "initial":{"csum":0},
... "$reduce":function(obj,prev){
... prev.sum+=obj.age
... }
...
... }})
{
?? ?"retval" : [
?? ??? ?{
?? ??? ??? ?"csum" : 0,
?? ??? ??? ?"sum" : NaN
?? ??? ?}
?? ?],
?? ?"count" : 11,
?? ?"keys" : 1,
?? ?"ok" : 1
}
尋找集合中所有的鍵
map=function(){
for(var key in this){
emit(key,{count:1})
}}

reduce=function(key,emits){
total=0;
for(var i in emits){
total+=emits[i].count;
}
return {"count":total};
}
?db.runCommand({"mapreduce":"people","map":map,"reduce":reduce,"out":"result"});
{
?? ?"result" : "result",
?? ?"timeMillis" : 57,
?? ?"counts" : {
?? ??? ?"input" : 11,
?? ??? ?"emit" : 44,
?? ??? ?"reduce" : 4,
?? ??? ?"output" : 4
?? ?},
?? ?"ok" : 1
}

轉載于:https://my.oschina.net/goudingcheng/blog/608237

總結

以上是生活随笔為你收集整理的Mongodb的游标，索引，聚合操作与MapReduce的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。