mongodb操作

撰写报告

实验名称：课程名称：实验学期：

班级名称：学生姓名：学生学号：

上课地点：实验时间：截止时间：

实验目的：实验指导书：

实验内容：

一、数据库操作

1.显示当前选择的数据库

> db

test

2.创建或切换数据库MyDB

> use MyDB

switched to db MyDB

> db

MyDB

3.查看所有数据库

> show dbs

local 0.078GB

4.向MyDB插入一个文件

> db.movie.insert({"name":"tutorials yiibai"}) WriteResult({ "nInserted" : 1 })

5.查看所有数据库

> show dbs

MyDB 0.078GB

local 0.078GB

6.删除数据库MyDB

> db.dropDatabase()

{ "dropped" : "MyDB", "ok" : 1 }

> show dbs

local 0.078GB

二、集合操作

1.显式和隐式创建集合movie

显示集合创建

> db.createCollection("movie")

{ "ok" : 1 }

> show collections

movie

system.indexes

隐身集合创建

> db.movie.insert({"name":"tutorials yiibai"})

WriteResult({ "nInserted" : 1 })

> show collections

movie

system.indexes

2.查询所有集合

> show collections

movie

system.indexes

3.查看集合总数据量

> db.movie.count()

1

4.查看movie集合所在数据库

> db.movie.getDB()

MyDB

5.查看当前集合movie状态

> db.movie.stats()

{

"ns" : "MyDB.movie",

"count" : 1,

"size" : 112,

"avgObjSize" : 112,

"numExtents" : 1,

"storageSize" : 8192,

"lastExtentSize" : 8192,

"paddingFactor" : 1,

"paddingFactorNote" : "paddingFactor is unused and unmaintained in 3.0. It remains hard coded to 1.0 for compatibility only.",

"userFlags" : 1,

"capped" : false,

"nindexes" : 1,

"totalIndexSize" : 8176,

"indexSizes" : {

"_id_" : 8176

},

"ok" : 1

}

6.集合movie重命名

> db.movie.renameCollection("movies")

{ "ok" : 1 }

> show collections

movies

system.indexes

7.集合movie复制

> db.movies.copyTo("movie")

1

> show collections

movie

movies

system.indexes

8.删除集合movie

> db.movie.drop()

true

> show collections

movies

system.indexes

9.查看集合movie帮助

> db.movies.help()

DBCollection help

db.movies.find().help() - show DBCursor help

db.movies.count()

db.movies.copyTo(newColl) - duplicates collection by copying all documents to newColl; no indexes are copied.

db.movies.convertToCapped(maxBytes) - calls {convertToCapped:'movies', size:maxBytes}} command

db.movies.dataSize()

db.movies.distinct( key ) - e.g. db.movies.distinct( 'x' )

db.movies.drop() drop the collection

db.movies.dropIndex(index) - e.g. db.movies.dropIndex( "indexName" ) or db.movies.dropIndex( { "indexKey" : 1 } )

db.movies.dropIndexes()

db.movies.ensureIndex(keypattern[,options])

db.movies.explain().help() - show explain help

db.movies.reIndex()

db.movies.find([query],[fields]) - query is an optional query filter. fields is optional set of fields to return.

e.g. db.movies.find( {x:77} , {name:1, x:1} )

db.movies.find(...).count()

db.movies.find(...).limit(n)

db.movies.find(...).skip(n)

db.movies.find(...).sort(...)

db.movies.findOne([query])

db.movies.findAndModify( { update : ... , remove : bool [, query: {}, sort: {}, 'new': false] } )

db.movies.getDB() get DB object associated with collection

db.movies.getPlanCache() get query plan cache associated with collection