（DRF）如何更新外国钥匙字段

Question

我有两个型号，帐户模型＆amp; 线程模型：

class Account(AbstractBaseUser, PermissionsMixin):
    
    class Meta:
        verbose_name_plural = "Account List"

    email = models.EmailField(max_length=255, unique=True)
    username = models.CharField(max_length=255, unique=True)
    name = models.CharField(max_length=255, default="")
    profile_image = models.ImageField(max_length=255, upload_to=profile_image_path, blank=True, null=True, unique=True)
    about = models.TextField(max_length=255, default='Write something about yourself...', blank=True)
    start_date = models.DateTimeField(default=timezone.now)
    is_staff = models.BooleanField(default=False)
    is_superuser = models.BooleanField(default=False)
    is_active = models.BooleanField(default=True)
    last_login = models.DateTimeField(auto_now=True)

    objects = AccountManager()

    USERNAME_FIELD = "email"
    REQUIRED_FIELDS = ["username", "name"]

    def __str__(self):
        return self.username

class Thread(models.Model):

    options = (('active', 'Active'), ('deactivated', 'Deactivated'))

    username = models.ForeignKey(Account, on_delete=models.CASCADE, to_field='username')
    alt = models.TextField(max_length=255, blank=True)
    image = models.ImageField(max_length=255, upload_to=thread_image_path, blank=True)
    content = models.TextField(blank=True)
    created = models.DateTimeField(blank=True, null=True, default=timezone.now)
    status = models.CharField(max_length=11, choices=options, default='active')

如果我已经创建了一个foreferkey的线程到帐户模型，我将无法更改用户名 帐户模型的模型，返回错误外键约束失败。我猜现有的线程模型需要用户名来指向。是否可以在view.py中创建自定义更新方法来自动更新foreferkey？

这是我的view.py：

class UserViewSet(viewsets.ModelViewSet):
    serializer_class = UserSerializer 
    queryset = Account.objects.all()
    permission_classes = (AllowAny,)

编辑： serializer.py

class ThreadSerializer(serializers.ModelSerializer):
    
    profile_image = serializers.SerializerMethodField('get_profile_image')
    created = serializers.DateTimeField(format="%d %B, %Y %H:%M:%S")
    
    class Meta:
        model = Thread
        fields = (
                  'id',
                  'username',
                  'profile_image',
                  'alt', 
                  'image', 
                  'content', 
                  'created', 
                  'status')
        
    def get_profile_image(self, thread):
        profile_image_url = thread.username.profile_image.url
        return profile_image_url

错误：

IntegrityError at /account/auth/user/1/
FOREIGN KEY constraint failed
Request Method: PUT
Request URL:    http://127.0.0.1:8000/account/auth/user/1/
Django Version: 4.0.4
Exception Type: IntegrityError
Exception Value:    
FOREIGN KEY constraint failed
Exception Location: c:\Users\85291\Desktop\vscode\my-app\web\env\lib\site-packages\django\db\backends\sqlite3\base.py, line 477, in execute
Python Executable:  c:\Users\85291\Desktop\vscode\my-app\web\env\Scripts\python.exe
Python Version: 3.10.2
Python Path:    
['C:\\Users\\85291\\Desktop\\vscode\\my-app\\web\\jtravel',
 'c:\\Users\\85291\\.vscode\\extensions\\ms-python.python-2022.6.3\\pythonFiles\\lib\\python\\debugpy\\_vendored\\pydevd',
 'C:\\Python310\\python310.zip',
 'C:\\Python310\\DLLs',
 'C:\\Python310\\lib',
 'C:\\Python310',
 'c:\\Users\\85291\\Desktop\\vscode\\my-app\\web\\env',
 'c:\\Users\\85291\\Desktop\\vscode\\my-app\\web\\env\\lib\\site-packages']
Server time:    Sun, 05 Jun 2022 16:40:53 +0800

Answer 1

删除to_field ='用户名'

username = models.ForeignKey(Account, on_delete=models.CASCADE) 

这是错误的原因