mongodb: update nested document by an array?

Question

I have a deeply nested PHP array which I saved as a document in Mongo and ended up with this structure:

{ 
"_id" : "...", 
"categ1" : { 
    "aaa" : 112.6736, 
    "bbb" : 83.9137, 
    "ccc" : 80.3322,
     .....
    }, 
"categ2" : { 
    "xxx" : 1, 
    "yyy" : 22, 
    "zzz" : 7,
    "subcateg" : {
         "sub1" : 1,
         "sub2" : 22
         }
    } 
}

Now, I have another array with a similar structure and I would like to increase the values of the record, by the values of the modifier array:

$modifier=array(
    'categ1' => array(
          'aaa' => 3,
          'bbb' => -1,
          'mmm' => 11
        ),
     'categ2' => array(
           'yyy' => -2,
           'subcateg' => array(
                 'sub1' => -1
            )
        )
     );

How can I increase the values inside the document by the values of the $modifier all at once, in a single query, and without loading the entire document ?

I've looked around the web but couldn't find any info on this. Also, i'm pretty newbie at Mongo. Thanks

What you meant by increase the values of the record? Did you mean replace by modifier — Abhi
– Abhi, Commented Dec 22, 2014 at 18:56
what i mean is: i need to increase the values of aaa, bbb, xxx by those specified in modifier[aaa,bbb....] — Mixxed
– Mixxed, Commented Dec 22, 2014 at 18:57

Community · Accepted Answer · 2017-05-23 10:33:39Z

1

You can get your $modifier array to look like this:

$modifier = array(
  'categ1.aaa' => 3,
  'categ1.bbb' => -1,
  'categ1.mmm' => 11,
  'categ2.yyy' => -2,
  'categ2.subcateg.sub1' => -1
)

Link for how to get that.

Then you should be able to simply use:

$col->update(
    array("_id" => "..."),
    array('$inc' => $modifier),
    array("upsert" => true)
);

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Dec 22, 2014 at 19:48

NoOutlet

1,9692 gold badges14 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

mongodb: update nested document by an array?

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