python - Django Admin Site 两个模型使用外键组合成一个模型
问题描述
我有这张表 StudentProfile
和表StudentEnrollmentRecord,我只想在学生用户之前添加一列,如下图所示,
这是我在 model.py 中的代码
class StudentProfile(models.Model):
LRN = models.CharField(max_length=500,null=True)
Firstname = models.CharField(max_length=500,null=True,blank=True)
Middle_Initial = models.CharField(max_length=500,null=True,blank=True)
Lastname = models.CharField(max_length=500,null=True,blank=True)
class StudentsEnrollmentRecord(models.Model):
Student_Users = models.ForeignKey(StudentProfile, related_name='+', on_delete=models.CASCADE,null=True)
School_Year = models.ForeignKey(SchoolYear, related_name='+', on_delete=models.CASCADE, null=True, blank=True)
Courses = models.ForeignKey(Course, related_name='+', on_delete=models.CASCADE, null=True, blank=True)
Section = models.ForeignKey(Section, related_name='+', on_delete=models.CASCADE, null=True,blank=True)
Payment_Type = models.ForeignKey(PaymentType, related_name='+', on_delete=models.CASCADE, null=True)
Education_Levels = models.ForeignKey(EducationLevel, related_name='+', on_delete=models.CASCADE,blank=True,null=True)
这是我在 admin.py 中的代码
class StudentsEnrollmentRecordAdmin(admin.ModelAdmin):
list_display = ('Student_Users', 'School_Year', 'Courses', 'Section', 'Payment_Type', 'Education_Levels')
ordering = ('Education_Levels',)
list_filter = ('Education_Levels','Section','Student_Users')
解决方案
您需要在 Admin 类中定义一个单独的函数来从相关对象中检索列:
class StudentsEnrollmentRecordAdmin(admin.ModelAdmin):
...
def lrn(self, obj):
return obj.Student_Users.lrn
然后在list_display
list_display = ('lrn', ...)
我还建议使用list_select_related
它,这样它就不会为每一行查询数据库。
class StudentsEnrollmentRecordAdmin(admin.ModelAdmin):
...
list_select_related = ('Student_Users')