如何向含ForeignKey与OneToOneField的Django模型插入数据？

1. 模型定义示例（假设你的模型结构如下） #

先给出典型的包含ForeignKey和OneToOneField的Django模型，方便后续说明：

from django.db import models

class Department(models.Model):
    name = models.CharField(max_length=100)
    location = models.CharField(max_length=100)

    def __str__(self):
        return self.name

class Employee(models.Model):
    name = models.CharField(max_length=100)
    email = models.EmailField(unique=True)
    department = models.ForeignKey(Department, on_delete=models.CASCADE)  # 外键关联部门

class EmployeeProfile(models.Model):
    employee = models.OneToOneField(Employee, on_delete=models.CASCADE, primary_key=True)
    phone = models.CharField(max_length=20)
    address = models.TextField()

2. 常见错误视图示例 #

假设你之前的报错视图是这样的（直接传递ID而非关联实例，导致类型错误）：

from django.http import JsonResponse
from .models import Department, Employee, EmployeeProfile

def create_employee(request):
    if request.method == 'POST':
        # 错误写法：外键/一对一字段需传入模型实例，而非字符串或ID
        employee = Employee.objects.create(
            name=request.POST.get('name'),
            email=request.POST.get('email'),
            department=request.POST.get('department_id')
        )
        profile = EmployeeProfile.objects.create(
            employee=employee.id,
            phone=request.POST.get('phone'),
            address=request.POST.get('address')
        )
        return JsonResponse({'status': 'success'})

常见报错：Cannot assign "'1'": "Employee.department" must be a "Department" instance.

3. 修正后的POST视图方法 #

方法一：手动处理关联实例（适合简单场景） #

from django.http import JsonResponse, HttpResponseBadRequest
from .models import Department, Employee, EmployeeProfile

def create_employee(request):
    if request.method == 'POST':
        # 1. 校验并获取部门实例
        try:
            department_id = int(request.POST.get('department_id'))
            department = Department.objects.get(id=department_id)
        except (ValueError, Department.DoesNotExist):
            return HttpResponseBadRequest('无效的部门ID')
        
        # 2. 创建Employee实例（传入已获取的department实例）
        employee = Employee.objects.create(
            name=request.POST.get('name'),
            email=request.POST.get('email'),
            department=department
        )
        
        # 3. 创建EmployeeProfile实例（关联刚创建的employee实例）
        EmployeeProfile.objects.create(
            employee=employee,
            phone=request.POST.get('phone'),
            address=request.POST.get('address')
        )
        
        return JsonResponse({'status': 'success', 'employee_id': employee.id})

方法二：使用Django表单（推荐，自动校验+简化逻辑） #

先定义表单：

from django import forms
from .models import Employee, EmployeeProfile

class EmployeeForm(forms.ModelForm):
    class Meta:
        model = Employee
        fields = ['name', 'email', 'department']

class EmployeeProfileForm(forms.ModelForm):
    class Meta:
        model = EmployeeProfile
        fields = ['phone', 'address']

再编写视图：

from django.shortcuts import render, redirect
from .forms import EmployeeForm, EmployeeProfileForm

def create_employee(request):
    if request.method == 'POST':
        emp_form = EmployeeForm(request.POST)
        profile_form = EmployeeProfileForm(request.POST)
        if emp_form.is_valid() and profile_form.is_valid():
            employee = emp_form.save()
            # 关联员工实例到档案表单，再保存
            profile = profile_form.save(commit=False)
            profile.employee = employee
            profile.save()
            return redirect('employee_list')  # 跳转到员工列表页
    else:
        emp_form = EmployeeForm()
        profile_form = EmployeeProfileForm()
    return render(request, 'create_employee.html', {'emp_form': emp_form, 'profile_form': profile_form})

4. 从UI完成数据插入的步骤 #

方式一：基于表单的HTML页面 #

创建模板create_employee.html：

<form method="POST">
    {% csrf_token %}
    <h3>员工基本信息</h3>
    {{ emp_form.as_p }}
    
    <h3>员工档案信息</h3>
    {{ profile_form.as_p }}
    
    <button type="submit">提交</button>
</form>

• 页面会自动渲染部门下拉选择框（ForeignKey字段默认生成ModelChoiceField，展示所有已存在的Department实例）
• 提交后表单自动校验数据，关联字段自动处理实例关联，无需手动转换ID

方式二：AJAX提交（前后端分离场景） #

前端JS示例（jQuery）：

$('#submit-btn').click(function(e) {
    e.preventDefault();
    $.ajax({
        url: '/create-employee/',
        method: 'POST',
        data: {
            'name': $('#name').val(),
            'email': $('#email').val(),
            'department_id': $('#department').val(),  // 传递已存在的部门ID
            'phone': $('#phone').val(),
            'address': $('#address').val(),
            'csrfmiddlewaretoken': $('input[name=csrfmiddlewaretoken]').val()
        },
        success: function(response) {
            alert('创建成功');
        },
        error: function(xhr) {
            alert('创建失败：' + xhr.responseText);
        }
    });
});

• 必须传递csrfmiddlewaretoken防止CSRF攻击
• 部门字段需传入数据库中已存在的Department的ID，后端视图要先校验实例是否存在

内容的提问来源于stack exchange，提问作者Asad Sheikh