Class ScopedSearch::QueryBuilder::OracleEnhancedAdapter
In: lib/scoped_search/query_builder.rb
Parent: ScopedSearch::QueryBuilder

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

Methods

sql_test  

Public Instance methods

[Source]

     # File lib/scoped_search/query_builder.rb, line 504
504:       def sql_test(field, operator, value, lhs, &block) # :yields: finder_option_type, value
505:         if field.key_field
506:           yield(:parameter, lhs.sub(/^.*\./,''))
507:         end
508:         if field.textual? && [:like, :unlike].include?(operator)
509:           yield(:parameter, (value !~ /^\%|\*/ && value !~ /\%|\*$/) ? "%#{value}%" : value.to_s.tr_s('%*', '%'))
510:           return "LOWER(#{field.to_sql(operator, &block)}) #{self.sql_operator(operator, field)} LOWER(?)"
511:         elsif field.temporal?
512:           return datetime_test(field, operator, value, &block)
513:         else
514:           yield(:parameter, value)
515:           return "#{field.to_sql(operator, &block)} #{self.sql_operator(operator, field)} ?"
516:         end
517:       end

[Validate]