Class: ConceptQL::Operators::DateRange

Inherits:
Operator
  • Object
show all
Defined in:
lib/conceptql/operators/date_range.rb

Overview

Represents a operator that will create a date_range for every person in the database

Accepts two params: start and end formateed as ‘YYYY-MM-DD’ or ‘START’ or ‘END’ ‘START’ represents the first date of data in the data source, ‘END’ represents the last date of data in the data source,

Instance Attribute Summary

Attributes inherited from Operator

#arguments, #errors, #nodifier, #options, #upstreams, #values

Instance Method Summary collapse

Methods inherited from Operator

#annotate, #cast_column, #code_list, codes_should_match, #columns, #create_upstreams, #data_model, #database_type, default_query_columns, #dup_values, #dynamic_columns, #evaluate, inherited, #initialize, #inspect, #label, new, #operator_name, #optimized, query_columns, register, require_column, #required_columns, #scope, #select_it, #setup_select, #sql, #stream, #to_op, #unionable?, #upstreams_valid?, #valid?

Methods included from Metadatable

#allows_many_upstreams, #allows_one_upstream, #argument, #auto_label, #basic_type, #category, #derive_metadata_from_validations, #desc, #get_desc, #humanized_class_name, #inherited, #just_class_name, #no_desc, #option, #predominant_domains, #pref_name, #preferred_name, #reset_categories, #standard_description, #to_metadata, #validate_at_least_one_upstream_to_metadata, #validate_at_most_one_upstream_to_metadata, #validate_no_arguments_to_metadata, #validate_no_upstreams_to_metadata, #validate_one_upstream_to_metadata, #validate_required_options_to_metadata, #warn_about_missing_metadata

Constructor Details

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

Instance Method Details

#domains(db) ⇒ Object 



35
36
37
 
# File 'lib/conceptql/operators/date_range.rb', line 35

def domains(db)
  [:person]
end

#query(db) ⇒ Object 



27
28
29
30
31
32
33
 
# File 'lib/conceptql/operators/date_range.rb', line 27

def query(db)
  db.from(:person)
    .select_append(Sequel.cast_string('person').as(:criterion_domain))
    .select_append(Sequel.expr(:person_id).as(:criterion_id))
    .select_append(Sequel.as(cast_date(db, start_date(db)), :start_date),
                   Sequel.as(cast_date(db, end_date(db)), :end_date)).from_self
end

#query_cols ⇒ Object 



23
24
25
 
# File 'lib/conceptql/operators/date_range.rb', line 23

def query_cols
  table_columns(:person) + [:criterion_domain, :criterion_id, :start_date, :end_date]
end