How to update multiple values in Mongodb using pymongo?

Question

In my code when a process starts the following data are stored in my core_pid table.

db.core_pid.insert({"blog_id": blog["_id"], "proid": str(p.pid), "starttime": datetime.now(pytz.timezone('EST')), "status": "Running", "route":routing})

After the process is completed i updated the value of status using the below code.

db.core_pid.update({"_id": current_id},
                       {"$set": {"status": "Completed"}})

Now i want to include a new field endtime in database when process is completed ({"endtime": datetime.now(pytz.timezone('EST'))}).How can i alter the above update code to include this endtime field too.

seikichi · Accepted Answer · 2014-03-17 05:50:51Z

11

Simply, include the "endtime" field in "$set" value

db.core_pid.update({"_id": current_id},
                   {"$set": {
                       "status": "Completed",
                       "endtime": datetime.now(pytz.timezone('EST'))}})

answered Mar 17, 2014 at 5:50

seikichi

1,29113 silver badges15 bronze badges

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

1 Comment

user3162206 Over a year ago

Thanks man. I tried this and it didn't worked before. I thought the query was wrong. The Actual problem was with the variable current_id. Now its working..

Neil Lunn · Accepted Answer · 2014-03-17 05:51:00Z

0

Simply add the other field as an argument to $set:

b.core_pid.update({"_id": current_id},
    {"$set": { 
        "status": "Completed",
        "endtime": datetime.now(pytz.timezone('EST')) 
    }})

And that will just update both of those fields in the document without touching others.

answered Mar 17, 2014 at 5:51

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

Collectives™ on Stack Overflow

How to update multiple values in Mongodb using pymongo?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related