javascript - UpdateOne mongodb 而不更改其他对象

Question

看下面的例子

我只想更新 ExpensesHouse 中的一条记录，因此我构建了以下代码

router.post("/editExpense/:id", ensureAuthenticated, (req, res) => {
  var id = mongoose.Types.ObjectId(req.params.id);
  House.updateOne(
    { "expensesHouse._id": id },
    {
      $set: {
        expensesHouse: {
          _id: id,
          expenseType: req.body.expenseType,
          description: req.body.description,
          price: req.body.price,
          status: req.body.status,
          userID: req.user.id
        }
      }
    }
  ).then(house => {
    req.flash("success_msg", "Expenses Updated");
    res.redirect("/houses/dashboard");
  });
});

它工作正常并且可以更新记录，但由于我有 2 个或更多对象，所以其他对象都消失了。因此，当我更新时，假设 1: 对象，费用类型:水，然后我将费用类型更改为其他，0: 对象就消失了，我只需要使用 _id: id 更新寄存器

下面可以看到UpdateOne之后的结果

Answer 1

试试这个:

router.post("/editExpense/:houseId/:id", ensureAuthenticated, (req, res) => {
  var id = mongoose.Types.ObjectId(req.params.id);
  var houseId : mongoose.Types.ObjectId(req.params.houseId);
  House.updateOne(
    { "_id": houseID, "expensesHouse._id": id },
    {
      $set: {
          expensesHouse.$.expenseType: req.body.expenseType,
          expensesHouse.$.description: req.body.description,
          expensesHouse.$.price: req.body.price,
          expensesHouse.$.status: req.body.status,
          expensesHouse.$.userID: req.user.id
        }
      }
    }
  ).then(house => {
    req.flash("success_msg", "Expenses Updated");
    res.redirect("/houses/dashboard");
  });
});