Contents

# encoding: utf-8

require 'spec_helper'

describe SQL::Generator::Function::Predicate, '#visit_veritas_function_predicate_exclusion' do
  subject { object.visit_veritas_function_predicate_exclusion(exclusion) }

  let(:described_class) { Class.new(SQL::Generator::Visitor) { include SQL::Generator::Function::Predicate } }
  let(:attribute)       { Attribute::Integer.new(:id)                                                        }
  let(:object)          { described_class.new                                                                }

  before do
    described_class.class_eval { include SQL::Generator::Function::Connective }
  end

  context 'when right operand is an inclusive Range' do
    let(:exclusion) { attribute.exclude(1..10) }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('"id" NOT BETWEEN 1 AND 10') }
  end

  context 'when right operand is an exclusive Range' do
    let(:exclusion) { attribute.exclude(1...10) }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('("id" < 1 OR "id" >= 10)') }
  end

  context 'when right operand is an Array' do
    let(:exclusion) { attribute.exclude([ 1, 2 ]) }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('"id" NOT IN (1, 2)') }
  end

  context 'when right operand is an empty Array' do
    let(:exclusion) { attribute.exclude([]) }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('TRUE') }
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
veritas-sql-generator-0.0.7	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_exclusion_spec.rb
veritas-sql-generator-0.0.6	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_exclusion_spec.rb
veritas-sql-generator-0.0.5	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_exclusion_spec.rb
veritas-sql-generator-0.0.4	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_exclusion_spec.rb