more than one database per model

Question

class Service < ActiveRecord::Base

establish_connection(
  :adapter  => "mysql",
  :host     => "myip",
  :username => "myusername",
  :password => "mypassword",
  :database => "mydatabase"
)

end

This works

Service.all #connects to mydatabase

But i need something like that.

Service.use(mydatabase1).all #connects to mydatabase1
Service.use(mydatabase2).all #connects to mydatabase2

How can i achieve this?

Update

Database names are dynamic. I want Service model to connect database dynamically. When i type Service.use(weeweweaszxc).all it has to use weeweweaszxc database.

score 3 · Accepted Answer · edited May 23 '17 at 11:52

3

Try taking a look as this question over here. How to best handle per-Model database connections with ActiveRecord?

They define the databases in the database.yml file like normal and call this in the model:

class AnotherDatabase < ActiveRecord::Base
  self.abstract_class = true
  establish_connection "anotherbase_#{RAILS_ENV}"
end

Used info from Priit's answer

edited May 23 '17 at 11:52

Community

1
1

answered Jun 10 '11 at 15:35

Devin M

9,636
2
33
46

How can i select database in active record query – rubyruby Jun 10 '11 at 15:39
But the database that model connects is changeable – rubyruby Jun 10 '11 at 15:53
Define the database in your database.yml and use that name in the `establish_connection` call. Do you want to use more than one db per model? – Devin M Jun 10 '11 at 16:00
Call `service.establish_connection("DB NAME")` and then call `service.all` – Devin M Jun 10 '11 at 16:02
No problem, hope your app goes well – Devin M Jun 10 '11 at 16:15

more than one database per model

Update

1 Answers1

Linked