javascript - Mongodb findOneAndUpdate 函数正在插入新文档

Question

每当我进行更新 api 调用时，我只需要更新 serviceActiveFlag 状态。更新 api 调用后，我可以看到创建了一个包含空车辆数组的新文档，如下所示。

_id:59c76073c11d3929148f500f
vehicle:Array
_v:0

id 字段将在每次 put api 调用时覆盖。

有人可以帮我解决这个问题吗？

架构

var localTransportSchema = new Schema({

        name: { type: String, required: false, trim: true },
        contact: {
            addressLine1: { type: String, required: false },        
            serviceActiveFlag: { type: String, required: false, enum: ['Y', 'N'] },
    }, 
    vehicle: [{
        vehicleType:{ type: String, required: false, enum: ['sedan', 'hatchback', 'suv', 'mpv', 'luxury'] },        
    }]
});
module.exports.accomodationModel = mongoose.model(collection, localTransportSchema);

Controller

var updates = {
            $set: {
                "contact.addressLine1": req.body['addressLine1'],                
                "contact.serviceActiveFlag": req.body['serviceActiveFlag']
            }
    };

    transportModel.findOneAndUpdate({ "name": req.body['providerName']},
        updates, { returnOriginal: false, upsert: false }, function (err, doc) {
            if (err) {
                logger.error("Error while updating record : - " + err.message);
                return res.status(409).json({
                    "Message": "Error while updating transport details for provider " + req.body['providerName'] + " in transport details table"
                });
            } else if (doc === null) {
                logger.error("Error while updating record in transport details : - unable to update database");
                return res.status(409).json({
                    "Message": "Error while updating transport details for provider " + req.body['providerName'] + " due to " + err.message
                });
            }
        });

Answer 1

mongoose 的

dbModel.findOneAndUpdate() 仅在您的过滤器查询(where claus)未能找到现有文档时插入新文档，即您的集合中不存在匹配的文档。所以 mongoose 会将新文档插入到集合中。这类似于 update()

的 upsert:true

引用:Official docs about findOneAndUpdate