How to get the sphinx ql expression?

[joshweir]

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?

Thanks

Josh

[pat]

Hi Josh

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.