‘mongoimport’ command is used to import the documents from a file.
Append data to the existing collection
mongoimport {file_path_to_import} -d {database_name} -c {collection_name} --jsonArray
Drop the existing data from the collection and import the data from the file
mongoimport {file_path_to_import} -d {database_name} -c {collection_name} --jsonArray --drop
Let’s see it with an example. For example, employee collection has following data.
> db.employee.find() { "_id" : ObjectId("60c97d29fc455868b4f32101"), "firstName" : "Krishna", "lastName" : "Gurram", "age" : 31 } { "_id" : ObjectId("60c97dbcfc455868b4f32102"), "firstName" : "Siva", "lastName" : "Ponnam", "age" : 34 }
Now I want to append data to the employee collection from
emp1.json
[
{
"firstName" : "Chamu",
"lastName" : "Gurram"
},
{
"firstName" : "Harini",
"lastName" : "Maj"
}
]
$mongoimport /Users/Shared/mongodb/emp1.json -d sample -c employee --jsonArray
2021-06-16T15:53:48.372+0530 connected to: mongodb://localhost/
2021-06-16T15:53:48.377+0530 2 document(s) imported successfully. 0 document(s) failed to import.
Let’s query employee collection again.
> db.employee.find() { "_id" : ObjectId("60c97d29fc455868b4f32101"), "firstName" : "Krishna", "lastName" : "Gurram", "age" : 31 } { "_id" : ObjectId("60c97dbcfc455868b4f32102"), "firstName" : "Siva", "lastName" : "Ponnam", "age" : 34 } { "_id" : ObjectId("60c9d1349f878ae6f54110f0"), "firstName" : "Harini", "lastName" : "Maj" } { "_id" : ObjectId("60c9d1349f878ae6f54110f1"), "firstName" : "Chamu", "lastName" : "Gurram" }
Drop all the documents from employee collection and add documents from emp2.json file
emp2.json
[ { "firstName" : "Venkatesh", "lastName" : "Battula" }, { "firstName" : "Maruthi", "lastName" : "Bolisetty" } ]
$mongoimport /Users/Shared/mongodb/emp1.json -d sample -c employee --jsonArray --drop
2021-06-16T15:57:43.569+0530 connected to: mongodb://localhost/
2021-06-16T15:57:43.570+0530 dropping: sample.employee
2021-06-16T15:57:43.724+0530 2 document(s) imported successfully. 0 document(s) failed to import.
Let’s query employee collection again.
> db.employee.find() { "_id" : ObjectId("60c9d21f304ce763b168f548"), "firstName" : "Chamu", "lastName" : "Gurram" } { "_id" : ObjectId("60c9d21f304ce763b168f549"), "firstName" : "Harini", "lastName" : "Maj" }
Previous Next Home
No comments:
Post a Comment