How to output the name of the db

rubyonrails-talk
1

You can grab a raw connection from an ActiveRecord based model object and ask it nicely:

aro.connection.adapter_name => “MySQL”

2

I've been able to grab the current values for migrations using the following:

ActiveRecord::Base.connection.instance_values['config'][:database] ActiveRecord::Base.connection.instance_values['config'][:host] ActiveRecord::Base.connection.instance_values['config'][:username] ActiveRecord::Base.connection.instance_values['config'][:password]

Using those I can do a system call to run the command line mysql binary to import SQL data into newly created tables that are mostly used for static lookup tables that rarely change. When we get a new dump file I reload the sites manually and then check the new SQL dump file into SVN so that anyone doing a migrate will load the latest copy.

    # use current values from database.yml (already loaded into ActiveRecord)     host = ActiveRecord::Base.connection.instance_values['config'][:host]     username = ActiveRecord::Base.connection.instance_values['config'][:username]     password = ActiveRecord::Base.connection.instance_values['config'][:password]     database = ActiveRecord::Base.connection.instance_values['config'][:database]

    system "mysql -h#{host} -u#{username} -p#{password} #{database} " +       "<db/zipcodes.import.sql"

David

Steve Longdo wrote: