Login

superSearch function for generating large OR queries

Author:
Neuman
Posted:
August 10, 2009
Language:
Python
Version:
1.1
Tags:
dynamic q query kwargs
Score:
-1 (after 1 ratings)

superSearch is intended to make it easier to make complex OR queries, thusly hitting the database less.

EXAMPLE: Searching for a user named 'Eric Neuman' would be difficult because first_name and last_name are separate fields. However, with superSearch, it's a breeze.

query = ['Eric Neuman']
f = ['first_name','last_name']
s = query.split(' ')
m = ['icontains']
results = superSearch(User, f, m,s)
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
from django.db.models.query import Q
def superSearch(model, fields, matches, strings):
	"""
	Designed to lessen the code needed to run complex searches with ORed filters.  
	Model: the model being queried.
	fields: an iterable containing string names of fields to query.
	match:  an iterable containing strings of what type of Django lookup to apply to those fields.
	strings: an iterable containing strings to be matched.
	"""
	queries = []
	for field in fields:
		for string in strings:
			for match in matches:
				kwargs = {'%s__%s' % (field, match): string}
				queries.append(Q(**kwargs))
	q = Q()
	for query in queries:
		q = q | query
	return model.objects.filter(q)

More like this

Comments

rix (on August 11, 2009):
<p>This is nice! Maybe you could remove the last loop, something like this:</p> <pre>def superSearch(model, fields, matches, strings): q = Q() for field in fields: for string in strings: for match in matches: kwargs = {'%s__%s' % (field, match): string} q = q | Q(**kwargs) return model.objects.filter(q) </pre>

#

Please login first before commenting.