override the database.lyml

[masuk]

hi...

i'm trying to override the database.yml. is it possible to insert a variable there, lets say the username and the password?

thanks!!!!

[samsm]

<%= %> tags seem to work, giving you access to whatever Ruby you wanted to throw into database.yml.

[masuk]

hi....

i tried smthg like this
username: <%= @session[:user].login %>
but i still got the error messg "rails could not connect to your database."

thanks 4 ur help

[Luke Redpath]

You won't be able to access anything in the normal Rails environment in your database.yml file - all you'll be able to use is normal Ruby.

[masuk]

sorry, but i didn't get it.
do i hv to do it in the controller?

[Luke Redpath]

sorry, but i didn't get it.
do i hv to do it in the controller?

I'm not really sure if you can (or why you would want to) do what you are trying to do. You connect to your database and that is it. There are ways of connecting to more than database if you need to but to dynamically connect to a database the only thing you could do was wire the activerecord connection statement into one of your models, replacing actual values with class attributes (@@some_class_var) and setting those in your application controller.

# in application.rb
MyFancyModel.db_user = 'foo'
MyFancyModel.db_pass = 'bar'

class MyFancyModel < ActiveRecord::Base
  establish_connection(
    :adapter => 'mysql',
    :username => @@db_user,
    :password => @@db_pass
  )
end

The above is just an example and I haven't tested it!

You could then create models that use the above connection by extending MyFancyModel instead of AR::Base.

http://api.rubyonrails.com/classes/A...e.html#M000797