Hi, until yesterday (2010-09-14) I could use active_scaffold with two
databases by doing this hack:
----------- database.yml --------------
production:
adapter: mysql
database: db_1
username: xxxxxxxx
password: xxxxxxxx
host: xxxxxxxxxx
db_2:
adapter: mysql
database: db_2
username: xxxxxx
password: xxxxxx
host: xxxxxxxx
-----------------------------------------------
--------- models/item.rb ------------
class Item < ActiveRecord::Base
establish_connection configurations[RAILS_ENV]["db_2"]
def self.table_name() "db_2.items" end
end
---------------------------------------------
Note that I use "db_2.items" as table name. This is a workaround as
active_scaffold (or perhaps AR) assumes that the main database (db_1)
is always used.
So this worked until yesterday, but today I've upgraded
active_scaffold (for rails 2.3.X) and get this error:
------------------------------------------------
Mysql::Error: Unknown column 'db_2.items.Id_Cliente' in 'order
clause': SELECT `db_2`.`items`.* FROM `db_2`.`items` ORDER BY
`db_2.items`.`Id_Cliente` ASC LIMIT 0, 20
------------------------------------------------
The problem occurs due to `db_2.items`.`Id_Cliente` . It should be
`db_2`.`items`.`Id_Cliente`. And this is *exactly* what I got with the
previous active_scaffold version:
----------------------------------
SELECT `db_2`.`items`.* FROM `db_2`.`items` ORDER BY
`db_2`.`items`.`Id_Cliente` ASC LIMIT 0, 20
----------------------------------
I've tested it in both cases with Rails 2.3.9 and with a previous
version of active_scaffold and the version of today.
Thanks a lot.
--
Iñaki Baz Castillo
<[email protected]>
--
You received this message because you are subscribed to the Google Groups
"ActiveScaffold : Ruby on Rails plugin" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/activescaffold?hl=en.
