Contents

require_relative 'node'

module ConceptQL
  module Nodes
    # Represents a node 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,
    class DateRange < Node
      def query(db)
        db.from(:person)
          .select_append(Sequel.cast_string('person').as(:criterion_type))
          .select_append(Sequel.expr(:person_id).as(:criterion_id))
          .select_append(start_date(db).as(:start_date), end_date(db).as(:end_date)).from_self
      end

      def types
        [:person]
      end

      private
      def start_date(db)
        date_from(db, options[:start])
      end

      def end_date(db)
        date_from(db, options[:end])
      end

      # TODO: Select the earliest and latest dates of observation from
      # the proper CDM table to represent the start and end of data
      def date_from(db, str)
        return db.from(:visit_occurrence).select { min(:start_date) } if str.upcase == 'START'
        return db.from(:visit_occurrence).select { max(:end_date) } if str.upcase == 'END'
        return Sequel.lit('CONVERT(DATETIME, ?)', str) if db.database_type == :mssql
        return Sequel.lit('date ?', str)
      end
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
conceptql-0.1.1	lib/conceptql/nodes/date_range.rb
conceptql-0.1.0	lib/conceptql/nodes/date_range.rb
conceptql-0.0.9	lib/conceptql/nodes/date_range.rb