Search Across Multiple Models in Rails

In this tutorial you'll learn how to search across multiple models in Rails. Below is a demo of what we'll be building. Note how both Post and User records appear in the search. As an added bonus, we highlight the search query in the results.

Step 1: Set Up

Create a new Rails application.

rails new rails-search-across-multiple-models

Generate a Post and User Scaffold.

rails g scaffold Post title body:text
rails g scaffold User name biography:text

Step 2: Create a Model to Store Search Entries

Create a SearchEntry model and run migrations.

rails g model SearchEntry title body:text searchable:references{polymorphic}
rails db:migrate

Convert the SearchEntry model to a Delegated Type.

# app/models/search_entry.rb
class SearchEntry < ApplicationRecord
  delegated_type :searchable, types: %w[ Post User ]
end

What's Going On Here?

We give the model a title and a body to standardize what columns we will be able to search against. This is the actual model that will be searched.

The model will connect other models through a polymorphic association. This means we can make any model searchable.

We use a delegated type to connect the SearchEntry model with the Post and User models.

Create a Searchable Concern.

# app/models/concerns/searchable.rb
module Searchable
  extend ActiveSupport::Concern

  included do
    has_one :search_entry, as: :searchable, touch: true
  end    
end

# app/models/post.rb
class Post < ApplicationRecord
  include Searchable
end

# app/models/user.rb
class User < ApplicationRecord
  include Searchable
end

What's Going On Here?

We create a concern to be shared across the Post and User model. This is not required, but helps keep our code DRY.

The concern is simply connecting the Post and User models to the SearchEntry model. When the Post or User models are updated, the associated SearchEntry model will have its updated_at column updated. This is because we're calling touch: true. That part is not required, but helps keep things consistent between models.

Step 3: Prevent Duplicate SearchEntry Records

Add a uniquness scope to the SearchEntry model.

# app/models/search_entry.rb 
class SearchEntry < ApplicationRecord
  delegated_type :searchable, types: %w[ Post User ]

  validates :searchable_type, uniqueness: { scope: :searchable_id }
end

What's Going On Here?

We add a uniqueness scope to prevent a Post or User from having multiple SearchEntry records associated with them. This will prevent duplicate search results.

Step 4: Use Callbacks to Dynamically Create, Update and Destroy SearchEntry Records.

Add the following callbacks to the Post and User models.

# app/models/post.rb
class Post < ApplicationRecord
  include Searchable

  after_commit :create_search_entry, on: :create
  after_commit :update_search_entry, on: :update
  after_commit :destroy_search_entry, on: :destroy

  private

    def create_search_entry
      SearchEntry.create(title: self.title, body: self.body, searchable: self)
    end

    def update_search_entry
      self.search_entry.update(title: self.title, body: self.body) if self.search_entry.present?
    end

    def destroy_search_entry
      self.search_entry.destroy if self.search_entry.present?
    end
end

# app/models/user.rb
class User < ApplicationRecord
  include Searchable

  after_commit :create_search_entry, on: :create
  after_commit :update_search_entry, on: :update
  after_commit :destroy_search_entry, on: :destroy

  private

    def create_search_entry
      SearchEntry.create(title: self.name, body: self.biography, searchable: self)
    end

    def update_search_entry
      self.search_entry.update(title: self.name, body: self.biography) if self.search_entry.present?
    end

    def destroy_search_entry
      self.search_entry.destroy if self.search_entry.present?
    end    
end

What's Going On Here?

We use callbacks to create, update and destroy an associated SearchEntry record per Post and User. This ensures that the associated SearchEntry will always be in sync with the source model.

We set the title and body columns on the SearchEntry to whatever values make most sense. This allows us to have full control over what will be able to be searched. Note that we can pass whatever we want into the title and body columns.

Step 5: Create the Search Form

Create a SearchEntries Controller.

rails g controller SearchEntries index

Add a route for the search form and root path.

# config/routes.rb
Rails.application.routes.draw do
  root to: 'search_entries#index'
  get 'search_entries/index', as: 'search'
  ...
end

Build the search endpoint.

# app/controllers/search_entries_controller.rb
class SearchEntriesController < ApplicationController
  def index
    @search_entries = SearchEntry.where("title LIKE ? OR body LIKE ?", "%#{params[:query]}%", "%#{params[:query]}%") if params[:query]
  end
end

What's Going On Here?

We query for any SearchEntry record that has a title or body containing the search query.

We add the if params[:query] conditional to prevent any results from being rendered until a user makes a search query. This is optional.

Build the search form and search partial.

# app/views/search_entries/index.html.erb
<%= form_with url: :search, method: :get do |form| %>
  <%= form.label :query, "Search for:" %>
  <%= form.text_field :query %>
  <%= form.submit "Search" %>
  <%= link_to "Reset", search_path %>
<% end %>
<%= render partial: "search_entries/search_entry", collection: @search_entries %>

# app/views/search_entries/_search_entry.html.erb
<%= link_to polymorphic_path search_entry.searchable do %>
  <h2><%= highlight search_entry.title, params[:query] %></h2>
  <span><strong><%= search_entry.searchable_type %></strong></span>
  <p><%= highlight search_entry.body, params[:query] %></p>
  <hr/>
<% end %>

What's Going On Here?

We create a simple search form that will hit search_entries#index. The form.text_field :query field simply passes the correct parameter into the URL.

We create a simple partial to render the search result. We use the polymorphic_path method to link to the correct model (Post or User).

We use the highlight method to highlight the string being searched.

Did you like this post? Follow me on Twitter to get even more tips.