Sequelize 的加减赋值运算符 [英] Addition and Subtraction Assignment Operator With Sequelize
本文介绍了Sequelize 的加减赋值运算符的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想通过在 Sequelize 上做一个简单的添加来进行更新.
I would like to do an update by doing a simple addition on Sequelize.
表:
id || data
1 || 10
样本:
db.table.update({ data : 1 }, { where: { id: 1 }});
查询后
id || data
1 || 11
我知道这是一个简单的问题,但我找不到解决方案.
I know it's a simple question, but I could not find the solution.
我可以加减哪个运算符?谢谢
Which operator can I add and subtract? Thank you
推荐答案
这里是:
db.table.update({ field: Sequelize.literal('data + 1') }, { where: { id: 1 }}))
或
User.findById(1).then(user => {
// -----> First Way
return user.increment('my-integer-field', {by: 2});
// -----> Second Way
return user.increment([ 'my-integer-field', 'my-very-other-field' ], {by: 2})
// -----> Third Way
return user.increment({
'my-integer-field': 2,
'my-very-other-field': 3
})
});
您也可以通过将 increment
替换为 decrement
来执行 decrement
.
You can also do decrement
by just replacing increment
with decrement
.
更多详情:阅读
For more detail : DO READ
这篇关于Sequelize 的加减赋值运算符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文