Model-less SQL results

rubyonrails-talk
1

I'm trying to get some stats from my database about my model, and I'm not sure how to go about it.

If I have a model 'foo' that has an attribute 'color' and I want to get some counts on this I could use the sql:

SELECT color, COUNT(*) AS count FROM items GROUP BY status

which would return something like:

2

Ahh! That was exactly the thing I was looking for!

I ended up digging through the docs and playing with the console to do it the hard way using connection.execute(sql) and then putting the result into a hash. Somehow I'd forgotten that there was an easy way....