mysql - 在 Django : select_format 中使用条件注释时出错

Question

尝试注释查询集时，我从 django 方法中收到 TypeError。
我在 Ubuntu 上使用 Django 1.11.12 和 MySQL 5.7.22。

这是我的models.py:

class Group(models.Model):
    name = models.CharField(max_length=100)

class ActivationRecord(models.Model):
    group = models.ForeignKey('directory.Group')
    year = models.PositiveIntegerField()

如果一个组有给定年份的记录，则该组是“活跃的”。我正在尝试使用以下查询注释组是否处于事件状态:

Group.objects.annotate(active=Case(
    When(activationrecord__year=2018, then=True), default=False, output_field=BooleanField))

当我运行时，我收到以下错误:

  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/query.py", line 226, in __repr__
    data = list(self[:REPR_OUTPUT_SIZE + 1])
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/query.py", line 250, in __iter__
    self._fetch_all()
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/query.py", line 1118, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 877, in execute_sql
    sql, params = self.as_sql()
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 429, in as_sql
    extra_select, order_by, group_by = self.pre_sql_setup()
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 46, in pre_sql_setup
    self.setup_query()
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 37, in setup_query
    self.select, self.klass_info, self.annotation_col_map = self.get_select()
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 227, in get_select
    sql, params = self.compile(col, select_format=True)
  File "/home/vagrant/Envs/think/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 375, in compile
    return node.output_field.select_format(self, sql, params)
TypeError: select_format() missing 1 required positional argument: 'params'

Answer 1

BooleanField需要作为函数调用，使用 ()

Group.objects.annotate(active=Case(
    When(activationrecord__year=2018, then=True), 
default=False, output_field=BooleanField()))