猫鼬expressJS更新嵌套数组中的单个字段

debugcn 发表于 Dev

奈杰尔

我正在尝试使用Mongoose和expressJS作为后端在Web应用程序中构建编辑功能，我想更新lessonLog中的单个字段，该字段是具有单个objectId的lessonLog数组，我使用以下代码尝试了此操作，但未按预期工作，请指教。先感谢您！

{
  Object _id : 601e7877cc4bc5047860831b ObjectId,
  date : 2021-02-05T16:00:00.000+00:00 Date,
  tempoMin : 71,
  tempoMax : 206,
  title : Khulau,
  intonation : test,
  phrasing : test,
  articulation : technique : test,
  notes : test ,
}

const studentsSchema = new mongoose.Schema({
  name: { type: String, require: true },
  email: { type: String, require: true },
  contact: { type: String, require: true },
  activities: {
    exam: { type: String, require: true },
    recording: { type: String, require: true },
    theory: { type: String, require: true },
    competition: { type: String, require: true },
    orchestra: { type: String, require: true },
  },
  teacher: { type: mongoose.Types.ObjectId, require: true, ref: "teachers" },
  repertoire: [{ type: String, require: true }],
  **lessonLog: [
    {
      date: { type: Date, require: true },
      tempoMin: { type: String, require: true },
      tempoMax: { type: String, require: true },
      title: { type: String, require: true },
      scales: { type: String, require: true },
      intonation: { type: String, require: true },
      phrasing: { type: String, require: true },
      articulation: { type: String, require: true },
      technique: { type: String, require: true },
      notes: { type: String, require: true },
    },**
  ],
});

这是查询：

const editLessonLog = async (req, res, next) => {
  try {
    await Students.findOneAndUpdate(
      {
        lessonLog: { _id: req.body.lessonLogId },
      },
      {
        $set: {
          lessonLog: {
            date: req.body.lessonDate,
            tempoMin: req.body.tempo[0],
            tempoMax: req.body.tempo[1],
            title: req.body.title,
            intonation: req.body.intonation,
            phrasing: req.body.phrasing,
            articulation: req.body.articulation,
            technique: req.body.technique,
            notes: req.body.notes,
          },
        },
      }
    );
    // console.log(student);
  } catch (err) {
    const error = new HttpError(
      "Cannot delete lesson log, please try again.",
      500
    );
    return next(error);
  }

穆罕默德·亚瑟·艾哈迈迪

您应该$根据文档使用

位置$运算符可标识要更新的数组元素，而无需显式指定数组中元素的位置

所以尝试一下

const editLessonLog = async (req, res, next) => {
  try {
    await Students.findOneAndUpdate(
      {
        "lessonLog._id": req.body.lessonLogId
      },
      {
        $set: {
          "lessonLog.$": {
            date: req.body.lessonDate,
            tempoMin: req.body.tempo[0],
            tempoMax: req.body.tempo[1],
            title: req.body.title,
            intonation: req.body.intonation,
            phrasing: req.body.phrasing,
            articulation: req.body.articulation,
            technique: req.body.technique,
            notes: req.body.notes,
          },
        },
      }
    );
    // console.log(student);
  } catch (err) {
    const error = new HttpError(
      "Cannot delete lesson log, please try again.",
      500
    );
    return next(error);
  }