Ruby on Rails ߝ具有多个多对多关联的模型

Question

我目前正在开发《地下城与地下城》 Ruby on Rails 3.2.1 中的 Dragons 第四版角色表应用程序。我目前正处于一个阶段，我意识到我需要将角色种族（矮人、精灵……）与能力奖励联系起来。 （例如：作为种族特征，矮人的体质和智慧能力获得+2加值。）

我目前的设置如下：

class Character < ActiveRecord::Base {
  has_many :attributions
  has_many :abilities, through: :attributions
}

class Attribution < ActiveRecord::Base {
  belongs_to :character
  belongs_to :ability

  # The "attributions" table also has the column "score,"
  # which is the character's ability score
}

class Ability < ActiveRecord::Base {
  has_many :attributions
  has_many :characters, through: :attributions
}

如您所见，每个角色都有自己的一套能力。我想我可能会对角色竞赛做同样的事情，但我不确定这个领域是否有任何最佳实践。我可能可以使用相同的连接模型，创建类似的东西（Character 将保持不变，除了覆盖的 powered 方法，也许）：

class CharacterRace < ActiveRecord::Base {
  # I am not sure if this will actually work, but I hope
  # you understand what I am trying to do with this
  has_many :racial_ability_traits, class_name: "Attribution"
  has_many :abilities, through: :racial_ability_traits
}

class Attribution < ActiveRecord::Base {
  # The following two are just like before
  belongs_to :character
  belongs_to :ability

  # This field would be new
  belongs_to :character_class
}

class Ability < ActiveRecord::Base {
  # These are the same as above
  has_many :attributions
  has_many :characters, through: :attributions

  # These would be new, and I am not sure if it will work, but
  # I hope you understand what I amm trying to do with this
  has_many :racial_traits, class_name: "Attribution"
  has_many :character_races, through: :racial_ability_traits
}

但是，即使 如果这可行，我不知何故觉得对不同的连接使用相同的连接模型（即使目的几乎相同）是一种丑陋的方法。当然，我可以创建一种不同类型的连接，如下所示：

class CharacterRace < ActiveRecord::Base {
  has_many :abilities, through: :attributions

  # These are for the racial bonus
  has_many :racial_ability_bonuses
  has_many :abilities, through: :racial_ability_bonuses
}

class RacialAbilityBonus < ActiveRecord::Base {
  belongs_to :character_race
  belongs_to :ability
}

class Ability < ActiveRecord::Base {
  has_many :attributions
  has_many :abilities, through: :attributions

  # These are for the racial bonus
  has_many :racial_ability_bonuses
  has_many :character_races, through: :racial_ability_bonuses
}

这可能会起作用，但有一个问题。不仅种族可以拥有这样的特征/奖励。魔法物品也可能带来能力加值。因此，Item 模型还应该通过: :item_ability_bonus 关联赋予一个 has_many :ability。继续沿着上面解释的道路前进，这将导致很多连接模型。

因此我想问一下你们是否知道处理这个问题的好方法。也欢迎任何关于改进我现有代码的建议。

我非常感谢你们所有认真的回答。 :-)

Answer 1

我认为你只需要多态关联。