ActiveRecord: Reading MySQL views

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 Jones

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 Jones

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

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