javascript - 如何在猫鼬中更新所选文档中数组的所有嵌套文档？

Question

在某种情况下，我需要更新嵌套在 Mongoose 模型中的数组中的所有文档的字段。

我将上传图像的新嵌套文档添加到用户集合中，我需要将所有先前文档的“is_available”设置为假，并且只有新插入文档的“is_available”字段为真。

我搜索并发现的只是更新具有特定 id 或过滤器的嵌套文档。但我没有找到一种方法来更新模型中数组的所有嵌套文档的特定字段。

我的模型：

var mongoose = require("mongoose");
var Schema = mongoose.Schema;

var UsersSchema = new Schema({
  name: { type: String, default: "" },
  lastname: { type: String, default: "" },
  images: [{
    dir: { type: String },
    is_available: { type: Boolean }
  }]
});

var Users = mongoose.model("Users", UsersSchema, "users");
module.exports = Users;

实际结果：

{ 
    "_id" : ObjectId("5ce950aa4sw435ty503ab83b"), 
    "name" : "Sina", 
    "image" : [
        {
            "_id" : ObjectId("5cf4dd3da6b4gb6bcf9c6dc1"), 
            "dir" : "profiledirectory/804eafeaf8acc40a3d6.jpg", 
            "is_available" : true
        }, 
        {
            "_id" : ObjectId("5cf4fffs2419316bddffgg82"), 
            "dir" : "profiledirectory/d85b01ac40fa6b1a7c1.jpg", 
            "is_available" : true
        }, 
        {
            "_id" : ObjectId("5cf4ff334fhd316bef2fdt40"), 
            "dir" : "profiledirectory/512d9d19da7a4322b37.jpg", 
            "is_available" : true
        }
    ]
}

预期结果：

{ 
    "_id" : ObjectId("5ce950aa4sw435ty503ab83b"), 
    "name" : "Sina", 
    "image" : [
        {
            "_id" : ObjectId("5cf4dd3da6b4gb6bcf9c6dc1"), 
            "dir" : "profiledirectory/804eafeaf8acc40a3d6.jpg", 
            "is_available" : false
        }, 
        {
            "_id" : ObjectId("5cf4fffs2419316bddffgg82"), 
            "dir" : "profiledirectory/d85b01ac40fa6b1a7c1.jpg", 
            "is_available" : false
        }, 
        {
            "_id" : ObjectId("5cf4ff334fhd316bef2fdt40"), 
            "dir" : "profiledirectory/512d9d19da7a4322b37.jpg", 
            "is_available" : true
        }
    ]
}

Code Snippet:

let updateQuery = {
  $set: { 'image.$.is_available': false },
  $push: {
    image: [
      {
        dir: "profiledirectory/558bb6938ecd54bde556af122a4.jpg",
        is_available: true
      }
    ]
  }
}


let findQuery = { _id: req.body.user_id }

Users.findOneAndUpdate(findQuery,
  updateQuery, function (err, doc) {
    if (err) {
      res.send(err.message)
    } else {
      res.send('successful')
    }
  })

标签： javascriptnode.jsmongoose

Answer 1

上传文件后，您必须找到用户

  // after upload image 

  User.findOne({_id:req.user._id}).lean().exec((err,user)=>{
        if(!err && user){
              // setting all previous images to false 
              user.image.forEach(image=>{
                    image.is_available=false;
              });
              // now pushing new uploded item to image array
        let newImage={"dir" : "path of uploaded item here"  , "is_available" : true};

              user.image.push(newImage);
              user.save((err,updated)=>{
                   if(!err && updated){ 
                     return res.status(200).json({status:"success",message:"User updated"});
                   }
              });
        }
  });