Django动态构建Q查询报错：ValueError: too many values to unpack

问题描述 #

在Django项目中，想要基于包含模型字段的集合动态构建查询语句，尝试通过字符串拼接生成Q查询表达式，但无法实际使用，报错ValueError: too many values to unpack (expected 2)。

尝试的代码：

sq = []
for x in columns:
    print(x)
    sq.append(f'Q({x}__icontains=val)')
print(sq)
query = (' | '.join(sq))
print(query)

lookups = Q(name__icontains=val) | Q(code__icontains=val)
# lookups = query

修改为sq.append(f"Q({x}__icontains='{val}')")后问题依旧。

报错信息 #

Traceback (most recent call last):   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)   File "/home/user/price_engine/masterdata/views.py", line 50, in search_form
    results = Plant.objects.filter(query).distinct()   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/query.py", line 1436, in filter
    return self._filter_or_exclude(False, args, kwargs)   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/query.py", line 1454, in _filter_or_exclude
    clone._filter_or_exclude_inplace(negate, args, kwargs)   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/query.py", line 1461, in _filter_or_exclude_inplace
    self._query.add_q(Q(*args, **kwargs))   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1534, in add_q
    clause, _ = self._add_q(q_object, self.used_aliases)   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1565, in _add_q
    child_clause, needed_inner = self.build_filter(   File "/home/user/price_engine/env/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1412, in build_filter
    arg, value = filter_expr ValueError: too many values to unpack (expected 2) [05/Jul/2023 04:27:27] "POST /master/search/plant HTTP/1.1" 500 97494

问题原因与解决方案 #

原因 #

你之前的做法是把Q查询拼接成字符串，但Django的filter()方法需要的是实际的Q对象实例，不是字符串。字符串无法被Django解析为有效的查询条件，所以会抛出参数解析错误。

正确实现方式 #

直接创建Q对象实例，然后通过位或操作（|）合并所有查询条件：

# 初始化一个空的Q对象
lookups = Q()
for x in columns:
    # 动态构建Q对象，用字典解包的方式传递查询参数
    q_obj = Q(**{f"{x}__icontains": val})
    # 合并查询条件（逻辑或）
    lookups |= q_obj

# 使用构建好的Q对象进行查询
results = Plant.objects.filter(lookups).distinct()

代码解释 #

• Q(**{f"{x}__icontains": val})：通过字典解包的方式，动态生成每个字段的icontains查询条件，直接创建有效的Q对象。
• lookups |= q_obj：把每个新的Q对象和已有的查询条件进行逻辑或合并，最终得到所有字段的icontains查询的逻辑或集合。

这种方式不需要字符串拼接，直接操作Q对象实例，符合Django的查询API规范，能正确被ORM解析执行。

内容的提问来源于stack exchange，提问作者Berik