Class: Lookout::RegionQuery

Inherits:
ApplicationQuery show all
Defined in:
app/queries/lookout/region_query.rb

Instance Attribute Summary

Attributes inherited from ApplicationQuery

#params

Instance Method Summary collapse

Methods inherited from ApplicationQuery

call, inherited, #initialize, #inspect

Constructor Details

This class inherits a constructor from Lookout::ApplicationQuery

Instance Method Details

#build ⇒ Object 



3
4
5
6
7
8
9
10
11
12
 
# File 'app/queries/lookout/region_query.rb', line 3

def build
  # Use database-agnostic concat
  concat_expr = Lookout::DatabaseAdapter.concat('region', 'country')
  
  visit_query
    .reselect("region, country, count(#{concat_expr}) as count, sum(count(region)) over() as total_count")
    .where.not(region: nil)
    .group("region, country")
    .order(Arel.sql "count(#{concat_expr}) desc")
end