updateone on sequelize node code example
Example 1: create or update in sequelize
async function updateOrCreate (model, where, newItem) {
const foundItem = await model.findOne({where});
if (!foundItem) {
const item = await model.create(newItem)
return {item, created: true};
}
const item = await model.update(newItem, {where});
return {item, created: false};
}
Example 2: sequelize update
var Book = db.define(‘books’, {
title: {
type: Sequelize.STRING
},
pages: {
type: Sequelize.INTEGER
}
})
Book.update(
{title: req.body.title},
{where: req.params.bookId}
)