Rails - Apr 2008 - employments example using Rich associations :through

What is the best way to deal with this model in rails 2.0 +

class School < ActiveRecord::Base
# school model has a name attribute
  has_many :employments
  has_many :teachers , :through=> :employments
end

class Teacher < ActiveRecord::Base
# teacher model has a name attribute
  has_many :employments
  has_many :schools , :through=> :employments

end

class Employment < ActiveRecord::Base
# employment has a start_date and an end_date
# end_date is null if the teacher is currently employed
# by that school


  belongs_to :school
  belongs_to :teacher
end

What is the best way to code this, so that I can do the following :

teacher.schools.current.name

teacher.schools.past[0].name
teacher.schools.past[0].start_date
teacher.schools.past[0].end_date


school.teachers.current[0].name
school.teachers.current[0].start_date

school.teachers.past[0].name


Thanks





Something like :

user.favorite_articles.each do |fav|

????

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

On Apr 4, 1:45 pm, macarthy
<justin.maccar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> What is the best way to deal with this model in rails 2.0 +
>
> class School < ActiveRecord::Base
> # school model has a name attribute
>   has_many :employments
>   has_many :teachers , :through=> :employments
> end
>
> class Teacher < ActiveRecord::Base
> # teacher model has a name attribute
>   has_many :employments
>   has_many :schools , :through=> :employments
>
> end
>
> class Employment < ActiveRecord::Base
> # employment has a start_date and an end_date
> # end_date is null if the teacher is currently employed
> # by that school
>
>   belongs_to :school
>   belongs_to :teacher
> end
>
> What is the best way to code this, so that I can do the following :
>
You can do this with association proxies, so for teachers, something
like

has_many :schools, :through => :employments do
  def current
    find :first, :conditions => ''end_date IS NULL''
  end
  def past
    find :all, :conditions => ''end_date is NOT NULL''
  end
end

would probably do the trick (just typed in my mail client, so you may
have to do some fiddling to get this to work.

Fred
> teacher.schools.current.name
>
> teacher.schools.past[0].name
> teacher.schools.past[0].start_date
> teacher.schools.past[0].end_date
>
> school.teachers.current[0].name
> school.teachers.current[0].start_date
>
> school.teachers.past[0].name
>
> Thanks
>
> Something like :
>
> user.favorite_articles.each do |fav|
>
> ????
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---