MongoDB Update for array of object

Question

I am having following document in mongodb

 {
  "_id" : ObjectId("521aff65e4b06121b688f076"),
  "uuid" : "160597270101684",
  sessionId" : "160597270101684.1",
  "stamps" :
           {
            "currentVisit" : "1377500985",
            "lastVisit" : "1377500985"
   },
   visits : [
            {
             "page":"google.com",
             "method": "GET"
             }
            ]
 }

Requirement:

If uuid and sessionId is not present i will insert the document as above otherwise i have to push only the object to visits array.

Any help will be greatful.

JohnnyHK · Accepted Answer · 2013-09-07 14:24:32Z

8

+50

MongoDB supports an upsert option on update that updates the matching document if it exists, and inserts a new document if it doesn't exist. In MongoDB 2.4+ you can use the $setOnInsert operator to further tweak this to set certain fields only if the upsert performs an insert.

db.test.update({ 
    uuid: "160597270101684", 
    sessionId: "160597270101684.1" 
  }, { 
    $setOnInsert: {
      stamps: {
        currentVisit: "1377500985", 
        lastVisit: "1377500985"
      }
    },
    $push:{
      visits: {
        page: "google.com",
        method: "GET"
      }
    }
  }, { upsert:true })

So in the above example, the $push to visits will always occur but the $setOnInsert to stamps will only occur if the matching document doesn't already exist.

edited Sep 7, 2013 at 14:24

answered Sep 7, 2013 at 1:31

JohnnyHK

313k70 gold badges631 silver badges477 bronze badges

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

1 Comment

Nilesh Rajani Over a year ago

Even though its not explicitly mentioned, it seems that stamps would be updated every time as the it contains the data about current and last visit.

Nilesh Rajani · Accepted Answer · 2013-09-06 09:45:05Z

2

You can achieve this by following upsert query:

db.session.update({"uuid" : "160597270101684", sessionId : "160597270101684.1"},
{$set:"stamps" :{"currentVisit" : "1377500985","lastVisit" : "1377500985"}},
 $push :{visits:{"page":"yahoo.com","method": "POST"}}},
{upsert:true})

You can use $addToSet instead of $push if you want to avoid duplicates

answered Sep 6, 2013 at 9:45

Nilesh Rajani

5386 silver badges16 bronze badges

Collectives™ on Stack Overflow

MongoDB Update for array of object

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related