pg_search example

index.htm.erb

<div class="wrapper">
  <div class="row">
    <div class="col-md-12">
      <div class="box">

        <% unless @products.blank? %>
          <%= render 'search/products' %>
        <% end %>

        <% unless @vendors.blank? %>
          <%= render 'search/vendors' %>
        <% end %>

        </div> <!-- end box-content -->
    </div>
  </div>
</div>

migration.rb

class CreatePgSearchDocuments < ActiveRecord::Migration
  def self.up
    say_with_time("Creating table for pg_search multisearch") do
      create_table :pg_search_documents do |t|
        t.text :content
        t.belongs_to :searchable, :polymorphic => true, :index => true
        t.timestamps null: false
      end
    end
  end

  def self.down
    say_with_time("Dropping table for pg_search multisearch") do
      drop_table :pg_search_documents
    end
  end
end

product.rb

class Product < ActiveRecord::Base
  belongs_to :vendor

    include PgSearch
    pg_search_scope :search_including_tags,
                    :against => [:model, :description],
                    :using => {
                      :tsearch => {:prefix => true}
                    }
                    
  end
end

products_controller.rb

class ProductsController < ApplicationController
  
  def index
      if params[:search]
      elsif params[:id]
        @products = Product.find(params[:id])
      else
        @products = Product.all.order("created_at DESC").paginate(:page => params[:page], :per_page => 15)
        @product = Product.first
      end
  end
end

routes.rb

Rails.application.routes.draw do

  get '/search', to: 'search#index'
  
end

search_controller.rb

class SearchController < ApplicationController

  def new
    @products = Product.search_including_tags(params[:query]).paginate(:page => params[:page], :per_page => 15)
    @vendors = Vendor.search_including_tags(params[:query]).paginate(:page => params[:page], :per_page => 15)
  end
end