How can I use MySQL.new() inside one of my models without specifying
the specifics of the database connection?
So in one of my models I have something like:
m = Mysql.new("localhost","myuser","mypass","mydb")
r = m.query("SELECT <some complicated SQL joining......>")
How can I have that SQL statement line above use the global database
connection that I already have available to ActiveRecord?
I know another option is find_by_sql, like:
@somemodels = Somemodel.find_by_sql("SELECT <something
But I am not fetching objects with my SQL. According to the API, the
left-hand side of that statement must be model objects.
Am I right on this? Is there a way to use the global db settings
while using m = Mysql.new() so I don't have to write the user/pass/db
attributes inside the model?