我如何在Djang中根据字典及其关键字进行Q过滤器搜索

Question

假设我有这本字典

mydict['number'] = {23,24,25}
mydict['name'] = {"john","mike","kaff"}
mydict['area'] = {"london", "usa", "japan"}

我已经有了查询集qs

但是我想基于上面的dictionary进行额外的过滤，比如

qs.filter (where number __icontains in 23,24,25)

以及qs.filter (where name __icontains in john, mike, kaff)等等

编辑：

这是我尝试过的，但很粗糙

^{pr2}$

Answer 1

您可以尝试以下方法：

for k, v in mydict:
    qs.filter('%s__icontains' % k=v)

Answer 2

我将从Q对象将参数合并到filter。https://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects