Contents

require 'spec_helper'
require 'conceptql/nodes/date_range'

describe ConceptQL::Nodes::DateRange do
  it 'behaves itself' do
    ConceptQL::Nodes::DateRange.new.must_behave_like(:evaluator)
  end

  describe '#types' do
    it 'should be [:date]' do
      ConceptQL::Nodes::DateRange.new(start: '2004-12-13', end: '2010-03-20').types.must_equal([:person])
    end
  end

  describe '#query' do
    it 'should be dates specified assigned to all persons' do
      ConceptQL::Nodes::DateRange.new(start: '2004-12-13', end: '2010-03-20').query(Sequel.mock).sql.must_equal("SELECT * FROM (SELECT *, CAST('2004-12-13' AS date) AS start_date, CAST('2010-03-20' AS date) AS end_date FROM person) AS t1")
    end

    it 'should handle strings for option keys' do
      ConceptQL::Nodes::DateRange.new('start' => '2004-12-13', 'end' => '2010-03-20').query(Sequel.mock).sql.must_equal("SELECT * FROM (SELECT *, CAST('2004-12-13' AS date) AS start_date, CAST('2010-03-20' AS date) AS end_date FROM person) AS t1")
    end

    it 'handles START as day before first recorded visit_occurrence' do
      ConceptQL::Nodes::DateRange.new(start: 'START', end: '2010-03-20').query(Sequel.mock).sql.must_equal("SELECT * FROM (SELECT *, CAST((SELECT min(start_date) FROM visit_occurrence_with_dates) AS date) AS start_date, CAST('2010-03-20' AS date) AS end_date FROM person) AS t1")
    end

    it 'handles END as 2010-12-31' do
      ConceptQL::Nodes::DateRange.new(start: '2004-12-13', end: 'END').query(Sequel.mock).sql.must_equal("SELECT * FROM (SELECT *, CAST('2004-12-13' AS date) AS start_date, CAST((SELECT max(end_date) FROM visit_occurrence_with_dates) AS date) AS end_date FROM person) AS t1")
    end
  end

end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
conceptql-0.0.6	spec/conceptql/nodes/date_range_spec.rb
conceptql-0.0.5	spec/conceptql/nodes/date_range_spec.rb
conceptql-0.0.4	spec/conceptql/nodes/date_range_spec.rb
conceptql-0.0.3	spec/conceptql/nodes/date_range_spec.rb
conceptql-0.0.1	spec/conceptql/nodes/date_range_spec.rb