MongoDB update an array element matching a condition using $push

Question

I'm using Python and Mongo for the fist time together and in documentation I wasn't able to find what I need.

So my data object looks like this

{
"_id" : ObjectId("54d372597d74523bc6991b9b"),
"id_user" : "2000001",
"date_registrated" : "2015-01-21 12:11:28.185",
"user" : "Bogdan",
"gender" : "M",
"email" : "[email protected]",
"charachters" : [ 
    {
        "quest_info" : "TUT_var,1421842359 STARTAREA,4 ",
        "char_name" : "Testarion"
    }
]
}

And I want to add new field into existing charachters, something like

party_user = {"party_name": "name",
               "admin": 0}

And finally I want to get this:

{
"_id" : ObjectId("54d372597d74523bc6991b9b"),
"id_user" : "2000001",
"date_registrated" : "2015-01-21 12:11:28.185",
"user" : "Bogdan",
"gender" : "M",
"email" : "[email protected]",
"charachters" : [ 
    {
        "quest_info" : "TUT_var,1421842359 STARTAREA,4 ",
        "char_name" : "Testarion"
        **"parties" : [{party 1},{party 2}]**
    }
]
}

The problem is how to create query that makes that ? I've tried with something like this but it failed miserably:

db.collection('MyDB').update(
                {"char_name": "Testarion"},
                {"$push": {
                    "charachters": {"parties": party_user}
                }})

I'm still new with Mongo and haven't catched up all the things but can you please show me what am I doing wrong ? Is that even possible ?

anhlc · Accepted Answer · 2015-02-06 04:43:08Z

3

Use '$' in your update query for that array element:

db.collection.update(
   {"charachters.char_name": "Testarion"},
   {"$push": {"charachters.$.parties": "party_user"}})

answered Feb 6, 2015 at 4:43

anhlc

14.6k4 gold badges38 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

MongoDB update an array element matching a condition using $push

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related