CODEWITHSUNDEEP
javascriptnode.jsmongodbmongoose
Anoop
Anoop

Reputation: 5720

Mongoose create a document if not found with specified fields, if found update an array in the document

I am using mongoose and I am facing a problem of creating a document if it does not exist, and if it exists, I want to update an array in the document.

For example, if I have 

var courseSchema = new mongoose.Schema({
    code : { type: String },
    name : { type: String },
    dept : { type: String },
    instructors : [{ type : mongoose.Schema.ObjectId, ref: 'User' }],
});

var Course = mongoose.model('Course', courseSchema);

...
...
// This code should check if a course exists with a specified 'code' and 
// 'name' and , if it exist, I want to add req.body.instructor_id to
// instructor array in that document, else I want to create a document with
// the specified course, name(and dept) and with req.body.instructor_id as the only element in
// the instructors array

// So far I have this, but it is clearly wrong.


Course.findOneAndUpdate(
    {code: req.body.code, name: req.body.name},
    {$push: {instructors: req.user._id}},
    {upsert: true},
    function (err, course) {
        if (err)
            console.log("error " + err);
        else {
            console.log(JSON.stringify(course, null, '\t'));
        }
    }
);

Upvotes: 1

Views: 2035

Answers (1)

niba
niba

Reputation: 2911

The second parameter should be the whole object, not only instructors. For example:

function findOneAndUpdateCourse(req, callback){
    Course.findOneAndUpdate(
        {code: req.body.code, name: req.body.name},
        { 
          $setOnInsert: { code: req.body.code},
          $setOnInsert: { name: req.body.name},
          $push: {instructors: req.user._id}}
        },
        {upsert: true},
        function (err, course) {
            if (err)
                console.log("error " + err);
            else {
                console.log(JSON.stringify(course, null, '\t'));
            }
        }
    );
}

Upvotes: 1

Related Questions