Sequelize.js。如何连接两个表(一对一)

Question

我有两张桌子

--- registries
id name
1  dev
--- registries_meta
registryId data
1          {dev: true}

那怎么加入呢？我的代码：

  public static associate() {
    RegistriesModel.hasOne(RegistriesMetaModel, { foreignKey: 'registryId', sourceKey: 'id' });
    RegistriesModel.belongsTo(RegistriesMetaModel, { foreignKey: 'id' });
    return;
  }

我有个错误：

SQLITE_ERROR: no such column: RegistriesMetaModel.id

如何修复thia愚蠢的协会？预期查询：

SELECT * FROM registries LEFT JOIN registries_meta ON registries.id = registries_meta.registryId;

Answer 1

在您的示例中，Registries模型是目标模型，它具有RegistriesMeta。因此，在定义关联时，您需要将它们定义如下：

   Registries.hasOne(RegistriesMeta, {
       foreignKey: "registryId"
   });
   RegistriesMeta.belongsTo(Registries, {
       foreignKey: "registryId"
   });