About the db_connection option

[fchampreux]

Not being higly familiar with connections handling, I am wandering how to specify this option when:

1. using a connection declared in database.yml config file
2. using a custom connection to a foreign database

I'll be glad to add examples to the documentation when I solve this point :-)

Thanks a lot!

[sufleR]

@fchampreux I don't know how do you use this gem. Is it ruby on rails application? What rails version?

Rails guides mention about connected_to https://guides.rubyonrails.org/active_record_multiple_databases.html#using-manual-connection-switching
Inside connected_to block, you should be able to

 SqlQuery.new(:get_player_by_email, email: 'e@mail.dev', db_connection: ActiveRecord::Base.connection)

and I think it should work with the connection selected in connected_to. I'm sorry but I didn't test it.

With a custom connection, you should be able to call establish_connection. Docs: https://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/ConnectionHandler.html#method-i-establish_connection

for 1:

 SqlQuery.new(:get_player_by_email, email: 'e@mail.dev', db_connection: ActiveRecord::Base.establish_connection(:development).connection)

for 2:

 SqlQuery.new(:get_player_by_email, email: 'e@mail.dev', db_connection: ActiveRecord::Base.establish_connection({database: '', host: , adapter: .....}).connection)

[fchampreux]

@sufleR I'll search in this direction and document it when done. Thanks ! Le dim. 7 mars 2021 à 00:44, sufleR ***@***.***> a écrit :

…

@fchampreux <https://github.com/fchampreux> I don't know how do you use this gem. Is it ruby on rails application? What rails version? Rails guides mention about connected_to https://guides.rubyonrails.org/active_record_multiple_databases.html#using-manual-connection-switching Inside connected_to block, you should be able to SqlQuery.new(:get_player_by_email, email: ***@***.***', db_connection: ActiveRecord::Base.connection) and I think it should work with the connection selected in connected_to. I'm sorry but I didn't test it. With a custom connection, you should be able to call establish_connection. Docs: https://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/ConnectionHandler.html#method-i-establish_connection for 1: SqlQuery.new(:get_player_by_email, email: ***@***.***', db_connection: ActiveRecord::Base.establish_connection(:development).connection) for 2: SqlQuery.new(:get_player_by_email, email: ***@***.***', db_connection: ActiveRecord::Base.establish_connection({database: '', host: , adapter: .....}).connection) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#9 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAIPJLPFLQEMEFKTPA64HITTCK47HANCNFSM4YSUK7XQ> .

-- *Frédéric CHAMPREUX+41 78 87 110 55*