Django自动填充表B触发ValueError问题求助

问题场景 #

用户在表单填充表A（对应模型BorrowBook）后，通过Django信号自动填充表B（对应模型ApprovedLending）时触发ValueError，错误详情如下：

Traceback (most recent call last):
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/home/dubsy/virtualenvs/djangoproject/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/dubsy/virtualenvs/djangoproject/libmain/books/views.py", line 21, in borrow
    borrower.save()
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/db/models/base.py", line 812, in save
    self.save_base(
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/db/models/base.py", line 878, in save_base
    post_save.send(
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/dispatch/dispatcher.py", line 176, in send
    return [
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/dispatch/dispatcher.py", line 177, in <listcomp>
    (receiver, receiver(signal=self, sender=sender, **named))
  File "/home/dubsy/virtualenvs/djangoproject/libmain/books/models.py", line 84, in create_lending
    ApprovedLending.objects.create(member=row["member_id"])
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/db/models/query.py", line 669, in create
    obj = self.model(**kwargs)
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/db/models/base.py", line 541, in __init__
    _setattr(self, field.name, rel_obj)
  File "/home/dubsy/virtualenvs/djangoproject/lib/python3.9/site-packages/django/db/models/fields/related_descriptors.py", line 235, in __set__
    raise ValueError(

Exception Type: ValueError at /borrow/
Exception Value: Cannot assign "1": "ApprovedLending.member" must be a "User" instance.

相关模型代码：

class A(models.Model):  # 对应BorrowBook
    member = models.ForeignKey(User, on_delete=models.CASCADE, default="")
    book = models.ForeignKey(Books, on_delete=models.CASCADE, default="")
    library_no = models.CharField(default="", max_length=255, blank=True)
    staff_id = models.CharField(default="", max_length=255, blank=True)
    application_date = models.DateTimeField(auto_now_add=True)

class B(models.Model):  # 对应ApprovedLending
    member = models.ForeignKey(User, on_delete=models.CASCADE, default="", null=True)
    book = models.ForeignKey(Books, on_delete=models.CASCADE, default="", null=True)
    approved = models.BooleanField()
    approval_date = models.DateTimeField(auto_now_add=True, null=True)

原信号函数：

@receiver(post_save, sender=BorrowBook)
def create_lending(sender, instance,**kwargs):
    data = BorrowBook.objects.values()
    for row in data:
        ApprovedLending.objects.create(member=row["member_id"])

错误原因 #

1. 类型不匹配：ApprovedLending.member是ForeignKey字段，要求赋值为User模型实例，但信号中传入的row["member_id"]是数字ID，不是实例，触发类型错误。
2. 逻辑冗余：遍历所有BorrowBook数据创建ApprovedLending，每次保存都会重复创建大量记录，逻辑不合理。
3. 模型字段配置错误：ForeignKey字段设置default=""无效，因为ForeignKey只能关联模型实例或设置null=True，字符串默认值会引发潜在问题。

解决方案 #

1. 修正信号函数（推荐） #

利用信号传递的instance对象，直接获取关联的User和Book实例，同时仅在新增记录时执行创建逻辑：

from django.db.models.signals import post_save
from django.dispatch import receiver
from .models import BorrowBook, ApprovedLending

@receiver(post_save, sender=BorrowBook)
def create_lending(sender, instance, created, **kwargs):
    # 仅当新增BorrowBook记录时执行，避免更新时重复创建
    if created:
        ApprovedLending.objects.create(
            member=instance.member,
            book=instance.book,
            approved=False  # 根据业务需求设置默认审批状态
        )

2. 使用ID后缀字段赋值 #

若需直接用ID赋值，Django允许通过字段名_id的形式直接传入数字ID（无需查询实例）：

@receiver(post_save, sender=BorrowBook)
def create_lending(sender, instance, created, **kwargs):
    if created:
        ApprovedLending.objects.create(
            member_id=instance.member_id,
            book_id=instance.book_id,
            approved=False
        )

3. 优化模型字段配置 #

移除ForeignKey字段无效的default=""设置，根据业务需求调整为必填或允许为空：

class A(models.Model):
    member = models.ForeignKey(User, on_delete=models.CASCADE)  # 必填字段，移除无效默认值
    book = models.ForeignKey(Books, on_delete=models.CASCADE)
    library_no = models.CharField(default="", max_length=255, blank=True)
    staff_id = models.CharField(default="", max_length=255, blank=True)
    application_date = models.DateTimeField(auto_now_add=True)

class B(models.Model):
    member = models.ForeignKey(User, on_delete=models.CASCADE, null=True)
    book = models.ForeignKey(Books, on_delete=models.CASCADE, null=True)
    approved = models.BooleanField(default=False)  # 给BooleanField设置默认值
    approval_date = models.DateTimeField(auto_now_add=True, null=True)

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