ActiveRecord one connection per request

Question

I have an application that let the user to connect in multiples environments. Depending of the choice of environment that the user pick, activerecord will use Database X or Y.

But when I use ActiveRecord::Base.establish_connection, activerecord change the database for all users. I want that user 'A' use Database 'X' and user 'B' use Database 'Y' at the same time in one single application. Is that possible with rails?

are you using something like apartment or octopus – Thor odinson Dec 19 '16 at 16:06 — Thor odinson, Dec 19 '16 at 16:06
No, pure ActiveRecord only. – Otavio Moreira Dec 19 '16 at 16:25 — Otavio Moreira, Dec 19 '16 at 16:25
would you be opposed in looking into a gem to help out? – Thor odinson Dec 19 '16 at 16:26 — Thor odinson, Dec 19 '16 at 16:26

score 0 · Answer 1 · answered Dec 19 '16 at 16:30

0

I am thinking that you can do something like this

you do need to declare the connection in your /config/database.rb

MyModel < ActiveRecord::Base
    establish_connection "other_#{session[:user_db]}"
end

answered Dec 19 '16 at 16:30

Thor odinson

180
1
11

score 0 · Accepted Answer · edited May 23 '17 at 12:30

0

You can try this answer.

Based on user type (X or Y), you can establish the respective DB connection.

Or,

You can try this gem.

edited May 23 '17 at 12:30

Community

1
1

answered Dec 19 '16 at 17:12

Jayaprakash

1,407
1
9
19

This gem can help me. – Otavio Moreira Dec 19 '16 at 17:20

ActiveRecord one connection per request

2 Answers2