class ScopedSearch::QueryBuilder::OracleEnhancedAdapter

The Oracle adapter also requires some tweaks to make the case insensitive LIKE work.

Public Instance Methods

sql_test(field, operator, value, lhs) { |finder_option_type, value| ... } click to toggle source
# File lib/scoped_search/query_builder.rb, line 472
def sql_test(field, operator, value, lhs, &block) # :yields: finder_option_type, value
  if field.key_field
    yield(:parameter, lhs.sub(%r^.*\./,''))
  end
  if field.textual? && [:like, :unlike].include?(operator)
    yield(:parameter, (value !~ %r^\%|\*/ && value !~ %r\%|\*$/) ? "%#{value}%" : value.to_s.tr_s('%*', '%'))
    return "LOWER(#{field.to_sql(operator, &block)}) #{self.sql_operator(operator, field)} LOWER(?)"
  elsif field.temporal?
    return datetime_test(field, operator, value, &block)
  else
    yield(:parameter, value)
    return "#{field.to_sql(operator, &block)} #{self.sql_operator(operator, field)} ?"
  end
end