Django View中for循环处理空外键时匹配不存在错误如何解决？

报错的核心原因不是字段值为NULL，而是你为外键配置了on_delete=models.DO_NOTHING，当关联的TeamMember记录被删除后，WeekdayAssignment对应外键字段仍存储着已失效的用户ID，Django访问该外键属性时尝试查询关联记录失败，就会抛出TeamMember matching query does not exist错误。如果字段是真实的NULL值，直接访问并不会触发该错误。

方法1：异常捕获+空值判断（直接适配现有逻辑） #

访问外键属性时捕获DoesNotExist异常，同时判断空值，无效值直接跳过即可。你可以把所有班次字段统一放到列表里循环处理，不用挨个字段写判断：

from django.core.exceptions import ObjectDoesNotExist

def someview(request):
    # 定义所有需要统计的班次字段
    shift_fields = ["triage_emea_1", "triage_nam_1", "triage_nam_2", "triage_nam_3"]
    shift_users = TeamMember.objects.all()
    weekday_shifts = WeekdayAssignment.objects.all()
    # 初始化计数器字典
    user_shift_count = {t.id: 0 for t in shift_users}
    
    for ws in weekday_shifts:
        for field in shift_fields:
            try:
                user = getattr(ws, field)
                if user is not None:
                    user_shift_count[user.id] += 1
            except ObjectDoesNotExist:
                # 遇到无效外键直接跳过
                continue
    # 最终user_shift_count里存的就是每个用户id对应的总班次
    print(user_shift_count)

方法2：清理数据库脏数据（从根源解决问题） #

如果你不需要保留这些关联到已删除用户的排班记录，可以把所有无效的外键值设为NULL，之后访问就不需要捕获异常了：

from django.core.exceptions import ObjectDoesNotExist

shift_fields = ["triage_emea_1", "triage_nam_1", "triage_nam_2", "triage_nam_3"]
for ws in WeekdayAssignment.objects.all():
    changed = False
    for field in shift_fields:
        try:
            getattr(ws, field)
        except ObjectDoesNotExist:
            setattr(ws, field, None)
            changed = True
    if changed:
        ws.save()

方法3：ORM聚合统计（性能更高，无需嵌套循环） #

如果数据量较大，嵌套循环的效率很低，可以直接用ORM的聚合查询实现统计，不需要自己遍历所有记录：

from django.db.models import Count, Q, F

shift_fields = ["triage_emea_1", "triage_nam_1", "triage_nam_2", "triage_nam_3"]
# 构造查询条件
q_statement = Q()
for field in shift_fields:
    q_statement |= Q(**{f"{field}__id": F("id")})

# 直接查询得到每个用户的总班次
user_count = TeamMember.objects.annotate(
    shift_total=Count("id", filter=q_statement)
).values_list("id", "shift_total")

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