Contents

module Storytime
  class PostgresSearchAdapter
    def self.search(search_string, search_model=Storytime::Post)
      search_terms = search_string.gsub(" ", " & ")

      search_model.where("to_tsvector(coalesce(title, '') || ' ' || coalesce(content, '')) @@ to_tsquery(?)", "#{search_terms}")
    end
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
storytime-2.1.6	lib/storytime/postgres_search_adapter.rb
storytime-2.1.5	lib/storytime/postgres_search_adapter.rb
storytime-2.1.4	lib/storytime/postgres_search_adapter.rb
storytime-2.1.3	lib/storytime/postgres_search_adapter.rb
storytime-2.1.2	lib/storytime/postgres_search_adapter.rb
storytime-2.1.1	lib/storytime/postgres_search_adapter.rb
storytime-2.1.0	lib/storytime/postgres_search_adapter.rb
storytime-2.0.0	lib/storytime/postgres_search_adapter.rb
storytime-1.2.0	lib/storytime/postgres_search_adapter.rb
storytime-1.1.1	lib/storytime/postgres_search_adapter.rb