facet.query issues

[nator]

I'm new to Python & Django, but pretty handy with Solr. I'm trying to facet on a query instead of just a field, so here's what I added:

diff --git a/sunburnt/search.py b/sunburnt/search.py
index 3eb0b6b..8aebaad 100644
--- a/sunburnt/search.py
+++ b/sunburnt/search.py
@@ -251,12 +251,13 @@ class LuceneQuery(object):


class SolrSearch(object):
-    option_modules = ('query_obj', 'filter_obj', 'paginator', 'more_like_this', 'highlighter', 'faceter', 'sorter')
+    option_modules = ('query_obj', 'filter_obj', 'facet_obj', 'paginator', 'more_like_this', 'highlighter', 'faceter', 'sorter')
    def __init__(self, interface):
        self.interface = interface
        self.schema = interface.schema
        self.query_obj = LuceneQuery(self.schema, 'q')
        self.filter_obj = LuceneQuery(self.schema, 'fq')
+        self.facet_obj = LuceneQuery(self.schema, 'facet.query')
        self.paginator = PaginateOptions(self.schema)
        self.more_like_this = MoreLikeThisOptions(self.schema)
        self.highlighter = HighlightOptions(self.schema)
@@ -283,6 +284,10 @@ class SolrSearch(object):
    def query(self, *args, **kwargs):
        self.query_obj.add(args, kwargs)
        return self
+    
+    def facet_query(self, *args, **kwargs):
+        self.facet_obj.add(args, kwargs)
+        return self

    def exclude(self, *args, **kwargs):
        self.query(~self.Q(*args, **kwargs))

Am I close? It works, but I still need to add facet_by("somefield") to get the actual facet=true added to the query. Not sure if I should try to merge that code with the above or leave them separate and just use that workaround?

execute().facet_counts.facet_queries

works, though, so it's aware of facet_queries at least in theory? Is there another way I should be using facet queries?

Thanks!

[tow]

Facet queries should work as is - no patch needed. If you have a model with a field "tags", and you want to facet your results on those tags, you can do:

solr.query("query term").facet_by("tags")

You can add extra options (see http://wiki.apache.org/solr/SimpleFacetParameters for a full list) like so:

solr.query("query term").facet_by("tags", mincount=1, limit=20)

The results will appear, as you've noticed, in facet_counts.facet_queries

[nator]

Thanks for the reply. I feel like I'm missing something, or maybe not saying it right? Taking your example, I don't want to facet just by all tags, I'm trying to do something like facet by "tag:blue" to use that particular query as a facet. (It's described here: http://wiki.apache.org/solr/SimpleFacetParameters#facet.query_:_Arbitrary_Query_Faceting )

Basically I've got a date field and I want to facet over various ranges: this weekend, whole week, etc, rather than every possible date in the index.

Make more sense?

[tow]

Argh, sorry, just realised I completely misread your message, so I've re-opened the ticket.

No there's no support for faceting by queries at the moment. I haven't needed it, so haven't written it :-) Something along the lines you suggest ought to work; then in the LuceneQuery.options method, add a check to say:

if self.option_flag == 'facet.query:
    opts['facet'] = "true"

A bit messy, but it ought to work - can you try it & see?

[nator]

I'll give it a shot later today - ran out of time on that part of the project at the moment!

[nator]

This looks like it works! I can now get the facet_query results like this:

>>> solr_interface.query(resource_type="Event").facet_query(instances__lt="20100811").query(credit="solrtest").execute().facet_counts.facet_queries
[('instances:{* TO 20100811}', 2)]

I'm new to Git as well, so I'm not sure how best to submit this change -- or is that enough information for you to easily add it to the code? Thanks for your help, and for Sunburnt in the first place!

[tow]

Glad to help! There should be enough information here for me to rustle up a patch, so it'll go into Sunburnt sometime soon.