Create multiple rows in table from array?

Question

Is possible to add multiple rows at once from array with sequelize.js? This is my code:

  var user = User.build({
    email: req.body.email,
    password: req.body.password,
    userlevel: '3',
  });

  User
  .find({ where: { email: req.body.email } })
  .then(function(existingUser){

    if (existingUser) {
      return res.redirect('/staff');
    }

    user
    .save()
    .complete(function(err){
      if (err) return next(err);
      res.redirect('/staff');
    });
  }).catch(function(err){
    return next(err);
  });

Thanks for any advise!

James Gentes · Accepted Answer · 2018-11-12 23:35:30Z

68

https://sequelize.readthedocs.io/en/v3/docs/instances/#working-in-bulk-creating-updating-and-destroying-multiple-rows-at-once

User.bulkCreate([{ /*  record one */ }, { /* record two */ }.. ])

edited Nov 12, 2018 at 23:35

James Gentes

8,22610 gold badges48 silver badges66 bronze badges

answered Nov 19, 2014 at 11:35

Jan Aagaard Meier

28.9k8 gold badges99 silver badges68 bronze badges

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

2 Comments

Mir-Ismaili Over a year ago

Thanks. The link is old. A newer one is sequelize.org/master/class/lib/…

Antti A Over a year ago

Manual has been updated. Here is a link to new version: sequelize.org/v5/manual/…

Ujjwal Raijada · Accepted Answer · 2022-02-16 16:24:20Z

0

There has been an update in the document. check this link

https://sequelize.org/v5/manual/instances.html#working-in-bulk--creating--updating-and-destroying-multiple-rows-at-once-

User.bulkCreate([
  { username: 'barfooz', isAdmin: true },
  { username: 'foo', isAdmin: true },
  { username: 'bar', isAdmin: false }
])

answered Feb 16, 2022 at 16:24

Ujjwal Raijada

97510 silver badges23 bronze badges

Collectives™ on Stack Overflow

Create multiple rows in table from array?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related