Rails组合了多个多态has_many关联

Question

我有一个名为Organization的模型，它有很多teams和collaborations。一个CCD_ 4也有许多CCD_。因此，团队模型与Organization和Collaboration具有多态性关联。

我想做的是organization.teams，它反映了组织中的所有团队以及组织中合作的所有团队。

表格

*organizations*
id
user_id
title
...
*collaborations*
id
organization_id
title
...
*teams*
id
teamable_id
teamable_type
title
...

型号

class Organization < ApplicationRecord
has_many :orgaization_teams, as: :teamable, class_name: "Team"
has_many :collaboration_teams, through: :collaborations, source: :teams, class_name: "Team"
end
class Collaboration < ApplicationRecord
belongs_to :organization
has_many :teams, as: :teamable
end
class Team < ApplicationRecord
belongs_to :teamable, polymorphic: true
belongs_to :organization, -> { joins(:teams).where(teams: {teamable_type: 'Organization'}) }, foreign_key: 'teamable_id'
belongs_to :collaboration, -> { joins(:teams).where(teams: {teamable_type: 'Collaboration'}) }, foreign_key: 'teamable_id'
end

尝试次数

尝试#1

class Organization < ApplicationRecord
has_many :teams, -> { joins(:organization, :collaboration) }, source: :teamable
end

结果：SystemStackError(堆栈级别太深(

尝试#2

class Organization < ApplicationRecord
def teams
orgaization_teams.or(collaboration_teams)
end
end

结果：ArgumentError(传递给#或的关系必须在结构上兼容。不兼容的值：[：joins](

潜在解决方案

我正在考虑将Team上的多态关联分离为organization_id和collaboration_id

所以新的表格看起来是这样的：

*teams*
id
organization_id
collaboration_id
title
...

Answer 1

我会使用两个单独的外键：

class Organization < ApplicationRecord
has_many :teams
has_many :collaborations
has_many :collaboration_teams, 
through: :collaborations,
source: :team
end
class Collaboration < ApplicationRecord
belongs_to :organization
has_many :teams
end
class Team < ApplicationRecord
belongs_to :team, optional: true
belongs_to :organization, optional: true
end

如果你想获得直接属于组织或其合作的团队，你需要：

Team.where(
organization_id: org.id
).or(
Team.where(
collaboration_id: org.collaborations
)
)

我不认为这实际上可以写成一个关联，因为它的结构太复杂了。