Rails：这些模型的正确关联是什么？

Question

这个问题的正确关联是什么？

共有三种模型：

• 居民
• 方
• 地址

每个居民和方都有一个地址

每个地址可以属于一个< code>Resident 或 Party 或两者。

同一地址可以有多个参与方，并且该位置可以有多个居民居住。

habtm 关系是这些模型的最佳解决方案吗？

我考虑过进行多态关联，但出现了冲突，因为地址可能同时属于Resident和Party多个有时

---

我希望能够做一些事情，例如...

address = Address.find_or_create_by_street("100 Some Street")

# Associate the Party with a specific Address:
party_object.address = address

# Find all Parties happening at a specific Address:
address.parties do ...

# Find all Residents located at a specific Address:
address.residents.each do ...

---

运行 Rails 3 + MySQL 5.5

Answer 1

我认为不需要多态性

class Address < ActiveRecord::Base
  has_many :parties
  has_many :residents
end

class Party < ActiveRecord::Base
  belongs_to :address
end

class Resident < ActiveRecord::Base
  belongs_to :address
end

 # Address can have multiple parties, and multiple residents. 
 # Resident belongs to an address (lives at only 1 address). 
 # A party belongs to an address (party can be only at 1 address).

address = Address.create(:name => "10 something street.")
address.parties << Party.create(:name => "first")
address.parties << Party.create(:name => "second")
address.residents << Resident.create(:name => "John")
address.residents << Resident.create(:name => "Jane")


Party.first.address.name #10 something street.
Resident.first.address.name #10 something street.
address.parties.size #2
address.residents.size #2

Resident.first.address.parties.size #2

Answer 2

Rails 专家似乎正在逐步停止使用 habtm。我认为你可以用一个简单的 has_many 来做到这一点：

class Resident < ActiveRecord::Base
  belongs_to :address
end

class Party < ActiveRecord::Base
  belongs_to :address
end

class Address < ActiveRecord::Base
  has_many :residents 
  has_many :parties
end

从这些关联中，你可以做类似

party.address
address.residents
address.parties
party.address.residents
resident.address.parties

Schema

的事情SQL 模式（省略 Rails 默认值）将与此一起使用，看起来像：

create_table "residents" do |t|
  t.integer  "address_id"
  t.string   "name"
  ... etc
end

create_table "parties" do |t|
  t.integer  "address_id"
  t.datetime "start_time"
  ... etc.
end

create_table "addresses" do |t|
  t.string   "first_line"
  ...etc.
end

编辑
更新：has_one -> :belongs_to 按照 @klochner 的正确建议，关于居民和当事人。