Question 280912 in Mongodb Question posted in
The official documentation can be found here.

How to create multiple documents at once in mongodb using mongoose in nodejs. Even If some fails rest should be inserted and output should be summary

I want to insert/create multiple documents in mongodb using mongoose in nodejs.
Now even if some of the inserts fail may be due to duplicate key the others should be inserted and finally I should have a output which shows inserted and non inserted data array.

    example input document:[
{_id: 11, name:'abc'},
{_id: 22, name:'abc'},
{_id: 11, name:'qwe'},
{_id: 33, name:'xyz'}
]

In this the third data is having a duplicate _id and hence will be a error [id dup key: { _id: "11" }] and the operation will stop with error.
But I want that it should not stop but insert other correct data

expected output is insert: [
    {_id: 11, name:'abc'},
    {_id: 22, name:'abc'},
    {_id_ dup key: { _id: "11" }},
    {_id: 33, name:'xyz'}
    ]

I have tried both
mongoose.model(student).create(_req.body)
mongoose.model(student).insertMany(_req.body)

But both ways failed and throws error. Works correct if all passed data to be created is correct.
Is there any additional property needs to be passed to achieve the same because in official document of mongoose its says it can be as far as i can understand. Also tried passing some options but failed.
https://mongoosejs.com/docs/api/model.html#Model.create()
https://mongoosejs.com/docs/api/model.html#Model.insertMany()

InsertMany API

create API

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Output

    using insertMany(_req.body,{ordered: false,writeConcern:{}})

    with this options does the work but throws an error and then in error we can get the output summary.

    Though this serves my purpose but If anyone knows any better approach, can surely post your answer.


  2. 0

    hope this one will help you

    const documentsToInsert = [
  {_id: 11, name:'abc'},
  {_id: 22, name:'abc'},
  {_id: 11, name:'qwe'},
  {_id: 33, name:'xyz'}
];

YourModel.insertMany(documentsToInsert, (error, insertedDocuments) => {
  if (error) {
    console.error('Error:', error);
  } else {
    console.log('Successfully inserted documents:', insertedDocuments);

    const successfulInserts = insertedDocuments.filter(doc => doc instanceof YourModel);
    const failedInserts = insertedDocuments.filter(doc => !(doc instanceof YourModel));

    console.log('Successfully inserted count:', successfulInserts.length);
    console.log('Failed insert count:', failedInserts.length);
  }
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search