mongodb update/upsert that adds data to the existing document instead of replacing data in an existing document

Question

I am using an upsert using mongodb's Jensseger PHP library. Every time I add new data to the document it updates the value of the field if the field names are the same. I want to add to the document's data instead of replacing it.

An example of a record in my session_activities collection:

"_id" : ObjectId("622f8da565fbcea0a1b4ed12"),
"activity" : [
                {
                        "name" : "Fullscreen Off",
                        "time" : 219.972769,
                        "value" : 0
                },
                {
                        "name" : "Player Resize",
                        "time" : 220.074389,
                        "value" : 354
                },
                {
                        "name" : "close",
                        "time" : 223.779885,
                        "value" : 369
                }
        ]

If that record has a new "Player Resize" event at 500 seconds I want the document to change to:

  "_id" : ObjectId("622f8da565fbcea0a1b4ed12"),
        "activity" : [
                        {
                                "name" : "Fullscreen Off",
                                "time" : 219.972769,
                                "value" : 0
                        },
                        {
                                "name" : "Player Resize",
                                "time" : 220.074389,
                                "value" : 354
                        },{
                                "name" : "Player Resize",
                                "time" : 500,
                                "value" : 354
                        },
    
                        {
                                "name" : "close",
                                "time" : 223.779885,
                                "value" : 369
                        }
                ]

Right now the Player Resize field is being overwritten with the new value. My mongo statement looks like the below:

(new VideoAnalytics)->where($whereStatement)->update($this->newobj, ['upsert' => true])

score 0 · Answer 1 · answered Mar 15 '22 at 13:41

0

If you give the entire object with the key values you provided into the MongoDB update method it will replace the whole record, instead of that please start using $set in MongoDB to set the specific keys. Here also I'm adding a reference link for better understanding.

https://php.uz/manual/en/mongocollection.update.php

new VideoAnalytics->update(
    $whereStatement,
    array('$set' => $this->newobj),
    array('upsert' => true)
);

answered Mar 15 '22 at 13:41

Jijo Alexander

1,230
8
17

I don't want to replace the data. I want to add to it. – SJW525 Mar 15 '22 at 13:43
yes, that's where you can start using $set, please refer to the link I added in the answer – Jijo Alexander Mar 15 '22 at 13:45
It says " The dollar ($) prefixed field '$addToSet' in '$addToSet' is not valid for storage" – SJW525 Mar 15 '22 at 20:21
why your using $addToSet in update, $addToSet is the method using to add a new key while using aggregation function – Jijo Alexander Mar 15 '22 at 21:05

score 0 · Answer 2 · answered May 18 '22 at 13:42

0

as I understand, you wanna update by pushing a new element to the array, right?

this might help push new value to mongodb inner array - mongodb/php

answered May 18 '22 at 13:42

PepeNietnagel

230
2
10

mongodb update/upsert that adds data to the existing document instead of replacing data in an existing document

2 Answers2