查询关联表时触发SequelizeEagerLoadingError问题求助

我用Sequelize-CLI生成了四个PostgreSQL表的模型和迁移脚本，通过PSQL确认外键连接正常，但执行关联查询时出错。相关的两个表模型、迁移脚本、查询代码及报错信息如下：

Program模型（Program.js） #

"use strict";

const { Model, DataTypes } = require('sequelize');

module.exports = (sequelize) => {
  class Program extends Model {
    static associate(models) {
      this.hasMany(models.Track, {
        foreignKey: 'program_id'
      });
      this.belongsTo(models.Cart);
    }
  }
  Program.init({
    program_id: {
        primaryKey: true,
        type: DataTypes.UUID,
        allowNull: false
    },
    program_length_ms: DataTypes.BIGINT,
    intra_track_fade_length_ms: DataTypes.BIGINT
  }, {
    sequelize,
    modelName: 'Program',
  });
  return Program;
};

Track模型（Track.js） #

"use strict";

const { Model, DataTypes } = require('sequelize');

module.exports = (sequelize) => {
  class Track extends Model {
    static associate(models) {
      this.belongsTo(models.Program, {
        foreignKey: 'program_id'
      });
    }
  }
  Track.init({
    track_id: {
        primaryKey: true,
        type: DataTypes.UUID,
        allowNull: false
    },
    spotify_track_id: {
        type: DataTypes.STRING,
        allowNull: false
    },
    program_id: {
        type: DataTypes.UUID,
        allowNull: false
    },
    program_position: DataTypes.BIGINT,
    track_name: DataTypes.STRING,
    duration_ms: DataTypes.BIGINT
  }, {
    sequelize,
    modelName: 'Track',
  });
  return Track;
};

Program迁移脚本（create-program.js） #

"use strict";
/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('Programs', {
      program_id: {
        primaryKey: true,
        type: Sequelize.UUID,
        allowNull: false
      },
      program_length_ms: {
        type: Sequelize.BIGINT
      },
      intra_track_fade_length_ms: {
        type: Sequelize.BIGINT
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
  },
  async down(queryInterface, Sequelize) {
    await queryInterface.dropTable('Programs');
  }
};

Track迁移脚本（create-track.js） #

"use strict";
/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('Tracks', {
      track_id: {
        primaryKey: true,
        allowNull: false,
        type: Sequelize.UUID
      },
      spotify_track_id: {
        type: Sequelize.STRING,
        allowNull: false
      },
      program_id: {
        type: Sequelize.UUID,
        allowNull: false,
        references: {
            model: {
                tableName: 'Programs'
            },
            key: 'program_id'
        }
      },
      program_position: {
        type: Sequelize.BIGINT
      },
      track_name: {
        type: Sequelize.STRING
      },
      duration_ms: {
        type: Sequelize.BIGINT
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
  },
  async down(queryInterface, Sequelize) {
    await queryInterface.dropTable('Tracks');
  }
};

查询代码片段 #

我想实现和SELECT * FROM "Programs" JOIN "Tracks" ON "Tracks".program_id = "Programs".program_id等效的查询，代码如下：

const resultLibrary = await Program.findAll({
    include: [
        Track
    ]
});

报错信息 #

执行后得到以下错误：

Executing (a63c5e44-d14e-4e55-b047-3f685c0be5bf): START TRANSACTION;
Executing (a63c5e44-d14e-4e55-b047-3f685c0be5bf): ROLLBACK;
Error while fetching user cart library:  EagerLoadingError [SequelizeEagerLoadingError]: Track is not associated to Program!
    at Program._getIncludedAssociation (/Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/node_modules/sequelize/lib/model.js:565:13)
    at Program._validateIncludedElement (/Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/node_modules/sequelize/lib/model.js:502:53)
    at /Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/node_modules/sequelize/lib/model.js:421:37
    at Array.map (<anonymous>)
    at Program._validateIncludedElements (/Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/node_modules/sequelize/lib/model.js:417:39)
    at Program.findAll (/Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/node_modules/sequelize/lib/model.js:1118:12)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async /Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/controllers/library.js:44:26
    at async /Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/node_modules/sequelize/lib/sequelize.js:507:18
    at async getLibrary (/Users/administrator/Documents/vscode_projects/8-track-using-spotify/server/controllers/library.js:25:18)

问题原因及解决办法 #

1. 确保模型从统一入口加载
   Sequelize的关联依赖models/index.js（Sequelize-CLI自动生成的模型入口）调用所有模型的associate方法完成初始化。如果直接单独导入单个模型，会跳过关联初始化流程。
   修正查询代码，从入口文件导入模型：

   const { Program, Track } = require('../models'); // 替换为你的models路径
   
   const resultLibrary = await Program.findAll({
       include: [Track]
   });
   

2. 显式指定关联别名（可选但更稳妥）
   在Program模型的hasMany关联中添加as别名，避免模型名称大小写或命名匹配问题：

   this.hasMany(models.Track, {
     foreignKey: 'program_id',
     as: 'tracks' // 定义关联别名
   });
   

   查询时使用别名匹配：

   const resultLibrary = await Program.findAll({
       include: [{ model: Track, as: 'tracks' }]
   });
   

3. 检查模型入口文件的关联初始化逻辑
   确认models/index.js中存在以下代码，确保所有模型的associate方法被调用：

   Object.keys(db).forEach(modelName => {
     if (db[modelName].associate) {
       db[modelName].associate(db);
     }
   });
   

   如果这段代码缺失，关联不会被初始化，直接触发报错。

内容的提问来源于stack exchange，提问作者Jfk52917