Rails - Jun 2005 - Running general purpose queries

Hi,

I''m considering migrating my site from php to RoR.  I''ve
installed RoR gone
through the onlamp tutorials and made the recipie/todo list sample sites and 
tinkered with a few of my own.  I understand the examples that use models 
and scaffolding to map tables, but I''m having a little trouble
understanding
how to handle general purpose queries.   A few people have said "with rails
I never need to" but either my cases are special or I just don''t
"get it"
yet.

For example, my existing site runs the mysql query SHOW PROCESSLIST, 
captures the output in a recordset and dumps it to html.  Another example is 
user management where I issue grant statements "GRANT ALL ON dbname.* to 
user%''*'' IDENTIFIED BY ''abcdefg''", and
this merely executes and does not
return a record set.

I''m absolutely sure there is a way to do this in RoR, but I
haven''t seen it
yet (I probably need to read the API more thoroughly).  Can anyone point me 
in the general direction?


Thanks much

Gary

Digging a little deeper I found the wiki entry 
http://wiki.rubyonrails.com/rails/show/HowtoQueryTheDatabaseDirectly
and I think this will work for me.

Thanks,

Gary
----- Original Message ----- 
From: "Gary Huntress"
<ghuntress-Wuw85uim5zDR7s880joybQ@public.gmane.org>
To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org>
Sent: Saturday, June 18, 2005 8:51 AM
Subject: [Rails] Running general purpose queries

>
> Hi,
>
> I''m considering migrating my site from php to RoR.  I''ve
installed RoR
> gone through the onlamp tutorials and made the recipie/todo list sample 
> sites and tinkered with a few of my own.  I understand the examples that 
> use models and scaffolding to map tables, but I''m having a little
trouble
> understanding how to handle general purpose queries.   A few people have 
> said "with rails I never need to" but either my cases are special
or I
> just don''t "get it" yet.
>
> For example, my existing site runs the mysql query SHOW PROCESSLIST, 
> captures the output in a recordset and dumps it to html.  Another example 
> is user management where I issue grant statements "GRANT ALL ON
dbname.*
> to user%''*'' IDENTIFIED BY
''abcdefg''", and this merely executes and does
> not return a record set.
>
> I''m absolutely sure there is a way to do this in RoR, but I
haven''t seen
> it yet (I probably need to read the API more thoroughly).  Can anyone 
> point me in the general direction?
>
>
> Thanks much
>
> Gary
>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>