how to use default database for user sign in but after the signed in use another database with rails

Question

i m using mysql2 as database and devise for user authentication.

before_action :authenticate_partner!

I have this line in my application_controller.rb as devise gem suggested.

I have total of 6 tables.

2 of them is in my default database and one of them partner table- created by devise.

What i want is this; when user_signed_in? returns true I want to establish a new connection based on the user name.

I got multiple controllers and I didn't want to create a establish_connection method for each one of them.

So how can I keep my user safe and use different databases?

class ApplicationController < ActionController::Base
  before_action :authenticate_partner!
  protect_from_forgery with: :exception

  def find_user_name
     if partner_signed_in?
       ActiveRecord::Base.establish_connection(                                                                                                                                    
         :adapter => "mysql2",                                                                                                                                                       
         :database => "db_#{current_partner.name} "
       )
    else
      logger.info "log in not succesful"
    end
  end
end

This code obviously gives me error when i remove def find_user_name but i can't seem to get in either of the if statements ( checked with logger.info)

So what should I do?

I think you're trying to build a multi tenant app. This is quite complicated thing to do for a newbie ;) — Mike Szyndel
– Mike Szyndel, Commented Sep 1, 2014 at 16:28
well aren we all newbies in something :) i learn when I push myself to the limit.It may be a bad approach but I learn the best in that way.Thanks for the heads up tho — railsnewbie
– railsnewbie, Commented Sep 1, 2014 at 16:41

Anil Yadav · Accepted Answer · 2015-11-20 06:10:57Z

1

You can use remove_connection

old_connection = ActiveRecord::Base.remove_connection

If you have done

new_connection = ActiveRecord::Base.establish_connection(...)

This can be passed on to remove_connection

old_connection = ActiveRecord::Base.remove_connection(new_connection)

for detail code.

answered Nov 20, 2015 at 6:10

Anil Yadav

1,0967 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

how to use default database for user sign in but after the signed in use another database with 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