How to save an array of objects to mongoose DB with only one call?

Question

Is there any way to save an array of JSON object to a mongodb with only one call? something like:

schemeObject.save(array_of_json_object, callback);

I'm using mongoosejs

@IcyFlame Your linked post is technically a duplicate of this one. — Dan Mandle, Sep 08 '16 at 21:38
@DanMandle right! I didn't notice the dates. Thanks for pointing out. — IcyFlame, Sep 10 '16 at 06:15
You can also try this: http://stackoverflow.com/questions/16726330/mongoose-mongodb-batch-insert — IcyFlame, Sep 10 '16 at 06:15

score 32 · Answer 1 · answered Apr 04 '14 at 22:50

32

There is a way to batch insert with MongooseJS. I'm not sure if it's a new feature since this question was asked/answered, but I figured if someone were to come here from a search, they should know the way to do it.

var array = [{ type: 'jelly bean' }, { type: 'snickers' }];
Candy.create(array, function (err, jellybean, snickers) {
  if (err) // ...
});

Here are the docs: http://mongoosejs.com/docs/api.html#model_Model.create

answered Apr 04 '14 at 22:50

Dan Mandle

5,608
3
23
26

4

That should work if we want to create new docs. How about update a array or docs that returned from a query? – jAckOdE Apr 10 '14 at 06:41
For that, I think you'd have to do a find() then a forEach() on the result, update the values and do a save() for each of them. But I'm pretty new to Mongoose myself. – Dan Mandle Apr 11 '14 at 14:23

score 10 · Accepted Answer · answered Apr 03 '12 at 05:35

10

I do not think its possible with mongooosejs. You can however use BATCH insert of mongodb ,which is supported natively.

Helpful links:

http://www.mongodb.org/display/DOCS/Inserting#Inserting-Bulkinserts

https://groups.google.com/forum/#!msg/mongoose-orm/IkPmvcd0kds/bZuYCN_orckJ

answered Apr 03 '12 at 05:35

DhruvPathak

42,059
16
116
175

3

the answer is found in the second link. Thanks – jAckOdE Apr 03 '12 at 10:49

score 2 · Answer 3 · answered Feb 18 '18 at 23:07

2

This works with mongoose as well

Laptop.insertMany(laptopData, function (err, laptop) {
  if (err) {
    console.log(err);
  };
  console.log(laptop);
});

answered Feb 18 '18 at 23:07

Admir

2,876
1
19
19

score 0 · Answer 4 · answered Aug 31 '17 at 07:16

Another workaround that I've used. If you are using mongoose with promises, you can do this using Q.

You can start using Q as the default promise for mongoose using the below code:

const mongoose = require('mongoose');
mongoose.Promise = require('q').Promise;

Then you can save an array of documents like below. Let's say we are storing an array of User models, which I've shown in users variable.

Q
  .all(users.map(curr => curr.save()))
  .then((results) => { //do something })
  .catch((err) => { //handle error })

.save() will return a q promise and using array map function, we'll create a promise array using the user models array.

score 0 · Answer 5 · answered Sep 12 '21 at 03:11

0

I got the solution instead of using

new model_name({
your data
})

use this

model_name.create({your data}).then(res).catch(err)

// simple promise things

answered Sep 12 '21 at 03:11

anish jain

11
1
2

score 0 · Answer 6 · answered Apr 03 '12 at 07:00

0

How about something like this? I know it loops through the entire array.. dont ask me about the Big O for this.. probably not the best way to insert but works for just an initial data dump of some sort..

var arr = // array of objects;
    res = [];

arr.forEach(function (item) {
    item.save(function (err) {
        res.push(err);
        if (res.length === arr.length)
        {
            // Done
        }
    });
});

answered Apr 03 '12 at 07:00

Anand Nandakumar

122
2

that woudnt be a batch insert if its one by one! – Pinser Apr 08 '15 at 06:33

How to save an array of objects to mongoose DB with only one call?

6 Answers6

Linked