Push into outer array if id in outer array doesnot match or push into inner array if id in outer array match

Question

I have model like this

     {
     "array1": [
                {
                    "_id": "123",
                    "array2": [
                          {
                              "_id": "123",
                              "answeredBy": [],
                          }

                     ],
                 }
             ] 
}

If I have id in array1, push the document into array2 or create new document in array1.

Eg:

If I give have new object

{
   "_id": "456",
   "answeredBy": [],
}

and if given _id of array1 as 123

the result should be

      {  
   "array1":[  
      {  
         "_id":"123",
         "array2":[  
            {  
               "_id":"123",
               "answeredBy":[  

               ],

            },
            {  
               "_id":"456",
               "answeredBy":[  

               ],

            }
         ],

      }

else if give _id of array1 as other than 123 i.e., non existing i.e., 657

the result sholud be

{  
   "array1":[  
      {  
         "_id":"123",
         "array2":[  
            {  
               "_id":"123",
               "answeredBy":[  

               ],

            },

         ],

      }      {  
         "_id":"657",
         "array2":[  
            {  
               "_id":"456",
               "answeredBy":[  

               ],

            }
         ],

      }

result should be

How can I achieve this?

score 1 · Answer 1 · answered Feb 01 '18 at 15:13

1

Your question is similar except you push in both updates.

It is not possible to perform your request atomically so you'll need two update queries one for each request.

Update when the matching outer record is found which results in a update by pushing the new element in the inner array.

db.col.update(
    {"array1._id": "123"},
    {"$push":{"array1.$.array2":{"_id":"456","answeredBy":[]}}}
)

Update when the outer record is not matched you will get modified count of 0.

db.col.update(
    {"array1._id": "657"},
    {"$push":{"array1.$.array2":{"_id":"456","answeredBy":[]}}}
)

if(nModified == 0) {
  db.col.update(
    {},
    {"$push":{"array1":{ "_id":"657","array2":[{"_id":"456","answeredBy":[]}}}}
  )
}

You can read the linked answer for more details.

answered Feb 01 '18 at 15:13

s7vr

73,656
11
106
127

can't I do it in single query? – Kodanda Rama Durgarao Poluri Feb 01 '18 at 15:17
No, you cannot for nested arrays. upsert works at document level – s7vr Feb 01 '18 at 15:18
Thank you. I was trying to do in single query which may reduce one db hit in my application. – Kodanda Rama Durgarao Poluri Feb 01 '18 at 15:20

Push into outer array if id in outer array doesnot match or push into inner array if id in outer array match

1 Answers1