如何将数据从外键表的属性获取到django中的主密钥表

发布于 2025-02-05 15:21:32 字数 826 浏览 2 评论 0原文

我想解决所有问题。由于问题模型将项目作为外国密钥字段，因此我无法在项目模型中导入问题，这会导致循环导入。

项目模型

'''' 类项目（Models.Model）：

creation_date = models.DateTimeField(auto_now_add=True)
updated_date = models.DateTimeField(auto_now=True)
expiry_date = models.DateTimeField(null=True, blank=True)
exemption = ListField(models.CharField(max_length=128), blank=True, null=True)

'''

问题模型

''' 班级问题（Models.Model）：

requestor = models.ForeignKey(User, related_name='issues', on_delete=models.CASCADE)
projects = models.ManyToManyField(Project, related_name='issues_projects')
reference = models.CharField(max_length=16, unique=True, editable=False, null=True)
status = models.CharField(max_length=12, choices=IssueStatus.choices, null=True)

原文

I want to get all the issues.reference with status "Exemption" in Project model's exemption field, in order to send the it as a response.
As issue model has project as a foreign key field so I can't import Issue in Project model, that leads to circular import.

Project Model

'''
class Project(models.Model):

creation_date = models.DateTimeField(auto_now_add=True)
updated_date = models.DateTimeField(auto_now=True)
expiry_date = models.DateTimeField(null=True, blank=True)
exemption = ListField(models.CharField(max_length=128), blank=True, null=True)

'''

Issue Model

'''
class Issue(models.Model):

requestor = models.ForeignKey(User, related_name='issues', on_delete=models.CASCADE)
projects = models.ManyToManyField(Project, related_name='issues_projects')
reference = models.CharField(max_length=16, unique=True, editable=False, null=True)
status = models.CharField(max_length=12, choices=IssueStatus.choices, null=True)

'''

分享到QQ

分享到微博

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

发布评论

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

垂暮老矣 2025-02-12 15:21:32

在视图中，您可以简单地使用：

issue = Issue.objects.get() #your query to select the issue 
issue_project = issue.projects

#say you want to creation_date from above selected project.
creation_date = issue_project.creation_date 

# and so on

In views you can simply use:

issue = Issue.objects.get() #your query to select the issue 
issue_project = issue.projects

#say you want to creation_date from above selected project.
creation_date = issue_project.creation_date 

# and so on

回复收藏 0 原文

~没有更多了~