class PostgresqlCaseInsensitiveTest

Public Instance Methods

test_case_insensitiveness() click to toggle source
# File activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb, line 8
def test_case_insensitiveness
  connection = ActiveRecord::Base.connection
  table = Default.arel_table

  column = Default.columns_hash["char1"]
  comparison = connection.case_insensitive_comparison table, :char1, column, nil
  assert_match(/lower/i, comparison.to_sql)

  column = Default.columns_hash["char2"]
  comparison = connection.case_insensitive_comparison table, :char2, column, nil
  assert_match(/lower/i, comparison.to_sql)

  column = Default.columns_hash["char3"]
  comparison = connection.case_insensitive_comparison table, :char3, column, nil
  assert_match(/lower/i, comparison.to_sql)

  column = Default.columns_hash["multiline_default"]
  comparison = connection.case_insensitive_comparison table, :multiline_default, column, nil
  assert_match(/lower/i, comparison.to_sql)
end