Contents

# encoding: utf-8

require 'spec_helper'

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

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

  context 'and the left attribute is optional' do
    let(:attribute)  { Attribute::Integer.new(:age, :required => false) }
    let(:inequality) { attribute.ne(1)                                  }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('("age" <> 1 OR "age" IS NULL)') }
  end

  context 'and the right attribute is optional' do
    let(:attribute)  { Attribute::Integer.new(:age, :required => false)  }
    let(:inequality) { Function::Predicate::Inequality.new(1, attribute) }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('(1 <> "age" OR "age" IS NULL)') }
  end

  context 'and the left is a value' do
    let(:attribute)  { Attribute::Integer.new(:id)                       }
    let(:inequality) { Function::Predicate::Inequality.new(1, attribute) }

    it_should_behave_like 'a generated SQL expression'

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

  context 'and the right is a value' do
    let(:attribute)  { Attribute::Integer.new(:id) }
    let(:inequality) { attribute.ne(1)             }

    it_should_behave_like 'a generated SQL expression'

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

  context 'and the right is a nil value' do
    let(:attribute)  { Attribute::Integer.new(:id) }
    let(:inequality) { attribute.ne(nil)           }

    it_should_behave_like 'a generated SQL expression'

    its(:to_s) { should eql('"id" IS NOT NULL') }
  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_inequality_spec.rb
veritas-sql-generator-0.0.6	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_inequality_spec.rb
veritas-sql-generator-0.0.5	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_inequality_spec.rb
veritas-sql-generator-0.0.4	spec/unit/veritas/sql/generator/function/predicate/visit_veritas_function_predicate_inequality_spec.rb