I have 2 tables: people (id, name) children (id, parents_id, child_id) parents_id = people.id and child_id = people_id also So how I make a relationships in Rails? And how can all search: Children.find(:all, :conditions => ["parents.name LIKE ''Clin%'' ???? Or how??? And what if I want to add new child. Parents name is in people table, but childs not, so how I do? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Sounds like a many to many relationship, in which case you need to declare has_and_belongs_to_many on both people and children. The relationship then works through a join table. If you did this, you''d need to re think your model a little and your find and add problems would be different. Martin On Jan 26, 9:18 am, James Bond <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> I have 2 tables: > > people (id, name) > children (id, parents_id, child_id) > > parents_id = people.id and child_id = people_id also > > So how I make a relationships in Rails? > > And how can all search: > > Children.find(:all, :conditions => ["parents.name LIKE ''Clin%'' ???? Or > how??? > > And what if I want to add new child. Parents name is in people table, > but childs not, so how I do? > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
I think that the best solution to your problem is to use acts_as_tree http://github.com/rails/acts_as_tree/tree/master Martin Hawkins escribió:> Sounds like a many to many relationship, in which case you need to > declare has_and_belongs_to_many on both people and children. The > relationship then works through a join table. If you did this, you''d > need to re think your model a little and your find and add problems > would be different. > Martin > > On Jan 26, 9:18 am, James Bond <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> > wrote: > >> I have 2 tables: >> >> people (id, name) >> children (id, parents_id, child_id) >> >> parents_id = people.id and child_id = people_id also >> >> So how I make a relationships in Rails? >> >> And how can all search: >> >> Children.find(:all, :conditions => ["parents.name LIKE ''Clin%'' ???? Or >> how??? >> >> And what if I want to add new child. Parents name is in people table, >> but childs not, so how I do? >> -- >> Posted viahttp://www.ruby-forum.com/. >> > > >--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---