xxxxxxxxxx
const result = await Model.bulkCreate([
{id: 1, name: 'name1', value: 'value1'},
{id: 2, name: 'name2', value: 'value2'},
{ name: 'name3', value: 'value3'}
], {
updateOnDuplicate: ['name', 'value'],
individualHooks: true
});
xxxxxxxxxx
var data = [{
'cat_name':'fashion'
},
{
'cat_name':'food'
}
];
orm.models.category.bulkCreate(data,{individualHooks: true})
.then(function(response){
res.json(response);
})
.catch(function(error){
res.json(error);
});
xxxxxxxxxx
const { Model } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
host: 'localhost',
dialect: 'mysql',
});
class User extends Model {}
User.init({
name: DataTypes.STRING,
age: DataTypes.INTEGER
}, { sequelize, modelName: 'user' });
// Assuming you have already defined the User model
// Deleting multiple records matching a condition
User.destroy({
where: {
age: {
[Op.lt]: 18
}
}
}).then(() => {
console.log('Successfully deleted');
}).catch((error) => {
console.error('Error occurred while deleting:', error);
});