#251 MetaWhere & MetaSearch

Jan 31, 2011 | 8 minutes | Rails 3.0, Plugins, Active Record, Forms, Search

MetaWhere provides a way to do complex find conditions without SQL in Active Record. MetaSearch makes it easy to create search forms with many find options.

Click to Play Video ▶

Download:
source codeProject Files in Zip (118 KB)
mp4Full Size H.264 Video (17 MB)
m4vSmaller H.264 Video (10.2 MB)
webmFull Size VP8 Video (25.4 MB)
ogvFull Size Theora Video (23.7 MB)

Browse Source Code

Resources

          Gemfile
        
gem "meta_where"
gem "meta_search"

          rails console
        
Product.where(:price.lt => 5)
Product.where({:price.lt => 5} | {:name.matches => "%video%"})
Product.order(:released_at.desc)
MetaWhere.operator_overload!
Product.where(:price < 5)

          products_controller.rb
        
def index
  @search = Product.search(params[:search])
  @products = @search.all
end

          products/index.html.erb
        
<%= form_for @search do |f| %>
  <p>
    <%= f.label :name_contains %>
    <%= f.text_field :name_contains %>
  </p>
  <p>
    <%= f.label :price_gte, "Price ranges from" %>
    <%= f.text_field :price_gte, :size => 8 %>
    <%= f.label :price_lte, "to" %>
    <%= f.text_field :price_lte, :size => 8 %>
  </p>
  <p class="button"><%= f.submit "Search" %></p>
<% end %>

<p>
  Sort by:
  <%= sort_link @search, :name %> |
  <%= sort_link @search, :price %> |
  <%= sort_link @search, :released_at %>
</p>