更新或删除表“ users_user”违反外国钥匙约束“ articles_article_users_user_id”

发布于 2025-02-02 18:06:46 字数 370 浏览 1 评论 0原文

我正在使用Django V4。或反之亦然，所以我在文章模型中引用了用户on_delete = delete.do_nothing，但是当我尝试删除用户时，我会遇到此错误我以为是吗？我如何通过这件事并实现我倾向于做的事情而不会限制错误？谢谢

class Article(models.Model):
     title = models.CharField(max_length=355)
     author = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING, 
     related_name='articles')
     .....

原文

I am working with Django v4.* and I have linked 2 table/model Users and Articles and my aim is when user is deleted I don't want to delete the article or vice versa, so I referenced user on_delete=models.DO_NOTHING in the Article model, but I am getting this error when I tried to delete a user, it seems to my that DO_NOTHING is not working the way I thought it does?How I can pass this and achieve what I tend to do without getting constrain error? Thanks

class Article(models.Model):
     title = models.CharField(max_length=355)
     author = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING, 
     related_name='articles')
     .....

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

绅士风度i 2025-02-09 18:06:46

您不能在大多数DB中参考现有的PK。如果您想在删除用户后离开文章，则应该执行这样的操作：

class Article(models.Model):
     title = models.CharField(max_length=355)
     author = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.SET_NULL, null=True, 
     related_name='articles')
 .....

这样，当您删除参考用户时，作者将被设置为db中的null。

You can't reference not existing PK in most of DBs. If you want to leave Article after deleting User you should do something like that:

class Article(models.Model):
     title = models.CharField(max_length=355)
     author = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.SET_NULL, null=True, 
     related_name='articles')
 .....

This way, when you are deleting referenceed user, author will be set to null in DB.

回复收藏 0 原文

~没有更多了~