如何使用Sequelize查找关系中某列满足条件的所有人?
例如,找到所有作者姓"希区柯克"的书.图书模式包含与作者表的hasOne关系.
编辑:我理解如何使用原始SQL查询来实现这一点,但正在寻找另一种方法
如何使用Sequelize查找关系中某列满足条件的所有人?
例如,找到所有作者姓"希区柯克"的书.图书模式包含与作者表的hasOne关系.
编辑:我理解如何使用原始SQL查询来实现这一点,但正在寻找另一种方法
下面是一个工作示例,演示了如何通过用户续集,通过一个有特定姓氏的Author
获得所有Books
个.它看起来比实际情况要复杂得多,因为我正在定义模型,关联它们,与数据库同步(创建它们的表),然后在这些新表中创建虚拟数据.在代码的中间寻找findAll
个,看看你到底在追求什么.
module.exports = function(sequelize, DataTypes) {
var Author = sequelize.define('Author', {
id: {
type: DataTypes.INTEGER,
allowNull: false,
autoIncrement: true,
primaryKey: true
},
firstName: {
type: DataTypes.STRING
},
lastName: {
type: DataTypes.STRING
}
})
var Book = sequelize.define('Book', {
id: {
type: DataTypes.INTEGER,
allowNull: false,
autoIncrement: true,
primaryKey: true
},
title: {
type: DataTypes.STRING
}
})
var firstAuthor;
var secondAuthor;
Author.hasMany(Book)
Book.belongsTo(Author)
Author.sync({ force: true })
.then(function() {
return Book.sync({ force: true });
})
.then(function() {
return Author.create({firstName: 'Test', lastName: 'Testerson'});
})
.then(function(author1) {
firstAuthor=author1;
return Author.create({firstName: 'The Invisible', lastName: 'Hand'});
})
.then(function(author2) {
secondAuthor=author2
return Book.create({AuthorId: firstAuthor.id, title: 'A simple book'});
})
.then(function() {
return Book.create({AuthorId: firstAuthor.id, title: 'Another book'});
})
.then(function() {
return Book.create({AuthorId: secondAuthor.id, title: 'Some other book'});
})
.then(function() {
// This is the part you're after.
return Book.findAll({
where: {
'Authors.lastName': 'Testerson'
},
include: [
{model: Author, as: Author.tableName}
]
});
})
.then(function(books) {
console.log('There are ' + books.length + ' books by Test Testerson')
});
}