如何使用QuerySets和MySql“全文搜索”使Django在多个字段中进行搜索？

Question

如何使用QuerySets和MySql“全文搜索”使Django在多个字段中进行搜索？

mysqldjangopython-2.7full-text-searchdjango-queryset

7

我是一名Django新手，正在尝试使用MySql和MyISAM引擎为我的项目创建一个“搜索”表单。到目前为止，我设法让表单工作，但是Django似乎无法以相同的方式搜索所有字段。结果是随机的。例如：在region中搜索不返回任何结果，而在description中搜索正常工作，而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, 'campsearch.html', {'form':form})

有线索吗？

- adilbenseddik

2个回答

1

__search 只能在开启全文索引的 TextFields 上工作（听起来你的描述字段是这样的）。不要使用此方法，尝试使用：

Q(name__icontains=terms)

这是对“CharField”字段进行不区分大小写的“包含”匹配。

搜索：https://docs.djangoproject.com/en/dev/ref/models/querysets/#search

包含：https://docs.djangoproject.com/en/dev/ref/models/querysets/#icontains

- Glen Swinfield

我最终使用了Q(name__search=terms)|Q(name__icontains=terms)来扩展结果的范围，它起到了作用。但有些情况下结果是随机的。例如，如果数据库中有_foo_和_foo2_，则对'foo foo2'的搜索无法工作，而对'foo and random string'的搜索却可以正常工作。一些搜索术语似乎被忽略了，即使它们与一个存在的Q条件相匹配。有什么线索吗？ - adilbenseddik

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- Ronaldo Bahia · Accepted Answer

我建议您实现以下内容：

#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
<form class="" method="get" action="{% url 'search_for_something' model.pk %}">
    <input name="q" id="id_q" type="text" class="form-control" placeholder="Search" />
    <button type="submit">Search</button>
</form>

#template-result.html
{% if found_entries %}
   {% for field in found_entries %}
        {{ model.field }}
   {% endfor %}
{% endif %}

并且这是网址

 #urls.py
 url(r'^results/$', 'app.views.search_for_something', name='search_for_something'),