How to switch to specific database for specific model in rails?

Question

I am using apartment gem where it has multi tenancy. I want to have a solution like whenever that particular model is called or any execution happen it should switch to that specific database.

model name = RakeLog

main db_name = ABC

another db_name = ABC_logs

right now what I have done is created a class method in model

class RakeLog < ActiveRecord::Base

  def self.switch_to_log
    current = Apartment::Tenant.current
    Apartment::Tenant.switch!(current+'_logs')
  end
end

what I am doing now is calling this method everywhere when I need to switch to 'logs' db. I want something like whenever this model gets called it should switch to 'logs' db automatically. Any help is appreciated.

This could help - stackoverflow.com/a/43819672/4160532

Kedarnag Mukanahallipatna
– Kedarnag Mukanahallipatna

2019-02-26 06:50:14 +00:00
Commented Feb 26, 2019 at 6:50 — Kedarnag Mukanahallipatna
– Kedarnag Mukanahallipatna, Commented Feb 26, 2019 at 6:50

moritzg · Accepted Answer · 2019-04-10 13:25:39Z

1

Your question is not clear, I think you want to connect to another database db_name ABC_logs from model class, if yes then this will help you.

class RakeLog < ActiveRecord::Base

  establish_connection ABC_logs_DB

  def self.switch_to_log
    current = Apartment::Tenant.current
    Apartment::Tenant.switch!(current+'_logs')
  end
end

You can check the complete tutorial here

edited Apr 10, 2019 at 13:25

moritzg

4,4145 gold badges41 silver badges63 bronze badges

answered Feb 26, 2019 at 9:35

Asif Meer

715 bronze badges

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

Collectives™ on Stack Overflow

How to switch to specific database for specific model in rails?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related