Is it possible to add list of objects into embedded array document in mongo document?

Question

I am having the mongo document as below:

  {
  "_id" : ObjectId("506e9e54a4e8f51423679428"),
  "description" : "ffffffffffffffff", 
  "menus" : [  
            {   
              "_id" : ObjectId("506e9e5aa4e8f51423679429"),     
               "description" : "ffffffffffffffffffff",  
                  "items" : [
                           {    
                          "name" : "xcvxc",     
                          "description" : "vxvxcvxc",   
                          "text" : "vxcvxcvx",  
                          "menuKey" : "0",  
                           "onSelect" : "1",    
                          "_id" : ObjectId("506e9f07a4e8f5142367942f") 
                          } ,
                          {     
                          "name" : "abcd",  
                          "description" : "qqq",    
                          "text" : "qqq",   
                          "menuKey" : "0",  
                           "onSelect" : "3",    
                          "_id" : ObjectId("507e9f07a4e8f5142367942f") 
                          }
                         ] 
             }
         ]
  }

Now i want to change this to :

       {
        "_id" : ObjectId("506e9e54a4e8f51423679428"),
        "description" : "ffffffffffffffff", 
        "menus" : [ 
            {   
              "_id" : ObjectId("506e9e5aa4e8f51423679429"),     
               "description" : "ffffffffffffffffffff",  
                  "items" : {
                           {    
                          "name" : "xcvxc",     
                          "description" : "vxvxcvxc",   
                          "text" : "vxcvxcvx",  
                          "menuKey" : "0",  
                           "onSelect" : "1",    
                          "_id" : ObjectId("506e9f07a4e8f5142367942f") 
                          } ,
                          {     
                          "name" : "abcd",  
                          "description" : "qqq",    
                          "text" : "qqq",   
                          "menuKey" : "0",  
                           "onSelect" : "3",    
                          "_id" : ObjectId("507e9f07a4e8f5142367942f") 
                          }
                       } 
             }

           ]

   }

Is this possible in mongo? In the first schema, updating is not possible atomically becoz we can't use two "$" while updating deep layer. So i thought to change schema as same as second one, how can i achieve it?

For first one i have used "$push" for adding items inside menus...

Any help would be great..

What exactly is the difference between the two? In the second one is there a typo (field names must be strings)? And what is the update that you say is not possible in the first schema? — Thilo
– Thilo, Commented Oct 5, 2012 at 12:03
In the second form items is not a valid Json object. It has to be a key-value pair. — vivek
– vivek, Commented Oct 5, 2012 at 12:05
@Thilo Actually i need to do update atomically , for example:i want to update "name" : "abcd" to "name":"cc" in items. — gauti
– gauti, Commented Oct 5, 2012 at 12:12
@GowtGM: Then you should probably ask about that. Maybe this helps: stackoverflow.com/questions/7425993/… — Thilo
– Thilo, Commented Oct 5, 2012 at 12:14
@Thilo Yes, but there is no possibility for doing that, i can only update using the index value but i need to do with the id. So i am looking for someother schema.. — gauti
– gauti, Commented Oct 5, 2012 at 12:16

Asya Kamsky · Accepted Answer · 2012-10-05 13:16:15Z

0

Your update is changing 'menu' object, so I would suggest changing the schema so that the menu is the top level document, rather than an array in another document.

Menu could either have a field referencing the top level object (in another collection) that it belongs to, or you can denormalize the fields of the top level object into each menu document.

Without knowing complete requirements of the application, it's difficult to know when the schema is "good enough".

answered Oct 5, 2012 at 13:16

Asya Kamsky

42.4k5 gold badges113 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to add list of objects into embedded array document in mongo document?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related