如何实现Django模型中executive_head字段仅一个True值？

需求：确保Employee模型的executive_head字段只能有一个实例的值为True，不允许存在多个执行主管。尝试用unique_together无效，因为False值无法保证唯一性。

原模型代码：

from django.db import models
from django.contrib.auth import get_user_model

User = get_user_model()


class Employee(models.Model):
    employee = models.OneToOneField(User, on_delete=models.CASCADE)
    boss = models.ForeignKey(
        "self",
        on_delete=models.CASCADE,
        null=True,
        blank=True),
    )
    executive_head = models.BooleanField(
        default=False,
        help_text=_("e.g. Chief Executive Officer or Managing Director."),
    )
    job_title = models.CharField(max_length=100)

    class Meta:
        ordering = ["id"]
        constraints = [
            UniqueConstraint(
                fields=["executive_head"],
                name="only_one_executive_head",
                condition=Q(executive_head=True),
            )
        ]

    def __str__(self):
        return f"{ self.employee }"

    def save(self, *args, **kwargs):

        if self.employee == self.boss:
            self.executive_head = True
        else:
            self.executive_head = False

    def clean(self):
        if Employee.objects.filter(executive_head=True) and 
           self.employee == self.boss:
            raise ValidationError(
                {"executive_head": _("There can only be one executive          
                  head.")
                }
            )

核心解决思路 #

要实现“仅一个executive_head为True”的约束，需要数据库层面的条件唯一约束+模型层的校验逻辑双重保障，同时修正原代码中的语法错误：

1. 修复数据库条件唯一约束

原代码的UniqueConstraint方向正确，但存在细节问题：

• 必须导入django.db.models.Q类
• 该约束仅支持Django 3.0及以上版本
• 原boss字段定义多了一个闭合括号，会触发语法错误

修正后的Meta类约束：

from django.db.models import Q, UniqueConstraint

class Meta:
    ordering = ["id"]
    constraints = [
        UniqueConstraint(
            fields=["executive_head"],
            name="only_one_executive_head",
            condition=Q(executive_head=True),
        )
    ]

这个约束会在数据库层面强制：所有executive_head=True的记录中，该字段值唯一（最多一条），executive_head=False的记录不受限制。

2. 完善模型的clean校验逻辑

原clean方法存在语法错误（换行未加反斜杠）且逻辑不完整，需要补充：

• 校验当前实例设为executive_head=True时，是否已有其他实例是True（排除自身编辑场景）
• 导入必要的校验类和翻译工具

修正后的clean方法：

from django.core.exceptions import ValidationError
from django.utils.translation import gettext_lazy as _

def clean(self):
    super().clean()
    # 检查是否要设置当前实例为执行主管
    if self.executive_head:
        # 排除自身（避免编辑已有执行主管时触发错误）
        existing_executives = Employee.objects.filter(executive_head=True).exclude(pk=self.pk)
        if existing_executives.exists():
            raise ValidationError(
                {"executive_head": _("There can only be one executive head.")}
            )
    # 补充逻辑：当员工的直属上级是自己时，强制设为执行主管
    if self.boss is not None and self.employee == self.boss.employee:
        self.executive_head = True

3. 修复save方法的逻辑错误

原save方法未调用super().save()，导致数据无法写入数据库，需先执行校验再保存：

def save(self, *args, **kwargs):
    # 先执行校验逻辑
    self.clean()
    # 调用父类方法完成数据保存
    super().save(*args, **kwargs)

完整修正后的代码 #

from django.db import models
from django.db.models import Q, UniqueConstraint
from django.contrib.auth import get_user_model
from django.core.exceptions import ValidationError
from django.utils.translation import gettext_lazy as _

User = get_user_model()


class Employee(models.Model):
    employee = models.OneToOneField(User, on_delete=models.CASCADE)
    boss = models.ForeignKey(
        "self",
        on_delete=models.CASCADE,
        null=True,
        blank=True
    )
    executive_head = models.BooleanField(
        default=False,
        help_text=_("e.g. Chief Executive Officer or Managing Director."),
    )
    job_title = models.CharField(max_length=100)

    class Meta:
        ordering = ["id"]
        constraints = [
            UniqueConstraint(
                fields=["executive_head"],
                name="only_one_executive_head",
                condition=Q(executive_head=True),
            )
        ]

    def __str__(self):
        return f"{self.employee}"

    def clean(self):
        super().clean()
        if self.executive_head:
            existing_executives = Employee.objects.filter(executive_head=True).exclude(pk=self.pk)
            if existing_executives.exists():
                raise ValidationError(
                    {"executive_head": _("There can only be one executive head.")}
                )
        # 当员工的直属上级是自己时，自动设为执行主管
        if self.boss is not None and self.employee == self.boss.employee:
            self.executive_head = True

    def save(self, *args, **kwargs):
        self.clean()
        super().save(*args, **kwargs)

额外说明 #

• 数据库层面的约束是最后一道防线，防止绕过模型校验直接操作数据库的情况（比如通过数据库客户端修改数据）
• 模型层的clean方法会在表单提交、管理员后台操作时触发，提前返回友好的错误提示

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