[MongoDB] Insert, find -- 1

MongoDB is JSON Document:

 

How to start MongoDB client:

mongod //start the server

mongo // start the cli

 

How to restore a database:

mongorestore can create a new database or add data to an existing database.

If you restore to an existing database, mongorestore will only insert into the existing database, and does not perform updates of any kind. If existing documents have the same value _id field in the target database and collection, mongorestore will not overwrite those documents.

Read More: http://docs.mongodb.org/manual/reference/program/mongorestore/

Download the resoure: http://poeticoding.com/downloads/mongodb/mongodb_poeticoding_blog.zip

 

How to import json file into database:

mongoimport --db simple --collection people --jsonArray data.json

Read More: http://docs.mongodb.org/manual/reference/program/mongoimport/

 

Simple commands:

//show all the database:
show dbs;

//show all collections:
show collections;

//create or use one database
use <database_name>

 

Insert:

The data you have:

{
    title: "My first blog post",
    author:{
        firstName: "YY",
        lastName: "KK",
        email: "[email protected]"
    },
    tags: ["coding", "database"],
    pubData: new Date
}

Cmd:

//insert into the posts collection
db.posts.insert({
    title: "My first blog post",
    author:{
        firstName: "YY",
        lastName: "KK",
        email: "[email protected]"
    },
    tags: ["coding", "database"],
    pubData: new Date
});

 

Note: _id should be unique.

 

Find:

//get the oldest inserted data
db.posts.findOne();
//get all the data
db.posts.find();
db.posts.find().count(); //count the amount
db.posts.find().pretty(); //make output looks pretty
//Find according to the criteria

//Find the title which is AngularJS
db.posts.find({title: "AngularJS"}); 

//Find the title whcih contains AngularJS
db.posts.find({title: /AngularJS/i}); 
//Find title contains ‘ios‘, only show title, not _id in the result
db.posts.find({title: /ios/i}, {title:1, _id: 0});

 

Javascript code for this: (something should looks like)

    Posts.find({title: /ios/i}).select("title").exec(function(err, data) {
        response.json(200, data);
    })

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。