Custom sql queries beyond CRUD


#1

Hi,

I am just starting of in rails. I am trying to understand the features
of rails and I have this burning question. (and search is not available
now):

Apart from relying on the automatic CRUD sql script produced, is there a
way I can create my own sql script ex: with many joins between exixting
tables (for reporting ). All I need is to declare the custom query and
place the result in a recordset and then to display it somewhere.

Thanks also for any links to documentation that clarifies this.

TIA,
Tuka

PS: I dont program with ruby yet… but I can easily read any snippet
given… I think


#2

Thanks a lot, this helps
Cheers
tuka


#3

On 3/2/06, Tuka O. removed_email_address@domain.invalid wrote:

Thanks also for any links to documentation that clarifies this.

You can use the “direct” database selectors if you need them:
http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M000532
They are particularly useful for accessing DB-specific features that
you can’t get at through the normal connection adapters, or for
connecting to horrible legacy stored procedures.

Edge Rails also includes some very handy calculation features for
complex sum/partition statements.