require 'spec_helper'
require 'conceptql/nodes/casting_node'
require_double('stream_for_casting')

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

  class CastingDouble < ConceptQL::Nodes::CastingNode
    def my_type
      :my_type
    end

    def i_point_at
      [ :i_point1, :i_point2 ]
    end

    def these_point_at_me
      [ :at_me1, :at_me2 ]
    end
  end

  describe CastingDouble do
    it 'must behave' do
      CastingDouble.new.must_behave_like(:casting_node)
    end
  end

  describe '#query' do
    it 'uses person_ids when an uncastable type is encountered' do
      stream = StreamForCastingDouble.new
      stream.types = [:uncastable]
      sql = CastingDouble.new(stream).query(Sequel.mock).sql
      sql.must_match 'person_id IN'
      sql.must_match 'GROUP BY person_id'
      sql.must_match 'FROM table'
    end

    it 'uses person_ids when an uncastable type is included among castable types' do
      stream = StreamForCastingDouble.new
      stream.types = [:i_point1, :uncastable]
      sql = CastingDouble.new(stream).query(Sequel.mock).sql
      sql.must_match 'person_id IN'
      sql.must_match 'GROUP BY person_id'
    end

    it 'uses castable types if possible' do
      stream = StreamForCastingDouble.new
      stream.types = [:i_point1]
      sql = CastingDouble.new(stream).query(Sequel.mock).sql
      sql.must_match 'i_point1_id IN'
      sql.must_match "criterion_type = 'i_point1'"
    end

    it 'uses and unions multiple castable types if possible' do
      stream = StreamForCastingDouble.new
      stream.types = [:i_point1, :at_me2]
      sql = CastingDouble.new(stream).query(Sequel.mock).sql
      sql.must_match 'my_type_id IN'
      sql.must_match 'i_point1_id IN'
      sql.must_match "criterion_type = 'i_point1'"
    end

    it 'returns all rows of a table if passed the argument "true"' do
      sql = CastingDouble.new(true).query(Sequel.mock).sql
      sql.must_match "SELECT * FROM my_type AS tab"
    end
  end
end