How to perform an update on a nested object's array inside an array

Question

I want to perform an update on a field which is present in a nested object in an array.

Consider this:

var PlatformPhotoAlbumSchema = new Schema({
  platformAlbumId: String,
  platformPhotoIds: [String]
}, { _id : false });

var SocialProfileSchema = new Schema({
  platformPhotoAlbums: [PlatformPhotoAlbumSchema]
});

Example:

{
platformPhotoAlbums: [
    {
    platformAlbumId: "a",
    platformPhotoIds: ["1","2"]
    },
    {
    platformAlbumId: "b",
    platformPhotoIds: ["3","4"]
    },
    {
    platformAlbumId: "c",
    platformPhotoIds: ["5","6"]
    }
]

}

How can I update an existing object, for e.g., platformAlbumId with "c" with platformPhotoIds: ["5","6","7"]
If there is no document with platformAlbumId with "c", then create a new object with platformAlbumId as "c" and platformPhotoIds: ["5","6","7"] and insert into platformPhotoAlbums.

I want to do this in one single mongodb query. Any idea how can this be done ?

have you tried using the lodash library?

Hoang
– Hoang

2015-08-28 19:34:51 +00:00
Commented Aug 28, 2015 at 19:34 — Hoang
– Hoang, Commented Aug 28, 2015 at 19:34

wesww · Accepted Answer · 2015-08-28 20:01:23Z

1

from the looks of what you're trying to accomplish, I think there is a simpler concept to think of for what your query actually will need to do

you want to push a new object into an array of objects that looks like

{
  platformAlbumId: "c",
  platformPhotoIds: ["5","6"]
}

and (before doing that) remove all preexisting items in the array that match a find for platformAlbumId: "c"

Edit:

actually better than that, you should be able to use findAndModify command with the query of your platformAlbumId values, update set with your new platformPhotoIds values, and upsert bool set to true http://docs.mongodb.org/manual/reference/command/findAndModify/

edited Aug 28, 2015 at 20:01

answered Aug 28, 2015 at 19:53

wesww

2,87320 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to perform an update on a nested object's array inside an array

1 Answer 1

Edit:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Edit:

Comments

Your Answer

Sign up or log in

Post as a guest

Related