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

class TestSearchgasmConditions < Test::Unit::TestCase
  fixtures :accounts, :users, :orders
  
  def setup
    setup_db
    load_fixtures
  end
  
  def teardown
    teardown_db
  end
  
  def test_initialize
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account, :name_contains => "Binary")
    assert_equal conditions.klass, Account
    assert_equal conditions.name_contains, "Binary"
  end
  
  def test_setting_conditions
    [Account, User, Order].each do |klass|
      conditions = BinaryLogic::Searchgasm::Search::Conditions.new(klass)
      
      klass.columns.each do |column|
        value = column_value(column)
        BinaryLogic::Searchgasm::Search::Conditions.condition_types_for_column_type(column.type).each do |condition_type|
          name = BinaryLogic::Searchgasm::Search::Condition.generate_name(column, condition_type)
          conditions.send("#{name}=", value)
          assert_equal conditions.send(name), value
          BinaryLogic::Searchgasm::Search::Conditions.aliases_for_condition(column, condition_type).each do |alias_condition|
            conditions.send("#{alias_condition}=", value)
            assert_equal conditions.send(alias_condition), value
          end
        end
      end
    end
  end
  
  def test_setting_associations
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account, :users => {:first_name_like => "Ben"})
    assert_equal conditions.users.first_name_like, "Ben"
    
    conditions.users.last_name_begins_with = "Ben"
    assert_equal conditions.users.last_name_begins_with, "Ben"
  end
  
  def test_includes
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account)
    assert_equal conditions.includes, nil
    
    conditions.name_like = "Binary"
    assert_equal conditions.includes, nil
    
    conditions.users.first_name_like = "Ben"
    assert_equal conditions.includes, :users
    
    conditions.users.orders.description_like = "apple"
    assert_equal conditions.includes, {:users => :orders} 
  end
  
  def test_objects
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account)
    assert_equal conditions.objects, []
    
    conditions.name_contains = "Binary"
    assert_equal conditions.objects.size, 1
    
    conditions.users.first_name_contains = "Ben"
    assert_equal conditions.objects.size, 2
  end
  
  def test_reset
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account)
    
    conditions.name_contains = "Binary"
    assert_equal conditions.objects.size, 1
    
    conditions.reset_name_contains!
    assert_equal conditions.objects, []
    
    conditions.users.first_name_like = "Ben"
    assert_equal conditions.objects.size, 1
    
    conditions.reset_users!
    assert_equal conditions.objects, []
    
    conditions.name_begins_with ="Binary"
    conditions.users.orders.total_gt = 200
    conditions.users.first_name_keywords = "Silly name"
    conditions.reset!
    assert_equal conditions.objects, []
  end
  
  def test_sanitize
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account)
    conditions.name_contains = "Binary"
    conditions.id_gt = 5
    now = Time.now
    conditions.created_after = now
    assert_equal conditions.sanitize, ["(\"accounts\".\"name\" LIKE ?) AND (\"accounts\".\"id\" > ?) AND (\"accounts\".\"created_at\" > ?)", "%Binary%", 5, now]
    
    # test out associations
    conditions.users.first_name_like = "Ben"
    conditions.users.id_gt = 10
    conditions.users.orders.total_lt = 500
    assert_equal conditions.sanitize, ["(\"accounts\".\"name\" LIKE ?) AND (\"accounts\".\"id\" > ?) AND (\"accounts\".\"created_at\" > ?) AND ((\"users\".\"first_name\" LIKE ?) AND (\"users\".\"id\" > ?) AND (\"orders\".\"total\" < ?))", "%Binary%", 5, now, "%Ben%", 10, 500]
  end
  
  def test_value
    conditions = BinaryLogic::Searchgasm::Search::Conditions.new(Account)
    now = Time.now
    conditions.value = {:name_like => "Binary", :created_at_after => now}
    assert_equal conditions.value, {:name_contains => "Binary", :created_at_greater_than => now}
    
    conditions.value = "id in (1,2,3,4)"
    assert_equal conditions.value, {}
    assert_equal conditions.scope, "id in (1,2,3,4)"
  end
  
  def test_protection
    assert_raise(ArgumentError) { Account.new_conditions("(DELETE FROM users)") }
    assert_nothing_raised { Account.build_conditions!("(DELETE FROM users)") }
    
    account = Account.first
    
    assert_raise(ArgumentError) { account.users.build_conditions("(DELETE FROM users)") }
    assert_nothing_raised { account.users.build_conditions!("(DELETE FROM users)") }
  end
  
  private
    def column_value(column)
      case column.type
      when :string, :text, :binary
        Array.new(50) { (rand(122-97) + 97).chr }.join
      when :integer
        rand(99999)
      when :float, :decimal
        rand * 100
      when :datetime, :timestamp, :time
        Time.now
      when :date
        Date.today
      end
    end
end