# Add the extra SELECT and WHERE options
return self.extra(select={‘relevance’: match_expr},
where=[match_expr],
params=[query],
select_params=[query])

One parameter (i.e. variable ‘query’) has to be passed to additional select clause, another parameter (the same query variable in this case) – to where clause. For the first select_params is used, for the latter – params.

It’s been a long time since I’ve looked at this code, and both Django and Python have moved on without me.

You might want to try posting your question on Stack Overflow:

http://stackoverflow.com/questions/ask

I get a stopiteration exception at:
/usr/local/lib/python2.6/dist-packages/django/db/models/sql/query.py in add_extra, line 1691

here is my code:
class SearchQuerySet(models.query.QuerySet):
def __init__(self, model=None, fields=None, *args, **kwargs):
super(SearchQuerySet, self).__init__(model, *args, **kwargs)
self._search_fields = fields

def search(self, query):
meta = self.model._meta

# Get the table name and column names from the model
# in `table_name`.`column_name` style
columns = [meta.get_field(name, many_to_many=False).column for name in self._search_fields]
full_names = ["%s.%s" % (connection.ops.quote_name(meta.db_table), connection.ops.quote_name(column)) for column in columns]

# Create the MATCH…AGAINST expressions
fulltext_columns = “, “.join(full_names)
match_expr = (“MATCH(%s) AGAINST (%%s)” % fulltext_columns)

# Add the extra SELECT and WHERE options
return self.extra(select={‘relevance’: match_expr}, where=[match_expr], params=[query, query])

class SearchManager(models.Manager):
def __init__(self, fields, *args, **kwargs):
super(SearchManager, self).__init__(*args, **kwargs)
self._search_fields = fields

def get_query_set(self):
return SearchQuerySet(self.model, self._search_fields)

def search(self, query):
return self.get_query_set().search(query)

I ended up using MercuryTide’s search as a starting point, but wrote the actual search aspect myself, because InnoDB doesn’t support MySQL’s fulltext search.

Now I’m attempting to track down an odd bug whereby attempting to filter() a result-set results in [], regardless of match.

def __init__(self, index_column, *args, **kwargs):
super(SearchManager, self).__init__(*args, **kwargs)

Similarly for SearchQuerySet.

django/db/models/query.py

line c = klass(model=self.model, query=self.query.clone())

“__init__() got an unexpected keyword argument ‘query’”

Digging around. Letcha know if I find something out.