Mongoose add multiple object to array if not exist based

Question

How to add multiple objects to array based on key?

I need to add multiple objects in one query, check if each object key doesn't exist or duplicate, else add object. (label can be duplicate)

Schema

new Schema({
      additional: [
        {
          key: { type: String, required: true, unique: true },
          label: { type: String, required: true }
        }
      ]
})

request payload:

[ {key: "city", label: "CITY"}, {key: "gender", label: "GENDER"}
, {key: "city" ,label: "CITY1"}, {key: "city2", label: "CITY"}]

Expected results:

[
 {key: "city", label: "CITY"},
 {key: "gender", label: "GENDER"},
 {key: "city2", label: "CITY"}
]

I tried to find solutions but couldn't find any.

Ashh · Accepted Answer · 2018-08-13 17:26:54Z

3

You can try using bulkWrite operation in mongodb

Suppose you have following payload to update

const payload = [
  { key: "city", label: "CITY" }, { key: "gender", label: "GENDER" },
  { key: "city", label: "CITY1" }, { key: "city2", label: "CITY" }
]

Query to update documents in bulk

Model.bulkWrite(
  payload.map((data) => 
    ({
      updateOne: {
        filter: { '_id': 'xxxx', 'additional.key' : { $ne: data.key } },
        update: { $push: { additional: data } }
      }
    })
  )
})

Which will send a request in bulk to update like this

bulkWrite([
  { updateOne: { filter: { '_id': 'xxxx', 'additional.key' : { $ne: data.key } }, update: { $push: { additional: data } } } },
  { updateOne: { filter: { '_id': 'xxxx', 'additional.key' : { $ne: data.key } }, update: { $push: { additional: data } } } }
])

edited Aug 13, 2018 at 17:26

answered Aug 12, 2018 at 11:25

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Liam Over a year ago

doesn't work for me. it's add empty doc. did you test that?

Ashh Over a year ago

stackoverflow.com/questions/51549326/…

Liam Over a year ago

it works fine, just have to add _id: 'xxxxx' of specific doc

nimrod serok · Accepted Answer · 2022-06-05 17:54:43Z

One way to do it since mongoDB version 4.4 is using update with aggregation pipeline with a $merge step:

$addFields with data to add and create a new keys field that contains the existing keys.
$filter the data to include only items with keys that are not in the original array called 'additional'.
$concatArrays: 'additional' and the filtered data array.

db.collection.aggregate({_id: 'xxxx'}, [
  {
    $addFields: {
      data: [{key: "city", label: "CITY"}, {key: "city2", label: "CITY"}],
      keys: "$additional.key"
    }
  },
  {
    $set: {
      data: {
        $filter: {
          input: "$data",
          as: "item",
          cond: {$not: {$in: ["$$item.key", "$keys"]}}
        }
      }
    }
  },
  {
    $set: {
      additional: {$concatArrays: ["$additional", "$data"]},
      data: "$$REMOVE", keys: "$$REMOVE"
    }
  }
])

Playground example

Collectives™ on Stack Overflow

Mongoose add multiple object to array if not exist based

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related