MongoDB簡單使用-查詢操作2

標籤：tee   分組   find   reduce   查看   ever   rmi   log   auth   

1查看當前資料庫的文檔

輸入：

db.media.find()

系統返回：
{ "_id" : ObjectId("5aa490f053350e04ddbd6fa6"), "Type" : "Book", "Title" : "Definitive Guide to MongoDB 3rd ed.", "ISBN" : "978-1-4842-1183-0", "Publisher" : "Apress", "Author" : [ "Hows,David", "Plugge,Eelco", "Membrey,Peter", "Hawkins,Tim" ] }
{ "_id" : ObjectId("5aa4912953350e04ddbd6fa7"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [ { "Track" : "1", "Title" : "Smells Like Teen Spirit", "Length" : "5:02" }, { "Track" : "2", "Title" : "In Bloom", "Length" : "4:15" } ] }
{ "_id" : ObjectId("5aa4915453350e04ddbd6fa8"), "Type" : "Book", "Title" : "Definitive Guide to MongoDB 3rd ed.", "ISBN" : "978-1-4842-1183-1", "Publisher" : "Apress", "Author" : [ "Hows,David", "Plugge,Eelco", "Membrey,Peter", "Hawkins,Tim" ] }

2使用distinct()函數擷取唯一值

db.media.distinct("Title")

系統返回：

[ "Definitive Guide to MongoDB 3rd ed.", "Nevermind" ]

3使用group()分組

db.media.group({key:{Title:true},initial:{Total:0},reduce:function(items,prev){prev.Total += 1}})

系統返回：

[
　　{
　　　　"Title" : "Definitive Guide to MongoDB 3rd ed.",
　　　　"Total" : 2
　　},
　　{
　　　　"Title" : "Nevermind",
　　　　"Total" : 1
　　}
]

MongoDB簡單使用-查詢操作2