Rails - Mar 2006 - custom sql queries beyond CRUD

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

-- 
Posted via http://www.ruby-forum.com/.

On 3/2/06, Tuka Opaleye <tuka@yorn.net> wrote:
> 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.
>
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.

Thanks a lot, this helps
Cheers
tuka

-- 
Posted via http://www.ruby-forum.com/.