在“字段列表"中续写未知列“*.createdAt" [英] Sequelize Unknown column '*.createdAt' in 'field list'
问题描述
我在字段列表"中收到一个未知列userDetails.createdAt"尝试通过关联获取时.
I'm getting a Unknown column 'userDetails.createdAt' in 'field list' When trying to fetch with association.
在没有关联的情况下使用 findAll
工作正常.
Using findAll
without association works fine.
我的代码如下:
var userDetails = sequelize.define('userDetails', {
userId :Sequelize.INTEGER,
firstName : Sequelize.STRING,
lastName : Sequelize.STRING,
birthday : Sequelize.DATE
});
var user = sequelize.define('user', {
email: Sequelize.STRING,
password: Sequelize.STRING
});
user.hasOne(userDetails, {foreignKey: 'userId'});
user.findAll({include: [userDetails] }).success(function(user) {
console.log(user)
});
推荐答案
我认为错误是您在 sequelize 中启用了时间戳,但您在数据库中的实际表定义不包含时间戳列.
I think the error is that you have timestamps enabled in sequelize, but your actual table definitions in the DB do not contain a timestamp column.
当您执行 user.find 时,它只会执行 SELECT user.*
,它只获取您实际拥有的列.但是当你加入时,加入的表的每一列都会被别名,这会创建以下查询:
When you do user.find it will just do SELECT user.*
, which only takes the columns you actually have. But when you join, each column of the joined table will be aliased, which creates the following query:
SELECT `users`.*, `userDetails`.`userId` AS `userDetails.userId`,`userDetails`.`firstName` AS `userDetails.firstName`,`userDetails`.`lastName` AS `userDetails.lastName`, `userDetails`.`birthday` AS `userDetails.birthday`, `userDetails`.`id` AS `userDetails.id`, `userDetails`.`createdAt` AS `userDetails.createdAt`, `userDetails`.`updatedAt` AS `userDetails.updatedAt` FROM `users` LEFT OUTER JOIN `userDetails` AS `userDetails` ON `users`.`id` = `userDetails`.`userId`;
修复方法是禁用 userDetails 模型的时间戳:
The fix would be to disable timestamps for either the userDetails model:
var userDetails = sequelize.define('userDetails', {
userId :Sequelize.INTEGER,
firstName : Sequelize.STRING,
lastName : Sequelize.STRING,
birthday : Sequelize.DATE
}, {
timestamps: false
});
或所有型号:
var sequelize = new Sequelize('sequelize_test', 'root', null, {
host: "127.0.0.1",
dialect: 'mysql',
define: {
timestamps: false
}
});
这篇关于在“字段列表"中续写未知列“*.createdAt"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!