4 Rails apps using the same table. How to streamline?

Rails
1

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.

2

On Tue, Mar 24, 2009 at 11:50 AM, LaughingNinja
[email protected] wrote:

So, now the views that are trying to do a SQL JOIN are bombing.

Is there an easier way?

Are you sure something’s not correct with your model relationships?
What do they look like exactly? What do the errors from the bombing
look like?

–
Greg D.
http://destiney.com/

3

LaughingNinja wrote:

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.

Are you trying to join tables from different connections/database
instances?