续集选择并包含另一个表别名 [英] sequelize select and include another table alias
本文介绍了续集选择并包含另一个表别名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
I'm using sequelize to acess a postgres database and I want to query for a city and for example include the "Building" table but I want to rename the output to "buildings" and return the http response but I have this error:
{ SequelizeEagerLoadingError: building is associated to city using an alias. You'v e included an alias (buildings), but it does not match the alias defined in your a ssociation.
City.findById(req.params.id,{
include: [
{
model: Building, as: "buildings"
}
]
}).then(city =>{
console.log(city.id);
res.status(201).send(city);
}) .catch(error => {
console.log(error);
res.status(400).send(error)
});
city Model
const models = require('../models2');
module.exports = (sequelize, DataTypes) => {
const City = sequelize.define('city', {
name: { type: DataTypes.STRING, allowNull: false },
status: { type: DataTypes.INTEGER, allowNull: false },
latitude: { type: DataTypes.BIGINT, allowNull: false },
longitude: { type: DataTypes.BIGINT, allowNull: false },
}, { freezeTableName: true});
City.associate = function(models) {
// associations can be defined here
City.hasMany(models.building,{as: 'building', foreignKey: 'cityId'})
};
return City;
};
解决方案
As you have defined alias name in below code is building
:
City.hasMany(models.building,{as: 'building', foreignKey: 'cityId'})
But in query , you are using buildings
include: [
{
model: Building, as: "buildings" // <---- HERE
}
]
It should be building
:
include: [
{
model: Building, as: "building" // <---- HERE
}
]
这篇关于续集选择并包含另一个表别名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文