Searcher
Searcher is a pure SQL implementation which lets you find by pre-defined labels, as well as wildcard matching queries. It should be used as a lo-fi precursor to a proper full-text search platform, such as the built-in one to PostgreSQL.
The idea of this gem came from Joost Schuur.
This gem is used in Chapter 10 of Rails 3 in Action and was crafted specifically for it. YMMV.
Installation
This gem is only compatible with versions of Active Record that are greater than or equal to 3.0. You are using Active Record 3, right?
Add this gem to your Gemfile (You are using Bundler, right?):
gem 'searcher'
Usage
To define labels for your field, use the searcher
method inside your model like this:
class Ticket < ActiveRecord::Base
has_and_belongs_to_many :tags
searcher do
label :tag, :from => :tags, :field => "name"
label :state, :from => :state, :field => "name"
end
end
To query for these labels, use the search
class method on your model:
Ticket.search("tag:v3.0.0 state:open")
Boom! There's all your tickets that have the tag v3.0.0 and are marked (state-wise) as being open.
Caveats
Currently Searcher works only with has_and_belongs_to_many
and belongs_to
associations, as that is all that is needed in the book.