javascript - Loopback 3.x - 用户 Angular 色 M :M relation though RoleMapping

Question

我有一个自定义用户、 Angular 色和 Angular 色映射，名为 AdminUser、AdminRole 和 AdminRoleMapping。我已经用数据填充了数据库，并且使用的是 Mysql 和 Loopback 3.19。我的模型配置是:

{
  "name": "AdminRole",
  "plural": "adminRoles",
   ...
  "base": "Role",
  "relations": {
    "users": {
      "type": "hasMany",
      "model": "AdminUser",
      "foreignKey": "principalId",
      "through": "AdminRoleMapping"
    }
  },
...
}

<小时/>

{
  "name": "AdminUser",
  "plural": "adminUsers",
  "base": "User",
   ...
    "roles": {
      "type": "hasMany",
      "model": "AdminRole",
      "foreignKey": "principalId",
      "through": "AdminRoleMapping"
    }
  },
  ...
}

<小时/>

{
  "name": "AdminRoleMapping",
  "description": "Map principals to roles",
  "plural": "adminRoleMappings",
  "base": "RoleMapping",
  ....
  "relations": {
    "principal": {
      "type": "belongsTo",
      "model": "AdminUser",
      "foreignKey": "principalId"
    },
    "roles": {
      "type": "belongsTo",
      "model": "AdminRole",
      "foreignKey": "roleId"
    }
  },
  ....
}

<小时/>

当我尝试访问 GET/adminUsers/{id}/roles 时，我收到状态错误 500

“message”:“未为 AdminRoleMapping 模型定义关系“adminRole””

我的设置有什么问题吗？我已遵循文档。

Answer 1

经过一番尝试和错误，重命名中间表中的关系名称，解决了问题:

{
  "name": "AdminRoleMapping",
  "description": "Map principals to roles",
  "plural": "adminRoleMappings",
  "base": "RoleMapping",
  ...
  "relations": {
    "adminUser": {
      "type": "belongsTo",
      "model": "AdminUser",
      "foreignKey": "principalId"
    },
    "adminRole": {
      "type": "belongsTo",
      "model": "AdminRole",
      "foreignKey": "roleId"
    }
  },
  ...
}