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

Popular posts from this blog

Python - Mathematical Functions - Hexadecimal, Binary, Exponential, Absolute, Round

🐍 Some mathematical functions are in-built in python. Here are some of them. Convert Decimal to Hexadecimal hex(246) Output: '0xf6' hex(512) Output: '0x200' 0x is prefix to all hexadecimal numbers in output. The number after 0x is the hexadecimal value. Convert Decimal to Binary bin(1234) Output: '0b10011010010' bin(246) Output: '0b11110110' bin(512) Output: '0b1000000000' Exponential Function pow() function is similar to num1**num2, but it comes useful when you want to execute (num1**num2)%num3. Passing three arguments to pow(), does this. pow(3,4) Output: 81 This works just like 3**4 pow(3,4,5) Output: 1 But this, works equivalent to (3**4)%5. Either of the two ways can be used. At this point I feel (3**4)%5 is better, as anybody reading the code will understand what is being done immediately. While with pow(2,3,4), the person may have to refer to documentation to understand how this function works. Absolute Value The function abs() is used ...

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...

Binary Tree Traversal in Python - In Order, Pre Order, Post Order

Binary Tree Traversal in Python - In Order, Pre Order, Post Order Run the code here to see output:  https://repl.it/@VinitKhandelwal/iterative-traversal-of-binary-tree # Node Class to Create Object of Nodes class Node (): def __init__ ( self , value , left= None , right= None ): self .value = value self .left = left self .right = right # Creation of a Binary Tree class BinaryTree (): def __init__ ( self , mylist ): self .mylist = mylist self .root=Node ( None ) for value in self .mylist : self .curr= self .root self ._add ( value ) def _add ( self , value ): if self .curr.value == None : self .curr.value = value else : if self .curr.value > value : if self .curr.left == None : self .curr.left = Node ( value ) else : self .curr = self .curr.left self ._add ( value ) else : if self...