update and create in sequelize node js code example
Example 1: sequelize update sql
const Tokens = db.define('tokens', {
token: {
type: sequelize.STRING
}
});
Tokens.update(
{ token: 'new token' },
{ where: {id: idVar} }
).then(tokens => {
console.log(tokens);
}).catch(err => console.log('error: ' + err));
Example 2: 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};
}