The easiest thing to do by far is to set up an attribute alias. In
your code you can just reference the alias and under the hood it will
do all necessary conversion; this even works with queries. With your
use case, see below:
class ForeignTable < ActiveRecord::Base
alias_attribute :Last_Name, :last_name
end
This means you'll only ever need to mention "Last_Name" once in your
code. You can do things like this:
ForeignTable.find(:all, :conditions => {:last_name => 'Little'})
Cheers,
Jordan
On Mar 16, 2009, at 4:18 PM, Glenn Little wrote:
>
> We've just run into a situation where an outside database we talk to
> has
> changed its schema for one of its tables. Among the potential issues
> is that a bunch of the column names now start with capital letters.
>
> Changing our references accordingly *seems* to work. ActiveRecord
> is now giving us
>
> ForeignTable#Last_Name()
>
> instead of
>
> ForeignTable#last_name.
>
> But I noticed that the IDE is now treating Last_Name like a constant
> (because of the initial cap) and I got to wondering if we weren't
> going
> to be shooting ourselves in the foot somewhere down the line by naming
> our ActiveRecord model objects using the conventions normally used for
> contants.
>
> Note that this database is not in our control, so we can't do anything
> about the name changes.
>
> Any caveats or issues with this that I may be missing, or maybe a way
> to tell ActiveRecord to ignore capitalization for a given table?
>
> Thanks...
>
> -glenn
>
>
> >
---------------------------------------------------------------
Jordan A. Fowler
2928 Fir St.
San Diego, CA 92102
E-mail: [email protected]
Website: http://www.jordanfowler.com
Phone: (619) 339-6752
--~--~---------~--~----~------------~-------~--~----~
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
-~----------~----~----~----~------~----~------~--~---
