nodejs Sequelize bulkCreate() model error validation not working

Question

I have multiple data insert operations in my application

and when i use bulkCreate then it works for me

but I have an issue that when some required field like name which is not null in the database and i call create or save method for an individual method without name then it gives the error: required validation error

but when i do the same in bulkCreate then it creates with null value without throwing an error

following is the code of bulkCreate which is not working

models.testModel.bulkCreate(postObj.evUserFavouriteLocations,{updateOnDuplicate: true}).then(function (result) {
    console.log("postObj.");
}).catch(Sequelize.ValidationError, function (err) {
console.log(' in sequierererror', err);
}).catch(function (err) {
console.log("err::",err);
});

kkkkkkk · Accepted Answer · 2018-04-25 09:43:19Z

6

For bulkCreate, validation is turn off by default. You need to pass validate: true in order for validation to work.

Read the document here: http://docs.sequelizejs.com/class/lib/model.js~Model.html#static-method-bulkCreate

answered Apr 25, 2018 at 9:43

kkkkkkk

7,7602 gold badges22 silver badges32 bronze badges

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

Comments

hansss · Accepted Answer · 2019-08-06 08:01:06Z

2

I fixed it by setting ignoreDuplicates option to true. E.g. Model.bulkCreate(dataArray, {ignoreDuplicates: true})

answered Aug 6, 2019 at 8:01

hansss

5217 silver badges7 bronze badges

1 Comment

Falcon Stakepool Over a year ago

This worked for me, thank you.

Oliver Nybo · Accepted Answer · 2024-10-18 11:32:06Z

0

Pass validate true in your bulkCreate method

const createEventAvailability = await EventAvailability.bulkCreate(
    eventAvailability,
    { validate: true }
);

edited Oct 18, 2024 at 11:32

Oliver Nybo

5601 gold badge8 silver badges25 bronze badges

answered Oct 14, 2024 at 21:28

seun

31 silver badge2 bronze badges

Collectives™ on Stack Overflow

nodejs Sequelize bulkCreate() model error validation not working

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related