对象"/>
Sequelize OR 条件对象
通过这样创建对象
var condition=
{
where:
{
LastName:"Doe",
FirstName:["John","Jane"],
Age:{
gt:18
}
}
}
并传入
Student.findAll(condition)
.success(function(students){
})
它可以像这样漂亮地生成 SQL
"SELECT * FROM Student WHERE LastName='Doe' AND FirstName in ("John","Jane") AND Age>18"
但是,这都是'AND'条件,我如何通过创建条件对象来生成'OR'条件?
回答如下:现在好像有另一种形式
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/en/latest/docs/querying/#where
更多推荐
Sequelize OR 条件对象
发布评论