Rails - Jun 2009 - ActiveRecord subclass with manual DB connection can’t directly access column variables.

Hi All,

I''m having a slight issue with one of my Rails models. It''s
nothing I
can''t work around (as I''ve already done so), but I''m
interested in the
actual issue.

Basically, I have an ActiveRecord-based class named "Events" that
I''ve
connected to a remote database using "establish_connection". It all
works fine and I can even perform an "Event.find(:all)". However, I am
unable to use any of the convenience (column_name) methods. I am
forced to do something like the following:

for each event in Event.find(:all)
  puts event["Point"]
  puts event["Timestamp"]
end
...instead of

for each event in Event.find(:all)
   puts event.point
   puts event.timestamp
end
FYI, when I generated the model I only ran "script/generate model
event" and absolutely nothing else. I then used
"establish_connection"
and "set_table" inside the model in order to get a connection. Besides
that I''ve done nothing. Again, querying works, but I don''t get
my
convenience access.

Ideas?

Best.

On Jun 9, 6:09 am, gberz3 <gbe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hi All,
>
> I''m having a slight issue with one of my Rails models.
It''s nothing I
> can''t work around (as I''ve already done so), but
I''m interested in the
> actual issue.
>
> Basically, I have an ActiveRecord-based class named "Events" that
I''ve
> connected to a remote database using "establish_connection". It
all
> works fine and I can even perform an "Event.find(:all)". However,
I am
> unable to use any of the convenience (column_name) methods. I am
> forced to do something like the following:
>
> for each event in Event.find(:all)
>   puts event["Point"]
>   puts event["Timestamp"]
> end
> ...instead of
>
> for each event in Event.find(:all)
>    puts event.point
>    puts event.timestamp
Are the table column names uppercased ?

Fred
> end
> FYI, when I generated the model I only ran "script/generate model
> event" and absolutely nothing else. I then used
"establish_connection"
> and "set_table" inside the model in order to get a connection.
Besides
> that I''ve done nothing. Again, querying works, but I
don''t get my
> convenience access.
>
> Ideas?
>
> Best.

On Jun 9, 4:00 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Are the table column names uppercased ?
>
> Fred

Wow, that was absolutely it.  Thanks so much!