ThinkingSphinx: How to get the sphinxql SQL expression?

Question

pancakes = Article.search 'pancakes'

How would I then get the resultant underlying sphinxql expression? Is it possible to just retrieve the expression without performing the query?

Answer 1

Answered by Pat on github:

To find the SphinxQL statement, you can do the following:

pancakes = Article.search 'pancakes'
pancakes.populate
pancakes.context[:sphinxql].to_sql

However, if you want to get that without actually sending the query to Sphinx, you'll want to send through a much more minimal middleware stack:

middleware = ::Middleware::Builder.new do
  use ThinkingSphinx::Middlewares::SphinxQL
end

pancakes = Article.search 'pancakes', :middleware => middleware
pancakes.populate
pancakes.context[:sphinxql].to_sql

You can also send the :populate => true option through as part of the search options instead of calling populate on the search object, to save a line of code. TS search results are lazily loaded, hence the need for that when accessing the context data.