ActiveRecord: Reading MySQL views


#1

My production environment is actually Oracle, in which case if I say:

set_table_name “v_table”

It will treat it as a readonly table.

However, doing the same under MySQL throws an
ActiveRecord::StatementInvalid error, saying that the table db.view
doesn’t exist. Is there a way to get around this? I am using MySQL to
test some new code I am working on, and wouldn’t mind making the code
compatible across products.

Brian J.


#2

Wow that’s embarrassing, seconds after posting this it boiled down to a
spelling mistake.

Everything works now. Sorry for the list spam.

Carry on.

Brian J.


#3

In case you need it, I’ve implemented a plugin for Rails which
supports views in migrations and schema dumps. You can find out more
at: http://activewarehouse.rubyforge.org/rails_sql_views/

It currently supports MySQL and PostgreSQL in the latest release and
SQL Server in the trunk.

V/r
Anthony

On 1/26/07, Brian J. removed_email_address@domain.invalid wrote:


Cell: 808 782-5046
Current Location: Melbourne, FL