Finding popular searches?

[rlam3]

How to obtain popular searches from a particular type of object. Specifically say for example the search is supposed to return a list of Car objects. What would the query look like to return the top searches?

x = Car.pure_whoosh('Aud*')

print x
<Top 1 Results for Or([Prefix('display_name', u'au'), Prefix('description', u'au'), Prefix('name', u'au')]) runtime=0.00333499908447>

x

x.collector             x.extend                x.has_exact_length      x.order                 x.searcher
x.copy                  x.facet_names           x.has_matched_terms     x.q                     x.top_n
x.docnum                x.fields                x.highlighter           x.query_terms           x.upgrade
x.docs                  x.filter                x.is_empty              x.runtime               x.upgrade_and_extend
x.docset                x.formatter             x.items                 x.score                 
x.estimated_length      x.fragmenter            x.key_terms             x.scored_length         
x.estimated_min_length  x.groups                x.matched_terms         x.scorer                

I cannot find how how to get the Car primary key or the top search results back or the car objects from x variable. Any suggestions would help

[arthurbarros]

+1

[rlam3]

I'm looking for an sqlalchemy solution not a Pony solution.