This video tutorial illustrates loading data to mongoDB server from an external JavaScript file ( Writing script for MongoDB shall )
Here, we write a simple JavaScript file and using command prompt we load the contents of JavaScript file into new Database.
JavaScript file
load.js – in path: C:/temp/load.js
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | db.person.insert({
name:'Satish',
age:25,
skills:['nodejs', 'mongoDB', 'HTML5']
});
db.person.insert({
name:'Kiran',
age:27,
skills:['PHP', 'mySQL', 'HTML5']
});
db.person.insert({
name:'Sunitha',
age:24,
skills:['html', 'ASP']
}); |
Here we’re inserting some data/record/documents into the collection person.
Database’s Before running the script
1 2 3 4 5 6 7 8 9 10 11 12 13 | C:\>cd mongodb C:\mongodb>cd bin C:\mongodb\bin>mongo MongoDB shell version: 2.4.3 connecting to: test > show dbs admin 0.203125GB company 0.203125GB local 0.078125GB > exit bye |
Before running the script, we have only 3 databases.
Running the script
1 2 3 | C:\mongodb\bin>mongo 127.0.0.1/satish C:/temp/load.js MongoDB shell version: 2.4.3 connecting to: 127.0.0.1/satish |
Here, mongo is the JavaScript shall.
127.0.0.1 is nothing but our localhost.
satish is the new database we are creating.
C:/temp/load.js is the path of load.js file.
We’re loading the contents of load.js file into new database satish.
Database’s After running the script
1 2 3 4 5 6 7 8 9 10 11 12 13 | C:\mongodb\bin>mongo MongoDB shell version: 2.4.3 connecting to: test > show dbs admin 0.203125GB company 0.203125GB local 0.078125GB satish 0.203125GB > use satish switched to db satish > show collections person system.indexes |
New database satish has been added and it has person collection, which we loaded from the JavaScript file.
Documents/records In person collection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | > db.person.find().forEach(printjson)
{
"_id" : ObjectId("518b62443cbad352108c321b"),
"name" : "Satish",
"age" : 25,
"skills" : [
"nodejs",
"mongoDB",
"HTML5"
]
}
{
"_id" : ObjectId("518b62443cbad352108c321c"),
"name" : "Kiran",
"age" : 27,
"skills" : [
"PHP",
"mySQL",
"HTML5"
]
}
{
"_id" : ObjectId("518b62443cbad352108c321d"),
"name" : "Sunitha",
"age" : 24,
"skills" : [
"html",
"ASP"
]
} |
Using find() method we display all its contents.
This way we could load application data from an external JavaScript file.
Writing script for MongoDB shall
[youtube https://www.youtube.com/watch?v=ygK2zE1-k0w]
Note:
This method will be handy while migrating our application from one mongoDB server to another mongoDB server.
There is import/export options in mongoDB, but this method is also helpful if we have some custom data to be inserted. nontheless a useful tool to have.
