How to push an array of objects into an array in mongoose with one call?

Question

I need to push multiple values into an array in mongoose using one call. I tried doing it using a smaller array but the array is getting inserted as a sub-array.

var kittySchema = new mongoose.Schema({
        name: String,
        values: [Number]
});

var Kitten = db.model('Kitten', kittySchema);
Kitten.update({name: 'fluffy'},{$push: {values:[2,3]}},{upsert:true},function(err){
        if(err){
                console.log(err);
        }else{
                console.log("Successfully added");
        }
});

The result of the calling the above code thrice gives the below result:

{ "_id" : ObjectId("502b0e807809d79e84403606"), "name" : "fluffy", "values" : [ [ 2, 3 ], [ 2, 3 ], [ 2, 3 ] ] }

Whereas what I want is something like this:

{ "_id" : ObjectId("502b0e807809d79e84403606"), "name" : "fluffy", "values" : [ 2, 3 ,2 ,3, 2, 3] }

Another thing I noticed was that the type in the array (values) is specified as Number, then wouldnt the 'strict' option ensure that anything other than Numbers are not inserted ? In this case another array is being allowed to be inserted.

Amit Portnoy · Accepted Answer · 2014-12-13 20:32:05Z

47

(Dec-2014 update) Since MongoDB2.4 you should use:

Kitten.update({name: 'fluffy'}, {$push: {values: {$each: [2,3]}}}, {upsert:true}, function(err){
        if(err){
                console.log(err);
        }else{
                console.log("Successfully added");
        }
});

answered Dec 13, 2014 at 20:32

Amit Portnoy

6,4362 gold badges32 silver badges31 bronze badges

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

1 Comment

Besto Over a year ago

If no doc with {name: "fluffy"} in it exists, does {upsert: true} create it?; also, if I do {upsert: true, new: true}, can I do function(err, result) {} and get in result all of the documents that were created/updated?

John Scott Stensland · Accepted Answer · 2015-10-29 17:44:15Z

41

Deprecated see other solution below using $push $each

Your example is close, but you want $pushAll rather than $push to have each value added separately (rather than pushing another array onto the values array):

var Kitten = db.model('Kitten', kittySchema);
Kitten.update({name: 'fluffy'},{$pushAll: {values:[2,3]}},{upsert:true},function(err){
        if(err){
                console.log(err);
        }else{
                console.log("Successfully added");
        }
});

edited Oct 29, 2015 at 17:44

John Scott Stensland

28.5k12 gold badges100 silver badges113 bronze badges

answered Aug 15, 2012 at 3:37

Stennie

65.6k15 gold badges155 silver badges181 bronze badges

4 Comments

Stennie Over a year ago

NB: you may also want to look at $addToSet, which can be used to only add values to an array if they aren't there already.

Pranil Dasika Over a year ago

Thanks Stennie! That works. I missed this part in the documentation.

Tom Over a year ago

@Stennie this only works for individual elements, not for concatenating arrays.

super-qua Over a year ago

@Tom concatenating arrays can be done with $addToSet together with $each.

nanobar · Accepted Answer · 2018-01-16 22:58:30Z

5

Or use the $each modifier with $addToSet:

https://docs.mongodb.com/manual/reference/operator/update/addToSet/#each-modifier

// Existing tags array
{ _id: 2, item: "cable", tags: [ "electronics", "supplies" ] }

// Add "camera" and "accessories" to it
db.inventory.update(
   { _id: 2 },
   { $addToSet: { tags: { $each: [ "camera", "accessories" ] } } }
 )

answered Jan 16, 2018 at 22:58

nanobar

66.8k26 gold badges155 silver badges178 bronze badges

Comments

Bisakh Mondal · Accepted Answer · 2021-02-21 15:07:57Z

1

Currently, the updated doc doesn't support $pushAll. It seems to have been deprecated. Now the good choice is to use the combination of $push & $each

an example:

//User schema: {uid: String, transaction: [objects] }
const filter = {"uid": uid};
const update = {
        $push: {
            transactions: {$each: dataarr}
        }
    }
User.updateOne(filter, update, {upsert:true}, (err) => {
        if(err){
            console.log(err)
        }
    })

pass {upsert: true} at options to insert if the filter returns false.

answered Feb 21, 2021 at 15:07

Bisakh Mondal

631 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to push an array of objects into an array in mongoose with one call?

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related