SearchQd extends ActiveRecord and offers a method called search_qd for a simple full text search. Simple because the search functionality is executed as SQL LIKE statements for given (text) columns.
gem install search_qd
- Rails 3
Add the following line to your Gemfile
- ActiveRecord outside of Rails
require 'search_qd' ActiveRecord::Base.send(:include, SearchQd)
Assuming your model name is Blog and the model has two text columns title and content:
class Blog < ActiveRecord::Base search_qd_columns :title, :content end # search for 'some text to search for' in title and content column Blog.search_qd("some text to seach for") # search for 'some text to search for' in title column Blog.search_qd("some text to search for", ["title"]) # search for 'some text to search for' in user_name or title column Blog.search_qd("some text to search for", ["user_name", "title"])
As shown in the example above the search_qd method expects the search query as a string and a list of columns. If no list of columns is given, the search_qd method uses the column list defined by search_qd_columns (see class Blog definition).
- Ruby 1.9.*
This gem is created by Karsten Gallinowski and released under the MIT License.