Hi, I''m new to Rails and Database Programming in general. I''m trying to create a site where there is a list of books and the authors. Right now I''ve got a two tables in my database. One contains information about books, and the other contains the authors. There is a foreign key(author_id) in the books table linking to the id row in the author table. To enter the information there is a form(I haven''t made it yet) that asks for the book title, the published date, and the author''s first, middle and last name. Does Rails check for redundancy automatically as far as data is concerned for foreign keys? Let''s say my first entry is a book by Stephen King. Now let''s say I want to enter another book by Stephen King. Do I write the code checking to see if the author already exists in the DB and then setting the value of that foreign key, or is there something in Ruby/Rails that does this for me? If there is some way that Ruby/Rails does this automatically, what keywords should I be using to find more information? Thanks. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
The part on "dynamic finders" in the AR::Base docs may be what your looking for. Look for find_or_create_by and find_or_initialize_by in particular: <URL:http://api.rubyonrails.org/classes/ActiveRecord/Base.html> -John On Jun 11, 11:38 am, oozy <oozy...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > I''m new to Rails and Database Programming in general. I''m trying to > create a site where there is a list of books and the authors. Right > now I''ve got a two tables in my database. One contains information > about books, and the other contains the authors. There is a foreign > key(author_id) in the books table linking to the id row in the author > table. To enter the information there is a form(I haven''t made it > yet) that asks for the book title, the published date, and the > author''s first, middle and last name. > > Does Rails check for redundancy automatically as far as data is > concerned for foreign keys? Let''s say my first entry is a book by > Stephen King. Now let''s say I want to enter another book by Stephen > King. Do I write the code checking to see if the author already > exists in the DB and then setting the value of that foreign key, or is > there something in Ruby/Rails that does this for me? If there is some > way that Ruby/Rails does this automatically, what keywords should I be > using to find more information? > > Thanks.--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Thanks! On Jun 12, 1:32 pm, jparker <johncpar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> The part on "dynamic finders" in the AR::Base docs may be what your > looking for. Look for find_or_create_by and find_or_initialize_by in > particular: > > <URL:http://api.rubyonrails.org/classes/ActiveRecord/Base.html> > > -John > > On Jun 11, 11:38 am, oozy <oozy...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hi, > > > I''m new to Rails and Database Programming in general. I''m trying to > > create a site where there is a list of books and the authors. Right > > now I''ve got a two tables in my database. One contains information > > about books, and the other contains the authors. There is a foreign > > key(author_id) in the books table linking to the id row in the author > > table. To enter the information there is a form(I haven''t made it > > yet) that asks for the book title, the published date, and the > > author''s first, middle and last name. > > > Does Rails check for redundancy automatically as far as data is > > concerned for foreign keys? Let''s say my first entry is a book by > > Stephen King. Now let''s say I want to enter another book by Stephen > > King. Do I write the code checking to see if the author already > > exists in the DB and then setting the value of that foreign key, or is > > there something in Ruby/Rails that does this for me? If there is some > > way that Ruby/Rails does this automatically, what keywords should I be > > using to find more information? > > > Thanks.--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---