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

Python - List - Append, Count, Extend, Index, Insert, Pop, Remove, Reverse, Sort

🐍 Advance List List is widely used and it's functionalities are heavily useful. Append Adds one element at the end of the list. Syntax list1.append(value) Input l1 = [1, 2, 3] l1.append(4) l1 Output [1, 2, 3, 4] append can be used to add any datatype in a list. It can even add list inside list. Caution: Append does not return anything. It just appends the list. Count .count(value) counts the number of occurrences of an element in the list. Syntax list1.count(value) Input l1 = [1, 2, 3, 4, 3] l1.count(3) Output 2 It returns 0 if the value is not found in the list. Extend .count(value) counts the number of occurrences of an element in the list. Syntax list1.extend(list) Input l1 = [1, 2, 3] l1.extend([4, 5]) Output [1, 2, 3, 4, 5] If we use append, entire list will be added to the first list like one element. Extend, i nstead of considering a list as one element, it joins the two lists one after other. Append works in the following way. Input l1 = [1, 2, 3] l1.append([4, 5]) Output...
Post a Comment
Read more

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

Python Class to Calculate Distance and Slope of a Line with Coordinates as Input

🐍  Can be run on Jupyter Notebook #CLASS DESIGNED TO CREATE OBJECTS THAT TAKES COORDINATES AND CALCULATES DISTANCE AND SLOPE class Line:     def __init__(self,coor1,coor2):         self.coor1=coor1         self.coor2=coor2 #FUNCTION CALCULATES DISTANCE     def distance(self):         return ((self.coor2[0]-self.coor1[0])**2+(self.coor2[1]-self.coor1[1])**2)**0.5 #FUNCTION CALCULATES SLOPE         def slope(self):         return (self.coor2[1]-self.coor1[1])/(self.coor2[0]-self.coor1[0]) #DEFINING COORDINATES coordinate1 = (3,2) coordinate2 = (8,10) #CREATING OBJECT OF LINE CLASS li = Line(coordinate1,coordinate2) #CALLING DISTANCE FUNCTION li.distance() #CALLING SLOPE FUNCTION li.slope()
Post a Comment
Read more