Skip to main content

Create Mongo Database From JSON Files

Here is how to create Mongo Database from JSON files.
Create JSON files with data. Example, I have created a json file named players.json with following data:
{
"first_name": "Virat",
"last_name": "Kohli",
"type": "batsman",
"age": 28,
"team": "Delhi Daredevils"
}
{
"first_name": "Mahendra",
"last_name": "Dhoni",
"type": "all rounder",
"age": 38,
"team": "Big Bengaluru"
}
{
"first_name": "Rohit",
"last_name": "Sharma",
"type": "baller",
"age": 32,
"team": "Mohali Wale"
}
and created teams.json file with the following data:
{
"name": "Delhi Daredevils",
"city": "Delhi",
"won": 2
}
{
"name": "Big Bengaluru",
"city": "Bengaluru",
"won": 3
}
{
"name": "Mohali Wale",
"city": "Mohali",
"won": 0
}

Now, lets add this data to collections in a database of MongoDB.

For that open a new terminal/command prompt and run MongoDB by using the command:
mongod
In another terminal open the folder where both the json files are there and run the following commands:
mongoimport --db ipldb --collection players --file players.json
and
mongoimport --db ipldb --collection teams --file teams.json
This will create a database named ipldb abd add two collections to it namely players and teams with three records each as found in the json files.

Now to view the database collections and it's documents, run the following:

mongo ipldb

  • This will open the database named ipldb

db.players.find()




  • This will show all documents in players collection
db.teamss.find()




  • This will show all documents in teams collection

Comments

Post a Comment

Popular posts from this blog

Difference between .exec() and .execPopulate() in Mongoose?

Here I answer what is the difference between .exec() and .execPopulate() in Mongoose? .exec() is used with a query while .execPopulate() is used with a document Syntax for .exec() is as follows: Model.query() . populate ( 'field' ) . exec () // returns promise . then ( function ( document ) { console . log ( document ); }); Syntax for .execPopulate() is as follows: fetchedDocument . populate ( 'field' ) . execPopulate () // returns promise . then ( function ( document ) { console . log ( document ); }); When working with individual document use .execPopulate(), for model query use .exec(). Both returns a promise. One can do without .exec() or .execPopulate() but then has to pass a callback in populate.
1 comment
Read more

Two Ways of rendering in React Examples

Two Ways of rendering in React Examples 1 - Render twice HTML < div id = "p1" ></ div > < div id = "p2" ></ div > CSS . person { display : inline - block ; margin : 10px ; border : 1px solid # eee ; box - shadow : 0 2px 2px # ccc ; } JAVASCRIPT (Babel) function Person ( props ) { return ( < div className = ' person "> < h1 >{ props . name }</ h1 > < p > Age :{ props . age }</ p > </ div > ); } ReactDOM . render (< Person name = "VK" age = "29" />, document . querySselector ( '#p1' )); ReactDOM . render (< Person name = "HK" age = "28" />, document . querySselector ( '#p2' )); 2 Render all at once HTML < div id = "app" ></ div > CSS . person { display : inline - block ; margin : 1...
Post a Comment
Read more

Resolve: Uncaught TypeError: firebase.database is not a function

If you are getting the error: Uncaught TypeError: firebase.database is not a function Resolve it by including firebase-database.js in your html page as follows: <!-- The core Firebase JS SDK is always required and must be listed first --> <script defer src = "https://www.gstatic.com/firebasejs/6.2.4/firebase-app.js" ></script> <script defer src = "https://www.gstatic.com/firebasejs/3.1.0/firebase-database.js" ></script> That is it. Let me know if this was helpful.
Post a Comment
Read more