在mongoose（updateOne-$pull）不工作的情况下删除MongoDB中数组中的嵌入文档

Question

我有一个应用程序与MongoDB（猫鼬）在NodeJs。

在一个集合中，我有这种类型的文档，按周定义：

{
"_id":
{"$oid":"617f3f51f883fab2de3e7260"},
"endDate":{"$date":"2021-11-07T23:59:59.000Z"},
"startDate":{"$date":"2021-11-01T00:00:00.000Z"},
"wastes":[
{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":780},
{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":1140},
{"timestamp":{"$date":"2021-11-01T03:00:58.000Z"},"duration":540},
{"timestamp":{"$date":"2021-11-01T07:00:58.000Z"},"duration":540},
{"timestamp":{"$date":"2021-11-01T09:00:58.000Z"},"duration":960},
{"timestamp":{"$date":"2021-11-01T09:00:58.000Z"},"duration":1140},
{"timestamp":{"$date":"2021-11-01T15:00:58.000Z"},"duration":180},
{"timestamp":{"$date":"2021-11-01T15:00:58.000Z"},"duration":540}
...
]}

我有一个查找具有相同时间戳的废物的函数，例如“2021-11-01T01:00:58.000Z”，它给出了此时间戳的最长持续时间。

我想删除所有条目与该时间戳：

{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":780},
{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":1140}

并只插入持续时间最高的一个：

{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":1140}

我正在使用带有$pull和$push的updateOne，但它不起作用。

let query = {
        startDate: new Date(startDayWeek),
      };

let deleteProjection = {
        $pull: {
          wastes: { timestamp: new Date(timestampDeleteInsertion) },
        },
      };

let insertProjection = {
        $push: { wastes: insertRegisterForTimestamp },
      };

//Delete
await coleccion.updateOne(query, deleteProjection);

//Insertion
await coleccion.updateOne(query, insertProjection);

我还尝试了{upsert:false}，{multi:true}。

如果我在MongoDB Compass shell中使用相同的命令，那么它可以正常工作：

//Delete
db.coleccion.updateOne({startDate: ISODate('2021-11-01T00:00:00')}, {$pull: {'wastes': {timestamp: ISODate('2021-11-01T01:00:58.000Z')}}})

//Insertion
db.coleccion.updateOne({startDate: ISODate('2021-11-01T00:00:00')}, {$push: {'wastes': {'timestamp':ISODate('2021-11-01T01:00:58.000Z'), 'duration': 1140}}})

Answer 1

通过使用聚合管道进行更新，可以实现预期的行为

聚合将包括3个步骤：

1. 使用$reduce找出最大持续时间；将结果存储到字段中

db.collection.update({},
[
  {
    $addFields: {
      maxDuration: {
        "$reduce": {
          "input": "$wastes",
          "initialValue": null,
          "in": {
            "$cond": {
              "if": {
                $and: [
                  {
                    $eq: [
                      "$$this.timestamp",
                      {
                        "$date": "2021-11-01T01:00:58.000Z"
                      }
                    ]
                  },
                  {
                    $gt: [
                      "$$this.duration",
                      "$$value"
                    ]
                  }
                ]
              },
              "then": "$$this.duration",
              "else": "$$value"
            }
          }
        }
      }
    }
  },
  {
    $set: {
      wastes: {
        $filter: {
          input: "$wastes",
          as: "w",
          cond: {
            $or: [
              {
                $ne: [
                  "$$w.timestamp",
                  {
                    "$date": "2021-11-01T01:00:58.000Z"
                  }
                ]
              },
              {
                $eq: [
                  "$$w.duration",
                  "$maxDuration"
                ]
              }
            ]
          }
        }
      }
    }
  },
  {
    "$unset": "maxDuration"
  }
])

这是蒙哥游乐场供你参考。