sequelize 如何进行联合查询

Question

现在假设有三个表，Program(方案表，1个方案多个实施), Implementation(实施表，1个实施有一个工具;该表字段program_id指向program的自增ID,该表字段tool_id指向tools的自增ID), Tools(工具表)

Program = sequelize.define('program', {
  program_id : {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
});

Implementation = sequelize.define('implementation', {
  implementation_id : {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  program_id: {
    type: DataTypes.INTEGER,
  },
  tool_id: {
    type: DataTypes.INTEGER,
  },
});

Tools= sequelize.define('tools', {
  tool_id : {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
});

请问该如何定义associate？

Answer 1

添加关联关系
Models. program.hasMany(Models.implementation, { foreighKey: 'program_id', as: 'implementations' });
Models.implementation.belongsTo(Models.tools, { foreighKey: 'tool_id', as: 'Tools' });

model 定义

Implementation = sequelize.define('implementation', {
  implementation_id : {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  program_id: {
    type: DataTypes.INTEGER,
     references: {
        model: 'program',
        key: 'id',
      },
  },
  tool_id: {
    type: DataTypes.INTEGER,
     references: {
        model: 'program',
        key: 'id',
      },
  },
});

后面就可以连表查了

Answer 2

请问楼主解决这个问题了吗，是基于Program进行查询吗