我是Django新手,试图使用带有MyISAM引擎的MySql为我的项目创建一个“搜索”表单.到目前为止,我设法让表单工作,但Django似乎不会以相同的方式搜索所有字段.结果是随机的.例子：搜索区域返回没有结果或最糟糕的搜索描述工作正常,而howtogetin似乎不适用..
这是我的模型：
class Camp(models.Model):
owner = models.OneToOneField(User)
name = models.CharField(max_length=100)
description = models.TextField()
address1 = models.CharField(max_length=128)
address2 = models.CharField(max_length=128)
zipcode = models.CharField(max_length=128)
region = models.CharField(max_length=128)
country = models.CharField(max_length=128)
phone = models.CharField(max_length=60)
howtogetin = models.TextField()
def __str__(self):
return self.name
这是我的观点：
def campsearch(request):
if request.method == 'POST':
form = CampSearchForm(request.POST)
if form.is_valid():
terms = form.cleaned_data['search']
camps = Camp.objects.filter(
Q(name__search=terms)|
Q(description__search=terms)|
Q(address1__search=terms)|
Q(address2__search=terms)|
Q(zipcode__search=terms)|
Q(region__search=terms)|
Q(country__search=terms)|
Q(howtogetin__search=terms)
)
return render(request,'campsearch.html',{'form':form,'camps':camps})
else:
form = CampSearchForm()
return render(request,{'form':form})
任何线索？
最佳答案
我建议你实现这个：
原文链接：https://www.f2er.com/mysql/433490.html#views.py
def normalize_query(query_string,findterms=re.compile(r'"([^"]+)"|(\S+)').findall,normspace=re.compile(r'\s{2,}').sub):
'''
Splits the query string in invidual keywords,getting rid of unecessary spaces and grouping quoted words together.
Example:
>>> normalize_query(' some random words "with quotes " and spaces')
['some','random','words','with quotes','and','spaces']
'''
return [normspace(' ',(t[0] or t[1]).strip()) for t in findterms(query_string)]
def get_query(query_string,search_fields):
'''
Returns a query,that is a combination of Q objects.
That combination aims to search keywords within a model by testing the given search fields.
'''
query = None # Query to search for every search term
terms = normalize_query(query_string)
for term in terms:
or_query = None # Query to search for a given term in each field
for field_name in search_fields:
q = Q(**{"%s__icontains" % field_name: term})
if or_query is None:
or_query = q
else:
or_query = or_query | q
if query is None:
query = or_query
else:
query = query & or_query
return query
并为每次搜索
#views.py
def search_for_something(request):
query_string = ''
found_entries = None
if ('q' in request.GET) and request.GET['q'].strip():
query_string = request.GET['q']
entry_query = get_query(query_string,['field1','field2','field3'])
found_entries = Model.objects.filter(entry_query).order_by('-something')
return render_to_response('app/template-result.html',{ 'query_string': query_string,'found_entries': found_entries },context_instance=RequestContext(request)
)
并在模板中
#template.html
和网址
#urls.py
url(r'^results/$','app.views.search_for_something',name='search_for_something'),