Skip to content

Instantly share code, notes, and snippets.

@tranvictor

tranvictor/gist:c83536916de5287d55b3c6d2a17ee5a4

Created September 2, 2017 06:10
Show Gist options
  • Save tranvictor/c83536916de5287d55b3c6d2a17ee5a4 to your computer and use it in GitHub Desktop.
Save tranvictor/c83536916de5287d55b3c6d2a17ee5a4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
rejected = User.where(approval: 'rejected').count
(15.6ms) SELECT COUNT(*) FROM "users" WHERE "users"."approval" = $1 [["approval", "rejected"]]
=> 630
2.4.1 :054 > rejected_by_artemis = User.where(approval: 'rejected', artemis_approval: 'rejected').count
(15.2ms) SELECT COUNT(*) FROM "users" WHERE "users"."approval" = $1 AND "users"."artemis_approval" = $2 [["approval", "rejected"], ["artemis_approval", "rejected"]]
=> 220
2.4.1 :055 > rejected_not_by_artemis = User.where(approval: 'rejected').where.not(artemis_approval: 'rejected').count
(19.2ms) SELECT COUNT(*) FROM "users" WHERE "users"."approval" = $1 AND ("users"."artemis_approval" != $2) [["approval", "rejected"], ["artemis_approval", "rejected"]]
=> 387
2.4.1 :056 > rejected_by_manual_check = User.where(approval: 'rejected', admin_approval: ['hard_reject', 'soft_reject']).count
(8.8ms) SELECT COUNT(*) FROM "users" WHERE "users"."approval" = $1 AND "users"."admin_approval" IN ('hard_reject', 'soft_reject') [["approval", "rejected"]]
=> 387
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment