On 17 Jan 2009, at 06:59, Alan Harwood wrote:
>
> I''m writing my first rails app and following a tutorial to guide
> me. I
> really like what I see until.... I get to the part where it tells me I
> have to follow a certain naming scheme for my database. Here''s my
> questions:
>
> 1. Do I HAVE to use plural table names?
>
> I''ve been designing databases for years. I understand the logic
for
> wanting to use plural names, but feel that singular names make more
> sense and as such have been designing my databases that way for years.
> Is there a workaround?
You can set pluralize_table_names on classes (or on
ActiveRecord::Base)>
>
> 2. Do I HAVE to use the id naming standard.
>
> It seems I was taught to name foreign keys with an FK_TableName.
> Well,
> I hate using underscores in column names. Also, the FK is lame. The
> naming scheme I use gives each table an primary key named "id".
Any
> foreign keys are simply the name of the table which they represent.
> (Another reason why I wouldn''t want to use plural names). Is
there a
> way to implement this in Rails?
>
For foreign keys you can call them whatever you want, but you''ll have
to pass :foreign_key => ''blah'' to all your associations
If you end up with the association having the same name as the column,
i.e.
belongs_to :person, :foreign_key => ''person''
Then you''re definitely skating on thin ice (because the association
accessor methods will overwrite the attribute methods and stuff like
that).
> 3. Assuming that there are workarounds for these, are they
> stable/feasible or would they be a constant nuisance? Am I better off
> to go with the Rails standards?
>
Most things can be made to work. I personally wouldn''t choose to fight
Rails unless I had to (ie legacy database out of my control)
Fred
> I appreciate your thoughts.
> --
> 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
-~----------~----~----~----~------~----~------~--~---