Combining the results of multiple Thinking Sphinx queries into a single paginated result

Question

Is there a simple way to combine the results of multiple Thinking Sphinx searches into a single result? All of these searches are on the same model, but the searches have distinct search terms. What I'm trying to do is combine the results so that they can all be sorted by a date column and receive proper pagination.

Say I have a Thinker class and an Idea class.

class Thinker < ActiveRecord::Base
  has_many :ideas
end

class Idea < ActiveRecord::Base
  belongs_to :thinker

  define_index do
    indexes text
    has created_at
  end
end

And say I have two thinkers, Bob, and Alice. I want to combine the following searches:

bob.ideas.search 'pancakes', :order => :created_at, :sort_mode => :desc
alice.ideas.search 'waffles', :order => :created_at, :sort_mode => :desc

...and somehow combine them so that the collection of Bob's (pancake) and Alice's (waffle) ideas are mixed together, sorted by descending created_at, and properly paginated by Thinking Sphinx. In the actual use case, I could have anywhere between 2 and 15 searches to combine in this fashion.

I know that the search method returns a ThinkingSphinx::Search < Array. I thought about manually splicing these objects together, but the fact that I'm looking for both sorting and pagination makes this a bit tricky.

Is there an elegant way to do this in Thinking Sphinx or am I not missing anything and I pretty much have to roll my own?

Answer 1

Thinking Sphinx work with Kaminari. So you already have kaminari in your gemfile. You just have to do :

result = bob.ideas.search 'pancakes', :order => :created_at, :sort_mode => :desc
result += alice.ideas.search 'waffles', :order => :created_at, :sort_mode => :desc

Result is no longer a ThinkingSphinx::Search. It's an array

result = Kaminari.paginate_array(result)

Your can use pagination and simple sort on result