node.js - 以后如何更改猫鼬模式的键？

Question

我有这样的架构

     const vocabularySchema = new mongoose.Schema({
      vocabulary: { type: String, required: true },
      defination: { type: String, required: true },
      exampleSentences: [{ type: String }],
      note: { type: String },
      timeStamp: { type: Date, default: Date.now },
      resource: { type: String },
      owner: { type: mongoose.Schema.Types.ObjectId, ref: "User" },
    });

查看“定义”键。拼写不正确。我想把它改回“定义”。但问题是有很多文件添加了“定义”。如何将它们改回“定义”？

更清楚地说，我在这些数据中添加了关键的“定义”。它们如下

    [
     {
      _id: new ObjectId("618fe4f6ee433e36f0392785"),
      vocabulary: 'destiny',
      defination: 'the events that will necessarily happen to a particular person or thing in the future.',
      exampleSentences: [ 'If something is our destiny, there is no way we can avoid it.' ],
      note: '',
      timeStamp: 2021-11-13T16:16:54.897Z,
      resource: '',
      owner: new ObjectId("6162e68db8d492f28b8e7870"),
      __v: 0
    }
    {
      _id: new ObjectId("618fe554ee433e36f0392795"),
      vocabulary: 'rumor',
      defination: 'a currently circulating story or report of uncertain or doubtful truth.',
      exampleSentences: [ 'You should never be bothered by rumor s.' ],
      note: '',
      timeStamp: 2021-11-13T16:18:28.523Z,
      resource: '',
      owner: new ObjectId("6162e68db8d492f28b8e7870"),
      __v: 0
    }
    ]

我想在这些现有文档中将键“定义”更改为“定义”。这是我迄今为止尝试过但没有奏效的方法。

    Vocabulary.find({}).then((voca) => {
      voca.forEach((v) => {
        v["definition"] = v["defination"];
        console.log(v);
      });
    });

请帮助我如何做到这一点。

标签： node.jsdatabasemongodbmongoosemongoose-schema

Answer 1

您可以使用$rename运算符。首先过滤所有具有defination字段的文档，然后为所有这些文档重命名该字段。

Vocabulary.update(
  { defination: { $exists: true } },
  { $rename: { "defination": "definition" } },
  { upsert: false, multi: true  }
);