Simple search in Django

Question

I have a really simple blog application and I want to add a really simple search feature to it.

There are 3 key fields to my model.

class BlogPost(models.Model):     title = models.CharField(max_length=100) # the title     intro = models.TextField(blank=True, null=True) # an extract     content = models.TextField(blank=True, null=True) # full post 

I don't need a Google. I don't want to search comments (which are held on Disqus anyway). I just want a date-ranked, keyword filtered set of posts.

Everything I find on Google for some form of "django" and "search" comes back with hideously complicated Haystack+backend solutions. I don't need all that. I don't want to eat up more resources on a low-usage feature (I used to have a search box before I ported to Django and it had perhaps 4 searches a month).

The reason I'm taking time to ask on here (rather than just writing a messy little script) is this already exists in the admin. You can set the columns to search on and then just search and it "just works".

Is there some way of getting a handle on the admin-provided search and pulling it into my user-facing app?

Answer 1

If you want a really simple search you can use icontains lookup and Q object:

from django.db.models import Q results = BlogPost.objects.filter(Q(title__icontains=your_search_query) | Q(intro__icontains=your_search_query) | Q(content__icontains=your_search_query)) 

You should also note that Haystack doesn't have to be "hideously complicated". You can set up haystack with Whoosh backend in less then 15 minutes.

Update 2016: In version 1.10 Django added a full text search support (PostgreSQL only). An answer to the original question using the new module might look something like this:

from django.contrib.postgres.search import SearchVector  results = BlogPost.objects.annotate(     search=SearchVector('title', 'intro', 'content'), ).filter(search=your_search_query) 

The new full text search module contains a lot more features (for example sorting by relevancy), you can read about them in the documentation.

Answer 2

From the Django source:

# Apply keyword searches. def construct_search(field_name):     if field_name.startswith('^'):         return "%s__istartswith" % field_name[1:]     elif field_name.startswith('='):         return "%s__iexact" % field_name[1:]     elif field_name.startswith('@'):         return "%s__search" % field_name[1:]     else:         return "%s__icontains" % field_name  if self.search_fields and self.query:     for bit in self.query.split():         or_queries = [models.Q(**{construct_search(str(field_name)): bit}) for field_name in self.search_fields]         qs = qs.filter(reduce(operator.or_, or_queries))     for field_name in self.search_fields:         if '__' in field_name:             qs = qs.distinct()             break 

Clearly, it uses the database options to perform search. If nothing else, you should be able to reuse some of the code from it.

So says the documentation too: http://docs.djangoproject.com/en/dev/ref/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields

The full text search, however, uses the MySQL index (only if you are using MySQL).