Select multiple counts from Postgres table, convert to Ruby object

Question

Given the following select:

SELECT 
  COUNT(*) AS total,
  SUM(CASE approved WHEN 't' THEN 1 ELSE 0 END) AS num_approved,
  SUM(CASE soft_delete WHEN 't' THEN 1 ELSE 0 END) AS num_deleted
FROM model_name;

How might I translate this into something in my class ModelName definition, so that I can retrieve the values of total, num_approved, and num_deleted in my Rails application? I'm happy with any output (array, hash, accessors on a ModelName object) that puts the numbers at the Ruby level.

Bijan · Accepted Answer · 2013-10-20 19:39:03Z

1

result = ModelName.select("
  COUNT(*) AS total, 
  SUM(CASE approved WHEN 't' THEN 1 ELSE 0 END) AS num_approved,
  SUM(CASE soft_delete WHEN 't' THEN 1 ELSE 0 END) AS num_deleted
").first

irb(main):278:0> result.total
=> 3041
irb(main):279:0> result.num_approved
=> 199464763
irb(main):280:0> result.num_deleted
=> #<BigDecimal:7fa0b7d79fd8,'0.19365329E8',9(18)>

answered Oct 20, 2013 at 19:39

Bijan

6,7926 gold badges35 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

asfallows Over a year ago

Will try this when I get in to work tomorrow. Thanks for the suggestion!

Collectives™ on Stack Overflow

Select multiple counts from Postgres table, convert to Ruby object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related