Mongodb $push in nested array

Question

I want add new data my nested array

My document is:

{
  "username": "erkin",
  "email": "[email protected]",
  "password": "b",
  "playlists": [
    {
      "_id": 58,
      "name": "asdsa",
      "date": "09-01-15",
      "musics": [
        {
          "name": "INNA - Cola Song (feat. J Balvin)",
          "duration": "3.00"
        },
        {
          "name": "blabla",
          "duration": "3.00"
        }
      ]
    }
  ]
}

I want add music in this playlist section:

{
  "username": "erkin",
  "email": "[email protected]",
  "password": "b",
  "playlists": [
    {
      "_id": 58,
      "name": "asdsa",
      "date": "09-01-15",
      "musics": [
        {
          "name": "INNA - Cola Song (feat. J Balvin)",
          "duration": "3.00"
        },
        {
          "name": "blabla",
          "duration": "3.00"
        },
        {
          "name": "new",
          "duration": "3.00"
        }
      ]
    }
  ]
}

Here is what I tried:

$users->update(
  array(
    '_id' => new MongoId (Session::get('id')),
    'playlists._id' => $playlistId
  ),
  array(
    '$push' => array('playlists.musics' => array(
      'name' => 'newrecord',
      'duration' => '3.00'
    ))
  )
);

Just to fill you in on the reason people downvote or vote to close here. Post the relevant parts of code in your question. Do not externally link ( likely to break ) and don't make us read though long listings just to work out what you are talking about. Read this: stackoverflow.com/help/mcve — Neil Lunn
– Neil Lunn, Commented Jan 10, 2015 at 9:38

Neil Lunn · Accepted Answer · 2015-01-11 01:25:41Z

111

Probably something like this where ID is your ObjectId. The first {} are necessary to identify your document. It is not required to use an ObjectId as long as you have another unique identifier in your collection.

db.collection.update(
    { "_id": ID, "playlists._id": "58"},
    { "$push": 
        {"playlists.$.musics": 
            {
                "name": "test name",
                "duration": "4.00"
            }
        }
    }
)

edited Jan 11, 2015 at 1:25

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

answered Jan 10, 2015 at 11:26

Thomas Bormans

5,4127 gold badges37 silver badges51 bronze badges

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

11 Comments

balkondemiri Over a year ago

Hi. You not specify playlist _id. I have multiple playlist every user

Thomas Bormans Over a year ago

@balkondemiri That possible. I am not able to test it so it was a guess. Nevertheless it should put you in the right direction.

balkondemiri Over a year ago

Mongodb console say "exception: SyntaxError: Unexpected token ." paste.ubuntu.com/9706780

Neil Lunn Over a year ago

@balkondemiri The "playlists._id" key needs to be "quoted" much as I have done here. It was just a syntax mistake in the answer. It is good practice to "quote" all keys in object definitions. JavaScript allows you do "valid" things without the quotes, but true JSON expects quoted keys.

balkondemiri Over a year ago

Thank you everyone. I update my query. {"_id": ObjectId("54ad6c115e03635c0c000029"), "playlists._id": 58}

|

adflytec · Accepted Answer · 2018-10-24 02:55:02Z

9

This way it worked for me!

"playlists.$[].musics":

db.collection.update(
{ "_id": ID, "playlists._id": "58"},
{ "$push": 
    {"playlists.$[].musics": 
        {
            "name": "test name",
            "duration": "4.00"
        }
    }
 }
)

https://docs.mongodb.com/manual/reference/operator/update/positional-filtered/#position-nested-arrays-filtered

answered Oct 24, 2018 at 2:55

adflytec

1571 silver badge8 bronze badges

1 Comment

ndmhta Over a year ago

this will push the new record in all the array elements of "playlists" entity.

doruksahin · Accepted Answer · 2022-05-03 10:27:26Z

5

I suggest you using arrayFilters since it supports multiple nested documents and clearer.

db.collection.update(
{ "_id": ID},
{ "$push": 
    {"playlists.$[i].musics": 
        {
            "name": "test name",
            "duration": "4.00"
        }
    }
 },
    {
        arrayFilters: [
          {'i._id': 58,},
        ],
      },
)

answered May 3, 2022 at 10:27

doruksahin

3961 gold badge5 silver badges12 bronze badges

Comments

Žygimantas · Accepted Answer · 2022-09-27 13:24:31Z

0

2022 update:

Full snippet:

from pymongo import MongoClient
client = MongoClient('mongodb://localhost:27017/', maxPoolSize=50)

db = client.name_of_db
collection = db["name_of_collection"]

To push:

collection.find_one_and_update(
    {"_id": 'id_of_the_document'}, 
    {"$push": {"key":"value"}})

To push into nested:

collection.find_one_and_update(
    {"_id": 'id_of_the_document'}, 
    {"$push": {"key.nested_key":"value"}})

edited Sep 27, 2022 at 13:24

answered May 3, 2022 at 15:55

Žygimantas

3313 silver badges16 bronze badges

Collectives™ on Stack Overflow

Mongodb $push in nested array

4 Answers 4

11 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

11 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related