Forum: Ruby on Rails ActiveRecord: Reading MySQL views

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Brian J. (Guest)
on 2007-01-26 20:24
(Received via mailing list)
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.
Brian J. (Guest)
on 2007-01-26 20:26
(Received via mailing list)
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.
Anthony E. (Guest)
on 2007-01-26 20:40
(Received via mailing list)
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.


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

Cell: 808 782-5046
Current Location: Melbourne, FL
This topic is locked and can not be replied to.