Class: ConceptQL::Operators::Sum

Inherits:
PassThru show all
Defined in:
lib/conceptql/operators/sum.rb

Constant Summary

Constants inherited from Operator

Operator::COLUMNS

Instance Attribute Summary

Attributes inherited from Operator

#arguments, #options, #upstreams, #values

Instance Method Summary collapse

Methods inherited from PassThru

#types

Methods inherited from Operator

#columns, #evaluate, #initialize, #label, #select_it, #set_values, #sql, #stream, #types

Methods included from Metadatable

#allows_many_upstreams, #allows_one_upstream, #argument, #category, #desc, #humanized_class_name, #inherited, #just_class_name, #option, #predominant_types, #preferred_name, #reset_categories, #to_metadata, #types

Constructor Details

This class inherits a constructor from ConceptQL::Operators::Operator

Instance Method Details

#query(db) ⇒ Object 



11
12
13
14
15
16
17
18
19
 
# File 'lib/conceptql/operators/sum.rb', line 11

def query(db)
  db.from(unioned(db))
    .select_group(*(COLUMNS - [:start_date, :end_date, :criterion_id, :value_as_number]))
    .select_append(Sequel.lit('?', 0).as(:criterion_id))
    .select_append{ min(start_date).as(:start_date) }
    .select_append{ max(end_date).as(:end_date) }
    .select_append{sum(value_as_number).as(:value_as_number)}
    .from_self
end

#unioned(db) ⇒ Object 



21
22
23
24
25
 
# File 'lib/conceptql/operators/sum.rb', line 21

def unioned(db)
  upstreams.map { |c| c.evaluate(db) }.inject do |uni, q|
    uni.union(q)
  end
end