Hi,
I have 4 apps using similar User tables(3 open source projects and one
in-house app). I'm trying to merge into one shared database User table
(external to all 4 apps).
------------------------------------------------------------------------------------------
I'm using the following code in the User model to switch to the shared
database:
class User < ActiveRecord::Base
# GSL, 03/18/09 - Add reference to external ua database.
User.establish_connection (
:adapter => "mysql",
:host => "example.corp.example.com",
:username => "root",
:password => "?",
:database => "ua_production"
)
------------------------------------------------------------------------------------------
Then, I have to switch the other models back:
class Attachment < ActiveRecord::Base
# GSL, 03/18/09 - Add reference to external ua database.
Attachment.establish_connection (
:adapter => "mysql",
:host => "example.corp.example.com",
:username => "root",
:password => "?",
:database => "redmine"
)
------------------------------------------------------------------------------------------
I added the above to all the other models in my Redmine app.
So, now the views that are trying to do a SQL JOIN are bombing.
Is there an easier way?
Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
