I thought I'd post this as I'm not seeing anything obvious in the
documentation (that is to say, I cannot /find/ anything, not that it
/isn't/ there in an obvious place).
I'm making a particular object searchable from my customer UI. I will
have a field titled: 'Quick Search' which will search the name and
description of the table in question. I'd like the dataset to look
like this:
filter(name__istartswith=input)
UNION
filter(name__icontains=input).exclude(name__istartswith=input)
if len(input) >= 5:
UNION
filter(description__istartswith=input)
UNION
filter(description__icontains=input).exclude(description__istartswith=input)
The idea is to make the results somewhat relevant based on the fact
that people typically know what something starts with, so that should
be first.
My approach right now is to do the following (presume logically named
query set results):
results = list(name_startswith) + list(name_contains)
if len(input) >= 5:
results += list(description_startswith) +
list(description_contains)
return results[start:start+pagesize+1]
The problem with this is that the full result set is pulled into memory
before the final result is used. I know I could be more clever around
checking the total result sizes and not continuting, but that seems
tricky when you want results 50..60.
Is there any way to do sql UNION behavior through the APIs? Or
INTERSECT for that matter? Or should I consider dropping into SQL mode
and doing my own thing? Are there plans to provide & and | operators
on QuerySet objects? It seems like that'd be a pretty big undertaking,
but pretty frickin sweet if done well :-D.
Anyway, just asking. Thanks!
doug.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
