In this post, I am going to explain how to add arrays of data to a document.
Let’s take an employee collection as example.
> db.employee.find().pretty() { "_id" : ObjectId("60bcd0dd8251689f64fb3eee"), "id" : 1, "firstName" : "Joel", "lastName" : "chelli" } { "_id" : ObjectId("60bcd0dd8251689f64fb3eef"), "id" : 2, "firstName" : "Ananad", "lastName" : "Bandaru" } { "_id" : ObjectId("60bcd0dd8251689f64fb3ef0"), "id" : 3, "firstName" : "Gopi", "lastName" : "Battu" } { "_id" : ObjectId("60bcd0dd8251689f64fb3ef1"), "id" : 4, "firstName" : "Ritwik", "lastName" : "Mohenthy" }
Let’s add hobbies to the employee Ritwik.
db.employee.updateOne({"firstName" : "Ritwik"}, {"$set" : {"hobbies" : ["cooking", "trekking", "listening to music"]}})
> db.employee.find().pretty() { "_id" : ObjectId("60bcd0dd8251689f64fb3eee"), "id" : 1, "firstName" : "Joel", "lastName" : "chelli" } { "_id" : ObjectId("60bcd0dd8251689f64fb3eef"), "id" : 2, "firstName" : "Ananad", "lastName" : "Bandaru" } { "_id" : ObjectId("60bcd0dd8251689f64fb3ef0"), "id" : 3, "firstName" : "Gopi", "lastName" : "Battu" } { "_id" : ObjectId("60bcd0dd8251689f64fb3ef1"), "id" : 4, "firstName" : "Ritwik", "lastName" : "Mohenthy", "hobbies" : [ "cooking", "trekking", "listening to music" ] }
Let’s add project details to the employee Gopi.
db.employee.updateOne({"firstName" : "Gopi"}, {"$set" : {"projects" : [
{"projectId" : "ind_cpcs", "name" : "cpcs", "description" : "cabin pressure control system"},
{"projectId" : "ind_veh_tracker", "name" : "vehicle tracker", "description" : "Track the vehicle"}
]}})
> db.employee.updateOne({"firstName" : "Gopi"}, {"$set" : {"projects" : [
... {"projectId" : "ind_cpcs", "name" : "cpcs", "description" : "cabin pressure control system"},
... {"projectId" : "ind_veh_tracker", "name" : "vehicle tracker", "description" : "Track the vehicle"}
... ]}})
{ "acknowledged" : true, "matchedCount" : 1, "modifiedCount" : 1 }
>
> db.employee.find().pretty()
{
"_id" : ObjectId("60bcd0dd8251689f64fb3eee"),
"id" : 1,
"firstName" : "Joel",
"lastName" : "chelli"
}
{
"_id" : ObjectId("60bcd0dd8251689f64fb3eef"),
"id" : 2,
"firstName" : "Ananad",
"lastName" : "Bandaru"
}
{
"_id" : ObjectId("60bcd0dd8251689f64fb3ef0"),
"id" : 3,
"firstName" : "Gopi",
"lastName" : "Battu",
"projects" : [
{
"projectId" : "ind_cpcs",
"name" : "cpcs",
"description" : "cabin pressure control system"
},
{
"projectId" : "ind_veh_tracker",
"name" : "vehicle tracker",
"description" : "Track the vehicle"
}
]
}
{
"_id" : ObjectId("60bcd0dd8251689f64fb3ef1"),
"id" : 4,
"firstName" : "Ritwik",
"lastName" : "Mohenthy",
"hobbies" : [
"cooking",
"trekking",
"listening to music"
]
}
No comments:
Post a Comment