Contents

require File.dirname(__FILE__) + '/../test_helper.rb'

module ConditionTests
  class BlankTest < ActiveSupport::TestCase
    def test_sanitize
      condition = Searchlogic::Condition::Blank.new(Account, :column => Account.columns_hash["id"])
      condition.value = "true"
      assert_equal "(\"accounts\".\"id\" IS NULL or \"accounts\".\"id\" = '' or \"accounts\".\"id\" = false)", condition.sanitize
    
      condition = Searchlogic::Condition::Blank.new(Account, :column => Account.columns_hash["id"])
      condition.value = "false"
      assert_equal "(\"accounts\".\"id\" IS NOT NULL and \"accounts\".\"id\" != '' and \"accounts\".\"id\" != false)", condition.sanitize
    
      condition = Searchlogic::Condition::Blank.new(Account, :column => Account.columns_hash["id"])
      condition.value = true
      assert_equal "(\"accounts\".\"id\" IS NULL or \"accounts\".\"id\" = '' or \"accounts\".\"id\" = false)", condition.sanitize
    
      condition = Searchlogic::Condition::Blank.new(Account, :column => Account.columns_hash["id"])
      condition.value = false
      assert_equal "(\"accounts\".\"id\" IS NOT NULL and \"accounts\".\"id\" != '' and \"accounts\".\"id\" != false)", condition.sanitize
    
      condition = Searchlogic::Condition::Blank.new(Account, :column => Account.columns_hash["id"])
      condition.value = nil
      assert_nil condition.sanitize
    
      condition = Searchlogic::Condition::Blank.new(Account, :column => Account.columns_hash["id"])
      condition.value = ""
      assert_nil condition.sanitize
    end
  end
end

Version data entries

5 entries across 5 versions & 2 rubygems

Version	Path
schof-searchlogic-0.0.2	test/condition_tests/blank_test.rb
searchlogic-1.6.1	test/condition_tests/blank_test.rb
searchlogic-1.6.4	test/condition_tests/blank_test.rb
searchlogic-1.6.3	test/condition_tests/blank_test.rb
searchlogic-1.6.2	test/condition_tests/blank_test.rb