Sequelize OR 条件对象 [英] Sequelize OR condition object
本文介绍了Sequelize OR 条件对象的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
通过创建这样的对象
var condition=
{
where:
{
LastName:"Doe",
FirstName:["John","Jane"],
Age:{
gt:18
}
}
}
并传入
Student.findAll(condition)
.success(function(students){
})
它可以像这样漂亮地生成 SQL
It could beautifully generate SQL like this
"SELECT * FROM Student WHERE LastName='Doe' AND FirstName in ("John","Jane") AND Age>18"
但是,这都是'AND'条件,我如何通过创建条件对象来生成'OR'条件?
However, It is all 'AND' condition, how could I generate 'OR' condition by creating a condition object?
推荐答案
现在好像有别的格式了
where: {
LastName: "Doe",
$or: [
{
FirstName:
{
$eq: "John"
}
},
{
FirstName:
{
$eq: "Jane"
}
},
{
Age:
{
$gt: 18
}
}
]
}
会生成
WHERE LastName='Doe' AND (FirstName = 'John' OR FirstName = 'Jane' OR Age > 18)
查看文档:http://docs.sequelizejs.com/en/latest/docs/查询/#where
这篇关于Sequelize OR 条件对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文