ActiveRecord subclass with manual DB connect ion can’t directly access column variables


#1

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.


#2

On Jun 9, 6:09 am, gberz3 removed_email_address@domain.invalid wrote:

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


#3

On Jun 9, 4:00 am, Frederick C. removed_email_address@domain.invalid
wrote:

Are the table column names uppercased ?

Fred

Wow, that was absolutely it. Thanks so much!