我在更新 UserModel 子文档时遇到问题，该子文档是 (OfferModel)

const user = Schema({
  name: String,
  offers: [{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'Offer'
  }]
});

const offer = Schema({
  title: String,
  post: {
    type: mongoose.Schema.Types.ObjectId,
    ref: 'Post'
  },
  buyer: {
    deal: String,
    user: {
      type: mongoose.Schema.Types.ObjectId,
      ref: 'User'
    }
  },
  seller: {
    deal: String,
    user: {
      type: mongoose.Schema.Types.ObjectId,
      ref: 'User'
    }
  }
});

情况是这样的 我有一个用户在 1 个帖子上有 3 个优惠，但总共有 10 个优惠

Post A = 3 offers.
Post B = 7 offers.

然后我在帖子A上接受了一个报价，所以我查询数据库并将“买家”下的“交易”属性设置为“确定”，这没有问题。现在我需要将“拒绝”设置为 Post A 上的其他 2 个报价。 如果我使用 Javascript 方式，则有一个解决方案:

1. 获取帖子 ID
2. 在用户模型下填充报价，使用匹配运算符仅获取特定帖子上的报价以及尚未确认的报价(即 2 个报价)
3. 遍历它们并分配 user.offers.buyer.deal = "rejected"
4. 保存()

用这种方法没问题，但我想用 Mongoose 的方式来做，我只想知道如何用 Mongoose 的方式来做？

我还检查了 .update() 运算符，但我似乎无法使其正常工作，或者这不是我需要的东西。

关于如何仅使用 Mongoose 运算符更新这 2 个报价的任何输入？

谢谢

**更新

const user = await this.userRepo.findUser(req.user._id)
  .select('offers')
  .populate({
    path: 'offers',
    match: {
      post: req.body.postId,
      'buyer.feedback': 'none'
    }
  })
  .update({}, {
    '$set': {
      'offers.$.buyer.feedback': 'ok'
    }
  });

错误 CastError:转换为 ObjectId 失败，因为路径“offers”中的值“ok”

***更新 2 个示例文档 ****更新3前后

// John
{
  "_id": ObjectId("5abf3c2fb9709a31244ee2a8"),
  "name": "john",
  "offers": [
    ObjectId("5ad2aac1b0ef21131439223c"), // Offer that i accepted
    ObjectId("5ad2ab39b0ef21131439223d"), // Offer i should reject
    ObjectId("5ad2b9b2751c39321c4173e4"), // Offer i should reject
    ObjectId("5ad2d0846778d91eb0b109a8"),
    ObjectId("5ad2d136e50e903240cdb4b9"),
    ObjectId("5ad2d14ae50e903240cdb4ba"),
    ObjectId("5ad2d2acde95b51e205b26fc"),
    ObjectId("5ad9cbaec9c10314148adcd8"),
    ObjectId("5ad9ccf60c7f492940d4bd9d"),
    ObjectId("5ad9cd2e0c7f492940d4bd9e"),
  ],
  "post": [
    ObjectId("5abf4eb433063a3ebc8ba78f"), // Post A
    ObjectId("5abf4ec533063a3ebc8ba790"),
  ]
};

// Offer that i accepted
{
  "_id" : ObjectId("5ad2aac1b0ef21131439223c"),
    "buyer" : {
      "deal" : "ok",
      "feedback" : "none",
      "user" : ObjectId("5abf3c2fb9709a31244ee2a8")
  },
  "seller" : {
    "deal" : "none",
    "feedback" : "none",
    "user" : ObjectId("5abf3c2fb9709a31244ee8bf")
  },
  "post" : ObjectId("5abf4eb433063a3ebc8ba78f"),
}

// (BEFORE) Offer that i should reject
[{
  "_id" : ObjectId("5ad2ab39b0ef21131439223d"),
  "buyer" : {
    "deal" : "none",
    "feedback" : "none",
    "user" : ObjectId("5abf3c2fb9709a31244ee2a8")
  },
  "seller" : {
    "deal" : "none",
    "feedback" : "none",
    "user" : ObjectId("5abf3c2fb9709a31244ee8bd")
  },
  "post" : ObjectId("5abf4eb433063a3ebc8ba78f"),
},
{
  "_id": ObjectId("5ad2b9b2751c39321c4173e4"),
  "buyer": {
    "deal": "none",
    "feedback": "none",
    "user": ObjectId("5abf3c2fb9709a31244ee2a8")
    },
  "seller": {
    "deal": "none",
    "feedback": "none",
    "user": ObjectId("5abf3c2fb9709a31244ee8aa")
    },
  "post": ObjectId("5abf4eb433063a3ebc8ba78f"),
}]

// (AFTER)
[{
  "_id": ObjectId("5ad2ab39b0ef21131439223d"),
  "buyer": {
    "deal": "rejected",
    "feedback": "none",
    "user": ObjectId("5abf3c2fb9709a31244ee2a8")
  },
  "seller": {
    "deal": "none",
    "feedback": "none",
    "user": ObjectId("5abf3c2fb9709a31244ee8bd")
  },
  "post": ObjectId("5abf4eb433063a3ebc8ba78f"),
},
  {
    "_id": ObjectId("5ad2b9b2751c39321c4173e4"),
    "buyer": {
      "deal": "rejected",
      "feedback": "none",
      "user": ObjectId("5abf3c2fb9709a31244ee2a8")
    },
    "seller": {
      "deal": "none",
      "feedback": "none",
      "user": ObjectId("5abf3c2fb9709a31244ee8aa")
    },
    "post": ObjectId("5abf4eb433063a3ebc8ba78f"),
  }]

最佳答案

你应该试试这样的东西

Offers.update({
  "buyer.feedback": "none",  
  post: req.body.postId      //query
}, {
  '$set': {
    'buyer.feedback': 'ok'    // update operation
  }
})

关于node.js - Mongoose 用条件填充子文档并更新它们，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/50422098/