什么是有效的方法来做和/或搜索Django-Postgres App？ [英] What is an Efficient Way to do an AND/OR Search Django-Postgres App?

问题描述

在我的Django应用程序中，我有一个出版模型和一个标签模型，它们有很多关系。假设我有四个标签：男士，女士，时尚，设计。我想找到所有与其相关联的男性或女性标签的出版物，以及与之相关的时尚或设计标签。例如，在搜索字段中，我可以输入：（men || women）&& （时尚||设计）。换句话说，结果应该产生每个或对中至少一个标签的出版物。

我已经弄清楚如何做一个或搜索（即查找所有具有男性或女性标签或时尚或设计的出版物），并且我已经弄清楚如何做一个搜索（即查找所有标签，男人和女人的所有出版物和时尚和设计），但我不知道最有效的方法来做和组合。

到目前为止，我已经分离了查询字符串以获取或对的列表，我开始创建一个搜索谓词，但后来我想，我做这些结果？例如...

  if request中的'qTag'.GET：
 or_queries = request.GET ['qTag '] .split（'&&'）
 $ b $ or在or_queries中的or_query：
 or_query_set = or_query.split（）
在or_query_set中的sub_query：
 if pub_predicate：
 pub_predicate = pub_predicate | Q（tags__title__istartswith = sub_query）
 else：
 pub_predicate = Q（tags__title__istartswith = sub_query）
 pubs_for_set = Publication.objects.filter（pub_predicate）.distinct（）
 pubs_for_tags.append pubs_for_set）
 pub_predicate =无
 pubs_for_set =无
  

列表（pubs_for_tags）的列表（pubs_for_set），为每个或对提供所有结果。但现在什么？我不知道如何进行和搜索
任何人都可以建议一种方式这个？

解决方案

我不知道是否有办法做到这一点，我想说试试把过滤器与Q但是后来又想到了：

在Django查询中组合AND OR

和

AND OR Django查询II

In my Django app I have a Publication model and a Tag model which have a many to many relationship.

Let's say I have four tags: men, women, fashion, design. I want to find all publications that have a men OR women tag associated with it, AND a fashion OR design tag associated with it. For example, in a search field I might enter: (men || women) && (fashion || design). In other words, the results should yield publications that have at least one tag from each 'or' pair.

I have figured out how to do just an 'or' search (i.e. find all publications with a tag of men or women or fashion or design) and I have figured out how to do just an and search (i.e. find all publications that have all the tags, men and women and fashion and design), but I do not know the most efficient way to do the and-or combo.

Thus far I have split up the query string to get a list of 'or' pairs, and I started to create a search predicate, but then I thought, what will I do with these results? For example...

if 'qTag' in request.GET:
        or_queries = request.GET['qTag'].split('&&')

        for or_query in or_queries:
            or_query_set = or_query.split()
            for sub_query in or_query_set:
                if pub_predicate:
                    pub_predicate = pub_predicate | Q(tags__title__istartswith=sub_query)
                else:
                    pub_predicate = Q(tags__title__istartswith=sub_query)
            pubs_for_set = Publication.objects.filter(pub_predicate).distinct()
            pubs_for_tags.append(pubs_for_set)
            pub_predicate = None
            pubs_for_set = None

Doing the above gives me a list (pubs_for_tags) of lists (pubs_for_set) that gives all results for each "or"pair." But now what? I don't know how to proceed with an and search. Can anyone suggest a way to do this?

解决方案

I'm not sure if there is a way to do this. I wanted to say try combining filter with Q but then chanced upon these:

Combining AND OR in Django Queries

and

AND OR in Django queries II

这篇关于什么是有效的方法来做和/或搜索Django-Postgres App？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！