node.js - 为什么 mongodb 返回成功并且没有将值发布到 mongodb 数组中

Question

我正在使用 $push 将数组值发送到 mongodb 中的现有表，res.json 返回此值

// @route   POST api/addshipment/:unitNo
// @desc    Add shipment for each customer
// @access  Private
router.post(
  '/addshipment/:user_id',
  passport.authenticate('jwt', { session: false }),
  (req, res) => {

    Shipments.findOne({_id: req.params.user_id}, {paymentStatus: "incomplete"})
      .then(shipments => {
        if(!shipments){
          const errshipments = 'This user doesnot have an existing warehouse';
           return res.status(404).json(errshipments);
        }else{
          const newPackages = {
          category: req.body.category,
          quantity: req.body.quantity,
          description: req.body.description,
          trackingno: 1214112,
          length: req.body.length,
          height: req.body.height,
          width: req.body.width,
          weight :  12  
        };
          Shipments.updateOne({_id: req.params.user_id}, {paymentStatus: "incomplete"}, { "$push": { "packages": newPackages}})
          .then(shipments=> res.json(shipments));
        }
      });
    });

这是我得到的 res.json

{
  "n": 1,
  "nModified": 0,
  "opTime": {
    "ts": "6739809611714396360",
    "t": 3
  },
  "electionId": "7fffffff0000000000000003",
  "ok": 1,
  "operationTime": "6739809611714396360",
  "$clusterTime": {
    "clusterTime": "6739809611714396360",
    "signature": {
      "hash": "Olz9Fehw4JRj/a4rrLOhCxZIO7E=",
      "keyId": "6719390010044317697"
    }
  }
}

而不是这样的

{
  "paymentStatus": "incomplete",
  "_id": "5d85a4fc8e7efe74e4dee830",
  "warehouseNo": "0001",
  "packages": [{
     "quantity": 12,
     "category" : "Hazardous",
            }],
  "date": "2019-09-23T10:46:23.065Z",
  "__v": 0
}

Answer 1

您的查找和更新查询似乎都不正确。

应该是这样的:

查找查询

Shipments.findOne({_id: req.params.user_id,paymentStatus: "incomplete"})

更新查询

Shipments.updateOne({
    _id: req.params.user_id, 
    paymentStatus: "incomplete"
}, { 
    "$push": { 
        "packages": newPackages
    }
})
.then(shipments=> res.json(shipments));

如果您希望在查询末尾更新文档，则需要将 {new : true} 作为第三个参数传递给更新查询

Shipments.updateOne({
    _id: req.params.user_id, 
    paymentStatus: "incomplete"
}, { 
    "$push": { 
        "packages": newPackages
    }
},{new:true})
.then(shipments=> res.json(shipments));