Djongo查询BooleanField失败

Question

我有这样一个模块的Django应用程序：

class myApp(models.Model):
    is_new = models.BooleanField(default=True)
    more_fields = models.TextField(blank=True)

并将Djongo用于数据库(即mongodb)

但是，在对布尔字段进行筛选时，我可以查询模块中的所有字段，而不存在任何问题，如下所示：

    myList = myApp.objects.filter(is_new=False)
        
    for record in myList: ....

如果出现以下错误，它将失败：

  File "/home/user/myApp/venv/lib64/python3.9/site-packages/djongo/sql2mongo/operators.py", line 258, in evaluate
    self.rhs.negate()
AttributeError: 'NoneType' object has no attribute 'negate'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/user/myApp/venv/lib64/python3.9/site-packages/djongo/cursor.py", line 51, in execute
    self.result = Query(
  File "/home/user/myApp/venv/lib64/python3.9/site-packages/djongo/sql2mongo/query.py", line 784, in __init__
    self._query = self.parse()
  File "/home/user/myApp/venv/lib64/python3.9/site-packages/djongo/sql2mongo/query.py", line 885, in parse
    raise exe from e
djongo.exceptions.SQLDecodeError: 

        Keyword: None
        Sub SQL: None
        FAILED SQL: SELECT "mysite_myapp"."more_fields", "mysite_myapp"."is_new" FROM "mysite_myapp" WHERE NOT "mysite_myapp"."is_new"
        Params: ()
        Version: 1.3.6

这似乎是一个Djongo问题，除非对布尔字段进行不同的查询。

正在使用的版本：

• Django 3.2.5
• djongo 1.3.6

Answer 1

对于Djongo来说，这似乎是一个很老的问题(这是大约一个月前为同一个bug打开的问题 )，人们被迫使用in查找来解决这个问题：

myList = myApp.objects.filter(is_new__in=[False])