I've come across this issue several times on various forums but haven't been able to resolve it yet. My setup involves Express and PostgreSQL with Sequelize ORM.
The problem lies in the one-to-one relationship between two models: Campus and Academic Manager. Each Campus is associated with one Academic Manager.
Although I have successfully implemented both models and their association, when attempting to fetch campus data with manager information included, I keep encountering the same error:
SequelizeEagerLoadingError: academic_manager is not associated to campus!
I suspect that the error may be related to the usage of include.
Below are snippets from my code:
campus.js
const campus = (sequelize, DataTypes) =>{
const Campus = sequelize.define('campus', {
name: {
type: DataTypes.STRING,
allowNull: false,
},
manager: {
type: DataTypes.INTEGER,
allowNull: false,
references: {
model: 'academic_manager',
key: 'id'
}
}
});
Campus.associate = models => {
Campus.hasOne(models.Manager, { foreignKey: 'id'});
}
return Campus;
};
export default campus;
academic_manager.js
const manager = (sequelize, DataTypes) =>{
const Manager = sequelize.define('academic_manager', {
name: {
type: DataTypes.STRING,
allowNull: false,
},
email: {
type: DataTypes.STRING,
allowNull: false
}
});
Manager.associate = models => {
Manager.belongsTo(models.Campus, { foreignKey: 'id'});
}
return Manager;
};
export default manager;
And here's the get method:
router.get('/', async (req, res) => {
const campus = await req.context.models.Campus.findAll({
include: [
{ model: req.context.models.Manager }
]
});
return res.send(campus);
});
The get request works fine without the include. The association seems to be correctly set up as evidenced by the table descriptions:
TABLE "campus" CONSTRAINT "campus_manager_fkey" FOREIGN KEY (manager) REFERENCES academic_manager(id)