续集:父母至少有一个孩子

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

我的关系大致如下:

Parent: [id, name]
Children1: [id, parent_id, name]
Children2: [id, parent_id, name]
Children3: [id, parent_id, name]
Children4: [id, parent_id, name]

Parent 
  .hasMany -> Children1
  .hasMany -> Children2
  .hasMany -> Children3
  .hasMany -> Children4

所以,如果我这样做:

Parent->findOne({
  include: [{model: Children1}, {model: Children2}]
})

它只会将 Parent 带到有 children1 和 children2 的地方(即 Inner join).如果我这样做:

It will only bring Parent where there's children1 and children2 (ie, Inner join). If I do:

Parent->findOne({
  include: [
    {model: Children1, required: false}, 
    {model: Children2, required: false}
  ]
})

它会带来 Parent,如果有的话,它会带来 Children1 和/或 Children2.(即左连接).

It will bring Parent and if there's it will bring Children1 and/or Children2. (ie Left join).

我想要做的是在且仅当 Children1 或 Children2 或 ChildrenN 存在时才带上父母.可以是任何一个 ChildrenN,也可以是所有的 ChildrenN.只要至少有 1 个,我想带上家长.

What I want to do is to bring Parent IF AND ONLY IF either Children1 or Children2 or ChildrenN exists. Could be any of the ChildrenN or could be all of them. As long as there's at least 1, I want to bring Parent.

有什么想法吗?

推荐答案

required: true 添加到您的包含对象中,以使每个连接都成为右连接.您有四个单独的子表的任何原因?

Add required: true to your include objects to make each join a right join. Any reason you've got four separate children tables?

相关文章