Winn.ws

Magic Multi-Connections

This plug-in is a great one! I have found a few bugs but it did the job just as i needed it to. I am using this plug-in to connect to three databases, where i am selecting, updating, inserting, and deleting. By adding this plug-in i was able to set my databases in the database.yml file and name them as i wanted. Next i adding two modules to my environment.rb file. After that i was able to connect to each of the databases with ease.

Below is how my database.yml file looks:

[ruby]
databaseone:
adapter: mysql
database: one
username: root
password:
host: localhost

databasetwo:
adapter: mysql
database: two
username: root
password:
host: localhost

production:
adapter: mysql
database: three
username: root
password:
host: localhost
[/ruby]

Now in my environment.rb file i have:

[ruby]
module Dbone
establish_connection :databaseone
end
module Dbtwo
establish_connection :databasetwo
end
[/ruby]

Now if i would like to select from my database one i do the following in any controller:

[ruby]
def index
@users = Dbone::Users.find(:all)
end
[/ruby]

Get the idea now? It’s the same to update and add to the database. Just use the module name. Now for the “production” database everything remains the same, no need to add a module to it.

Get Magic Multi-Connections V1

posted in: Development 03.25.08