node.js - 更新 Mongoose 对象数组中的多个对象

Question

我的架构如下:

const UserSchema = new mongoose.Schema({
    skills: [{
        _id: false,
        name: String,
        level: Number,
        exp: Number
    }]
});

示例文档如下:

{
    "_id": {
        "$oid": "5b0941419703f80a121c44df"
    },
    "skills": [
        {
            "name": "woodcutting",
            "exp": 1110,
            "level": 1
        },
        {
            "name": "smithing",
            "level": 0,
            "exp": 0
        },
        {
            "name": "reading",
            "level": 0,
            "exp": 0
        },
        {
            "name": "writing",
            "level": 0,
            "exp": 0
        }
    ]
}

所以我只需要在一个查询中更新木工和锻造的经验和水平，是否可能，如果可能，如何？或者我需要更改所有数组并用它的技能值设置(替换)吗？

Answer 1

您可以使用arrayFilters从 mongodb 3.6 开始

db.collection.update(
  { }, 
  { "$set": {
    "skills.$[skill1].exp": "your_value",
    "skills.$[skill2].level": "your_value",
    "skills.$[skill2].exp": "your_value",
    "skills.$[skill1].level": "your_value"
  }},
  { "arrayFilters": [{ "skill1.name": "woodcutting", "skill2.name": "smithing" }] }
)