Command Line
--help
|
Show
command line options
|
--nodb
|
Start
without a db, you can connect later with new Mongo() or connect()
|
--shell
|
After
running a .js file from the command line, stay in the shell rather than
terminating
|
Special Command Helpers
Non-javascript convenience macros:
help
|
Show
help
|
db.help()
|
Show
help on db methods
|
db.myColl.help()
|
Show
help on collection methods
|
show
dbs
|
Print
a list of all databases on this server
|
use dbname
|
Set
the db variable to represent usage of dbname on the server
|
show
collections
|
Print
a list of all collections for current database
|
show
users
|
Print
a list of users for current database
|
show
profile
|
Print
most recent profiling operations that took >= 1ms
|
Basic Shell Javascript Operations
db
|
The
variable that references the current database object / connection. Already
defined for you in your instance.
|
db.auth(user,pass)
|
Authenticate
with the database (if running in secure mode).
|
coll
= db.collection
|
Access
a specific collection within the database.
|
cursor
= coll.find();
|
Find
all objects in the collection. See queries.
|
coll.remove(objpattern);
|
Remove
matching objects from the collection.
objpattern is an object specifying fields to match. E.g.: coll.remove( { name: "Joe" } );
|
coll.save(object)
|
Save
an object in the collection, or update if already there.
If your object has a presave method, that method will be called before the
object is saved to the db (before both updates and inserts)
|
coll.insert(object)
|
Insert
object in collection. No check is made (i.e., no upsert) that the
object is not already present in the collection.
|
coll.update(...)
|
Update
an object in a collection. See the Updating documentation; update() has many options.
|
coll.ensureIndex(
{ name: 1 } )
|
Creates
an index on tab.name. Does nothing if index already exists.
|
coll.update(...)
|
|
coll.drop()
|
Drops
the collection coll
|
db.getSisterDB(name)
|
Return
a reference to another database using this same connection. Usage example:db.getSisterDB('production').getCollectionNames()
|
Queries
coll.find()
|
Find
all.
|
it
|
Continue
iterating the last cursor returned from find().
|
coll.find(criteria );
|
Find
objects matching criteria in the collection. E.g.: coll.find( { name: "Joe" } );
|
coll.findOne(criteria );
|
Find
and return a single object. Returns null if not found. If you want only one
object returned, this is more efficient than just find() as limit(1) is implied. You may use regular expressions if the
element type is a string, number, or date: coll.find( { name: /joe/i } );
|
coll.find(
criteria, fields );
|
Get
just specific fields from the object. E.g.: coll.find( {}, {name:true} );
|
coll.find().sort(
{field:1[,field:1] });
|
Return
results in the specified order (field ASC). Use -1 for DESC.
|
coll.find(criteria ).sort(
{ field : 1 } )
|
Return
the objects matching criteria, sorted by field.
|
coll.find(
... ).limit(n)
|
Limit
result to n rows. Highly recommended if you need only a
certain number of rows for best performance.
|
coll.find(
... ).skip(n )
|
Skip n results.
|
coll.count()
|
Returns
total number of objects in the collection.
|
coll.find(
... ).count()
|
Returns
the total number of objects that match the query. Note that the number
ignores limit and skip; for example if 100 records match but the limit is 10, count() will return 100. This will be faster than iterating
yourself, but still take time.
|
More information: see queries.
Error Checking
db.getLastError()
|
Returns
error from the last operation.
|
db.getPrevError()
|
Returns
error from previous operations.
|
db.resetError()
|
Clear
error memory.
|
Administrative Command Helpers
db.cloneDatabase(fromhost)
|
Clone
the current database from the other host specified. fromhost database must be
in noauth mode.
|
db.copyDatabase(fromdb,
todb, fromhost)
|
Copy
fromhost/fromdb to todb on this server. fromhost must be in noauth mode.
|
db.repairDatabase()
|
Repair
and compact the current database. This operation can be very slow on large
databases.
|
db.addUser(user,pwd)
|
Add
user to current database.
|
db.getCollectionNames()
|
get
list of all collections.
|
db.dropDatabase()
|
Drops
the current database.
|
Opening Additional Connections
db =
connect("<host>:<port>/<dbname>")
|
Open
a new database connection. One may have multiple connections within a single
shell, however, automatic getLastError reporting by the shell is done for the
'db' variable only. See here for
an example of connect().
|
conn
= new Mongo("hostname")
|
Open
a connection to a new server. Use getDB() to
select a database thereafter.
|
db =
conn.getDB("dbname")
|
Select
a specific database for a connection
|
Miscellaneous
Object.bsonsize(db.foo.findOne())
|
prints
the bson size of a db object (mongo version 1.3 and greater)
|
db.foo.findOne().bsonsize()
|
prints
the bson size of a db object (mongo versions predating 1.3)
|
posted on 2010-07-05 11:15
Derek.Guo 阅读(537)
评论(0) 编辑 收藏 所属分类:
NoSqlDB