Mongoose querying the array... changing the elements of the array

Question

I am trying to remove all the elements from the array in the MongoDB database, then I insert all the new array elements.

My Model is:

 const mongoose = require('mongoose');
var schema = new mongoose.Schema({
    email : {
        type : String
    },
    password : {
        type : String
    },
    stocks : {
        type : [String]
    }
}, {versionKey:false}, {_id: false});
module.exports =  final = mongoose.model('users', schema);

My stocks array will then have some values. I am trying to remove those values using the following command: I read at somewhere in Stack Overflow that to empty your array you can do many things but a set is the fastest way to do this. Please let me know if you know any other way which is better than this.

final
  .findOneAndUpdate({email:"[email protected]"}, {$set:{stocks:[]}})
  .then(()=>console.log("Data removed."))
  .catch(err=>console.log(err));

Once data is removed it means the array will get emptied. Then I assign the whole set of the new array from my local variable like this:

const newData = {
  stocks : ["abcd", "wxyz"]
};

Now I am trying to assign this new array to my database using this command:

final
  .findOneAndUpdate({email:"[email protected]"}, {$set:{stocks:newData.stocks}});

It is emptying the array successfully, but when I am assigning new array it is not working and shows an empty array. Can anyone assist me with this, please?

This does not reproduce, aside from a possible misuse of final where you meant Pref as the model. Basically appears to be a typo with no other cause. — Neil Lunn
– Neil Lunn, Commented Mar 19, 2019 at 8:43
Please check edited question... Actually it's typo but there must be something other issue... — Yash Choksi
– Yash Choksi, Commented Mar 19, 2019 at 8:44
Argh! You're looking at the old document. Duplicate of Mongoose: findOneAndUpdate doesn't return updated document. Missing { new: true } — Neil Lunn
– Neil Lunn, Commented Mar 19, 2019 at 8:45

Simone Morettini · Accepted Answer · 2019-03-19 08:47:46Z

1

Try with

final.findOneAndUpdate({email:"[email protected]"}, {$set:{stocks:newData.stocks}}, {new: true})
    .then((doc)=>console.log(doc))
    .catch(err=>console.log(err));

If you don't use a callback the query is not executed.

The query executes if callback is passed else a Query object is returned. Mongoose documentation

edited Mar 19, 2019 at 8:47

answered Mar 19, 2019 at 8:40

Simone Morettini

3912 silver badges13 bronze badges

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

1 Comment

Simone Morettini Over a year ago

I edited the answer. The problem is that you miss the callback

Collectives™ on Stack Overflow

Mongoose querying the array... changing the elements of the array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related