I've been playing around with STI and belongs_to / has_many relationships and I'm a bit confused.
I have a few questions based on a model configuration similar to:
class Parental < ActiveRecord::Base
end
class Mother < Parental
has_many :babies
end
class Father < Parental
has_many :babies
end
class Baby < ActiveRecord::Base
belongs_to :??????
end
Baby belong_to?babies table?My first thought is add parental_id to babies along with a method like Baby#owner that does the following:
Thank you!
The Baby belongs to both Mother and Father
belongs_to :mother
belongs_to :father
You can have multiple foreign keys. The Baby DB table then has two fields, mother_id and father_id
The definitive guide to associations is here: http://guides.rubyonrails.org/association_basics.html
The migration to create the Baby class would look something like this:
class CreateBabies < ActiveRecord::Migration
def self.up
create_table :babies do |t|
t.integer :father_id
t.integer :mother_id
end
end
def self.down
drop_table :babies
end
end
This gives you things like:
baby.mother and baby.father. You can't have a single parental_id because the foreign key can only point to one other record, meaning that babies would only have one parent (when really they have two).
Seems like, in this case, you're just misunderstanding the relationship, is all. You are on the right track.
I've solved a similar problem myself by adding an explicit foreign_key call.
Something like the following code:
class Parental < ActiveRecord::Base
end
class Mother < Parental
has_many :babies
end
class Father < Parental
has_many :babies
end
class Baby < ActiveRecord::Base
belongs_to :mother, foreign_key: 'parental_id'
belongs_to :father, foreign_key: 'parental_id'
end
Of course, this assumes that a baby has only one parent. :-)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With