Ruby on rails - how to retrieve connection strings

Question

Are there any ways to retrieve the database connection string where my ruby is connected? what i would like to get is the:

1) Database name where the ruby is connected 2) The username of the SQL Server 3) Password of the SQL Server 4) Server name

I want to store it in session variables.

(I'am using MS SQL Server.)

Please help! thanks!

Answer 1

I would go with ActiveRecord::Base.connection_config which returns hash with options for ActiveRecord 3.

Answer 2

You can access all of the properties described in your database.yaml like this:

ActiveRecord::Base.configurations["development"] => 
{"encoding"=>"utf8", "username"=>"foo", "adapter"=>"mysql", "database"=>"bar_development", "host"=>"localhost", "password"=> "baz"}