Adding new property (in the latest array item) in mongodb embedded document

Viewed 213

I habe a mongo document like below:

{
        "_id" : ObjectId("59ccb655071d4c2ceebe190c"),
        "session_deatils" : [
                {
                        "session_start" : 1,
                        "session_complete" : 1,
                        "started_at" : ISODate("2017-09-28T08:42:19.770Z"),
                        "event_count" : 2
                },
                {
                        "session_start" : 1,
                        "session_complete" : 1,
                        "started_at" : ISODate("2017-09-28T08:53:08.618Z"),
                        "event_count" : 1
                },
                {
                        "session_start" : 1,
                        "session_complete" : 1,
                        "started_at" : ISODate("2017-09-28T09:19:42.726Z")
                }
        ],
        "session_id" : "12312312313123",
}

I want to add new field and value like "event_count" in the latest item in session details which is

        {
                "session_start" : 1,
                "session_complete" : 1,
                "started_at" : ISODate("2017-09-28T09:19:42.726Z")
        }

            and I want to update it and the array element should look like below:

        {
                "session_start" : 1,
                "session_complete" : 1,
                "started_at" : ISODate("2017-09-28T09:19:42.726Z"),
                "event_count" : 3
        }

I tried like below:

collection.update({"session_deatils.started_at":  datetime.datetime(2017, 9, 28, 9, 22, 3, 459000)}, {"$set":{"session_deatils.event_count":3}}) 

which adds new property in parrent docuemnt.

Is there a way I can achieve that? thanks in advance

0 Answers
Related