Push new value to inner array with Lithium and MongoDB

Question

I have a structure like this:

[_id] => MongoId Object (
    [$id] => 4e91bcb40b7aab256c000000
)
[campaigns] => Array (
    [0] => Array (
        [campaign_id] => 4e91bcd10b7aab2b6c000000
        [refer_code] => AjZCJR
        [owner] => 1
        [campaign_name] => Test Campaign
        [users] => Array (
        )
    )
    [1] => Array (
        [campaign_id] => 4e9210600b7aab276c000000
        [refer_code] => FQIMJd
        [owner] => 1
        [campaign_name] => New Test Campaign
        [users] => Array (
        )
    )
)

I would like to be able to update the campaigns array with new fields and update the existing fields, on the match of the ID.

Currently I am trying to do the following:

$data = array('campaign_name'=>'changed', 'new_field'=>'its new');
User::update(array('$push'=>array('campaigns.$'=>$data)),array('campaigns.campaign_id'=>$campaign_id));

However that is not working - I'm using the positional operator in order to try and match the array to the condition statement, as without it, it just creates a new array within the campaigns array.

I understand I am probably using it wrong, as I presume it should be used by doing

'campaigns.$.campaign_name'=>'changed'

However I don't want to be limited to specifying it each time, and was wondering the best way to do this type of update without using a for loop and adding each piece of data (which I'm currently doing as follows:)

$data = array();
foreach($this->request->data as $key=>$value) {
    $data['campaigns.$.'.$key] = $value;
}
User::update($data,array('campaigns.campaign_id'=>$campaign_id));

If someone could let me know the 'proper' way to do this, that would be great!

Thanks :)

Dan

score 0 · Answer 1 · answered Oct 10 '11 at 00:58

0

Just update:

$co = array(
        '$pull' => array('campaigns.1" => array('campaign_name' => 'changed'' ) )
);

$p->update(array("_id" => new MongoId( $MongoID  )), $co);

answered Oct 10 '11 at 00:58

user956584

5,316
3
40
50

Would the 'campaigns.1' only update the first item in the array though? As opposed to the array item that matches the query? – Dan Oct 10 '11 at 08:39
Item with index 1 eq campaigns.2 campaigns.3 campaigns.4 etc – user956584 Oct 11 '11 at 03:55

Push new value to inner array with Lithium and MongoDB

1 Answers1