Sequelize Join 非主键

2022-01-19 00:00:00 node.js mysql sequelize.js

我需要关联两个表.表 A 有一个表 B.我可以在 TableA 模型中做到这一点:

I have two tables I need to associate. TableA has One TableB. I'm able to do this in the TableA Model:

TableA.hasOne( models.TableB, { as: 'TableB', foreignKey: 'someID' } );

查看 SQL，它尝试连接 TableA.ID 和 TableB.someID.我真正想要的是加入 TableA.someNonPrimaryKey 和 TableB.someID.

Looking at the SQL, this tries to join TableA.ID and TableB.someID. What I actually want, is to join TableA.someNonPrimaryKey and TableB.someID.

如何让 sequelize 加入 someNonPrimaryKey?

How can I tell sequelize to join with someNonPrimaryKey?

推荐答案

我知道这是旧的；我是为了其他可能需要答案的人而做出回应的.

I know this is old; I am responding for the sake of others that might need the answer.

您现在可以在非主键列上关联表.在您的情况下，关联将是:

You can now associate tables on non-primary key columns. In your case, the association would be:

TableA.hasOne(TableB, {
  sourceKey: 'someNonPrimaryKeyColumnOnTheSOurceModel',
  foreignKey: 'matchingColumnOnTheTargetModel'
});

请注意，列 someNonPrimaryKeyColumnOnTheSOurceModel 必须在模型定义中将 unique 设置为 true.

Please note, the column someNonPrimaryKeyColumnOnTheSOurceModel must have unique set to true in the model definition.

您可以在此处阅读更多信息:https://sequelize.org/master/manual/assocs.html

You can read more about it here: https://sequelize.org/master/manual/assocs.html

相关文章