隨筆-86  評論-33  文章-0  trackbacks-0

          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 閱讀(550) 評論(0)  編輯  收藏 所屬分類: NoSqlDB

          只有注冊用戶登錄后才能發表評論。


          網站導航:
           
          MSN:envoydada@hotmail.com QQ:34935442
          主站蜘蛛池模板: 额济纳旗| 湘西| 鲜城| 巴青县| 柘城县| 麻江县| 江孜县| 黎平县| 林芝县| 蒲江县| 洛扎县| 绥宁县| 奉新县| 扶余县| 台中市| 太保市| 泌阳县| 沙河市| 华容县| 西丰县| 广东省| 江源县| 资中县| 阳城县| 彭泽县| 湄潭县| 秦安县| 崇文区| 通榆县| 全州县| 盐边县| 元阳县| 荔波县| 琼中| 洛浦县| 阳原县| 哈巴河县| 枣庄市| 姜堰市| 敦化市| 高台县|