Django技术问询：如何通过User表从PersonalDetails获取用户资料？

现有代码存在的问题 #

1. 多次查询数据库：视图中连续三次执行get查询（User、Representative、PersonalDetails），触发N+1问题，性能低下。
2. 序列化器误用：用UserProfileSerializer（基于User模型）去序列化PersonalDetails实例，字段完全不匹配，会导致序列化错误。
3. 视图配置混乱：queryset设置为PersonalDetails.objects.all()，但实际逻辑是查询User，不符合DRF视图的设计规范。

正确实现方案 #

1. 利用Django跨表关联特性直接访问

Django支持通过双下划线跨外键关联访问，从User实例出发，可直接通过user.representative.personal_details获取对应的PersonalDetails数据（注意处理representative为null的情况）。

2. 优化序列化器（嵌套序列化）

如果需要返回包含关联层级的完整数据，可以通过嵌套序列化器实现：

# serializers.py
from rest_framework import serializers
from .models import User, Representative, PersonalDetails

class PersonalDetailsSerializer(serializers.ModelSerializer):
    class Meta:
        model = PersonalDetails
        fields = ('id', 'name_en', 'dob')

class RepresentativeSerializer(serializers.ModelSerializer):
    personal_details = PersonalDetailsSerializer()
    class Meta:
        model = Representative
        fields = ('id', 'role', 'personal_details')

class UserProfileSerializer(serializers.ModelSerializer):
    representative = RepresentativeSerializer()
    class Meta:
        model = User
        fields = ('id', 'first_name', 'last_name', 'representative')

如果只需要单独返回PersonalDetails数据，也可以用SerializerMethodField直接提取：

class UserProfileSerializer(serializers.ModelSerializer):
    personal_details = serializers.SerializerMethodField()

    def get_personal_details(self, obj):
        # 处理representative为null的情况
        if obj.representative:
            return PersonalDetailsSerializer(obj.representative.personal_details).data
        return None

    class Meta:
        model = User
        fields = ('id', 'first_name', 'last_name', 'personal_details')

3. 优化视图（避免N+1查询）

使用DRF的RetrieveAPIView，通过select_related预加载关联数据，一次性完成查询：

# views.py
from rest_framework.generics import RetrieveAPIView
from rest_framework.permissions import AllowAny
from rest_framework.exceptions import NotFound
from .models import User
from .serializers import UserProfileSerializer, PersonalDetailsSerializer

# 返回包含关联层级的用户数据
class UserProfileDetailView(RetrieveAPIView):
    permission_classes = [AllowAny,]
    # 预加载关联表，避免多次查询
    queryset = User.objects.select_related('representative', 'representative__personal_details')
    serializer_class = UserProfileSerializer

# 如果只需要返回PersonalDetails数据
class UserPersonalDetailsView(RetrieveAPIView):
    permission_classes = [AllowAny,]
    serializer_class = PersonalDetailsSerializer

    def get_object(self):
        user = User.objects.select_related('representative__personal_details').get(id=self.kwargs['pk'])
        if not user.representative:
            raise NotFound(detail="该用户未关联Representative信息")
        return user.representative.personal_details

4. URL配置示例

确保URL参数对应User的主键：

# urls.py
from django.urls import path
from .views import UserProfileDetailView, UserPersonalDetailsView

urlpatterns = [
    path('user/<int:pk>/profile/', UserProfileDetailView.as_view(), name='user-profile'),
    path('user/<int:pk>/personal-details/', UserPersonalDetailsView.as_view(), name='user-personal-details'),
]

内容的提问来源于stack exchange，提问作者Jerin Raju