Using ActiveRecord on Multiple Databases

Question

I am writing a payroll system that will integrate with a pre-existing system. The original system had a master database that handled user management and some global configuration, below that there are multiple databases each identical in structure, basically each database is one companies payroll database, all these are tied to the main database because it belongs to a parent company who has many subsidiaries each with their own HR department.

What I was wondering is if there is any way that I can, based on either a cookie or another method that stores what company they wish to connect to, dynamically change the ActiveRecord's target database based on their input using a before filter?

Here's an example:

User A logs in to the site, page loads with available companies that the user has permission to access, user will then select a company, they have admin privileges in that company, they add an employee, before that action is run, rails will switch the connection to the appropriate database then add the record.

possible duplicate of Connecting Rails 3.1 with Multiple Databases — Heskja
– Heskja, Commented Apr 23, 2015 at 6:51

sameers · Accepted Answer · 2020-02-26 23:05:33Z

12

You can use ActiveRecord::Base#establish_connection, to connect to the desired database.

You could pass the db credentials to establish_connection as a Hash

establish_connection(
  adapter: 'mysql2',
  encoding: 'utf8',
  pool: 5,
  username: 'me',
  password: 'mypassword'
)

There are more examples here

edited Feb 26, 2020 at 23:05

sameers

5,1053 gold badges39 silver badges46 bronze badges

answered Jul 30, 2013 at 8:40

Santhosh

29.3k9 gold badges84 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

toro2k Over a year ago

Can you provide an example please?

clifford.duke Over a year ago

Quick question, is the database.yml loaded when establish_connection called? because I might have to dynamically add new database connections via a web based control panel.

Santhosh Over a year ago

You can pass the db credentials to establish_connection as a Hash

clifford.duke Over a year ago

okay sweet, this should work perfectly with what I'm going to be doing, thanks!

Community · Accepted Answer · 2017-05-23 11:46:58Z

7

I'm not sure you can do it in run time, since the database connection is coupled to the class (model)

However, you can make different classes to be connected to different databases I don't want to copy someone else answer, so just look at this post

Connecting Rails 3.1 with Multiple Databases

and give him the credit

Good luck

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Jul 30, 2013 at 8:46

Oz Ben-David

1,6671 gold badge19 silver badges26 bronze badges

Collectives™ on Stack Overflow

Using ActiveRecord on Multiple Databases

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related