Contents

module Pollyanna
  class Search

    def initialize(query, table_name)
      @words = (query || "").strip.downcase.split(/[\ \,\;]+/)
      @table_name = table_name
    end
    
    def scope_options(options = {})
      by = options && options.delete(:by)
      { :conditions => conditions_for_find(by) }
    end
  
  #  # Run the search on a Ruby collection
  #  def select(objects, &content_method)
  #    content_method ||= &:search_text
  #    objects.select do |object|
  #      content = content_method.call(object).andand.downcase || ""
  #      @words.all? { |word| content.include? word }
  #    end
  #  end

    private
    
    def conditions_for_find(by = nil)
      unless @words.empty?
        by ||= :search_text
        patterns = @words.collect { |word| "%#{escape_query_word word}%" }
        likes = ["#{@table_name}.#{by} LIKE ?"] * patterns.count
        [likes.join(" AND "), *patterns]
      end
    end
    
    def escape_query_word(word)
      word.gsub("%", "\\%").gsub("_", "\\_")
    end
    
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
pollyanna-1.0.4	lib/pollyanna/search.rb
pollyanna-1.0.3	lib/pollyanna/search.rb
pollyanna-1.0.2	lib/pollyanna/search.rb
pollyanna-1.0.1	lib/pollyanna/search.rb
pollyanna-1.0.0	lib/pollyanna/search.rb