In Count How Many Records There Are Of Each
Type, I walked
through how to use SQL (in PostgreSQL) to get a count of how many records there
are with each unique value in a given column. This is something I tend to do
with a type or status column.
We can ask the same question with Rails, with very little code. It produces a nearly identical query and the same results.
> Book.group(:status).count
#=> { nil => 123, "published" => 611, "draft" => 364, "review" => 239 }We've picked the Book model and we want it to group books by their status.
Tacking on the #count at the end tells it to apply the count aggregate. The
result is a hash of each unique value of the specified attribute (status)
paired with the count.