ActiveRecord: Reading MySQL views

Rails
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. [email protected] wrote:

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