Class: Lookout::SourceQuery

Inherits:
ApplicationQuery show all
Defined in:
app/queries/lookout/source_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
 
# File 'app/queries/lookout/source_query.rb', line 3

def build
  expr = Lookout::DatabaseAdapter.domain_from("referring_domain")
  visit_query.select("#{expr} as referring_domain, count(#{expr}) as count, sum(count(#{expr})) OVER() as total_count")
             .where.not(referring_domain: nil)
             .group(expr)
             .order(Arel.sql "count(#{expr}) desc")
end