Django将记录创建到具有多个外键字段的模型中

2024-09-28 01:33:39 发布

您现在位置:Python中文网/ 问答频道 /正文

因此,我基本上有一个名为“指定”的模型,它从其他3个模型(课程、角色和人员)派生外键,我正在尝试将一个新记录保存到“指定”模型中,下面的代码显示了“指定”和“人员”模型。你知道吗

class Designations(models.Model):
    designation_id = models.AutoField(primary_key=True)
    curriculum = models.ForeignKey(Curricula, on_delete=models.CASCADE)
    role = models.ForeignKey(Roles, on_delete=models.CASCADE)
    staff = models.ForeignKey(Staffs, on_delete=models.CASCADE)

    class Meta:
        db_table = "arc_designations"
        unique_together = ('curriculum', 'role', 'staff')
        verbose_name_plural = "Designations"
        ordering = ['designation_id']

    def __str__(self):
        return '%s of %s %s (%s)' % (self.role.role_name,
                                     self.curriculum.course_period.course.course_abbreviation,
                                     self.curriculum.module_period.module.module_abbreviation,
                                     self.staff.staff_full_name)

class Staffs(models.Model):
    staff_id = models.AutoField(primary_key=True)
    admission_number = models.CharField(max_length=5,
                                        unique=True,
                                        help_text="Enter 5 digits",
                                        validators=[numeric_only, MinLengthValidator(5)])
    staff_full_name = models.CharField(max_length=70,
                                       help_text="Enter staff's full name",
                                       validators=[letters_only])
    created_by = UserForeignKey(auto_user_add=True,
                                editable=False,
                                related_name="staff_created_by",
                                db_column="created_by")
    created_at = models.DateTimeField(auto_now_add=True,
                                      editable=False)
    updated_by = UserForeignKey(auto_user=True,
                                editable=False,
                                related_name="staff_updated_by",
                                db_column="updated_by")
    updated_at = models.DateTimeField(auto_now=True,
                                      editable=False)
    roles = models.ManyToManyField(Roles, through='Designations')

    class Meta:
        db_table = "arc_staffs"
        verbose_name_plural = "Staffs"
        ordering = ['staff_id']

    def __str__(self):
        return '%s (S%s)' % (self.staff_full_name, self.admission_number)

我已经做了一个决定表单.py获取录取号码(员工模型中的字段)

class AssignRolesForm(forms.Form):
    admission_no = forms.CharField(max_length=40,
                                 widget=forms.TextInput(
                                     attrs={'class': 'form-control', 'aria-describedby': 'add-btn'}))

这是我的html:

<form action="{% url 'setInstructor' %}" method="POST" role="form">
                       {% csrf_token %}
                        <div class="form-group">
                            <div class="input-group">
                                {{ form.instructor }}
                              <span class="input-group-btn">
                                  <button type="submit" class="btn btn-default" id="add-btn">assign</button>
                              </span>
                            </div>
                        </div>
                    </form>

假设当我提交表格时,我希望在表格中输入的录取号码引用到员工模型中,然后将其PK保存到员工字段中,课程和角色字段引用各自模型的PK 1。我将如何在中编写函数视图.py单击“提交”时将记录保存到指定模型中

这是电话号码视图.py我试过但没用

@require_POST
def setInstructor(request):
    form = AssignRolesForm(request.POST)

    if form.is_valid():
        staff = Staffs(admission_number=form.cleaned_data['instructor'])
        role = Roles(pk=1)
        curriculum = Curricula(pk=1)
        designation = Designations(staff=staff, role=role, curriculum=curriculum)
        designation.save()

    return redirect('index')

Tags: name模型selfformidtruebymodels

热门问题