I have a legacy database 'old' and a new database 'new' which rails
uses. I set up models using old with establish_connection(old), and
this works well, except for include:
class OldModel < ActiveRecord::Base
class NewModel < ActiveRecord::Base
a = OldModel.find :first
NewModel.find(:all, :include => :old_model)
will give an error like
Mysql::Error: Table 'new_db.old_models' doesn't exist: SELECT ... FROM
new_models LEFT OUTER JOIN old_models ON ... WHERE ...
Obviously a performance hit without the join. MySQL does support
joins you specify the database first (ex old_db.old_models). I can
hack it by doing the join manually but that doesn't sound like the
rails way. Any ideas?