无外键时序列化器嵌套表返回Null问题求助

你的问题核心在于直接用ModelSerializer嵌套关联字段，但lastmeasurementid本身只是存储ID的整数字段，序列化器无法自动关联到Measurements表的对应记录，所以返回Null。另外你序列化器里写的db_column='measurementTime'是无效的——Devices模型里根本没有这个字段，这也会加重问题。

下面是具体的修正方案：

基础修正版序列化器 #

用SerializerMethodField手动实现ID到对应Measurement记录的关联查询：

from rest_framework import serializers
from .models import Devices, Measurements

class MeasurmentsSerializer(serializers.ModelSerializer):
    class Meta:
        model = Measurements
        fields = ('measurementid','measurement')

class DeviceSerializer(serializers.ModelSerializer):
    lastmeasurementid = serializers.SerializerMethodField()

    def get_lastmeasurementid(self, obj):
        # 通过存储的Measurement ID查询对应记录
        if obj.lastmeasurementid:
            try:
                measurement = Measurements.objects.get(measurementid=obj.lastmeasurementid)
                return MeasurmentsSerializer(measurement).data
            except Measurements.DoesNotExist:
                return None
        return None

    class Meta:
        model = Devices
        fields = ("devicename", 'deviceid', 'lastmeasurementid')

优化查询（避免N+1性能问题） #

如果是批量查询Device，上面的写法会导致每个Device都发起一次Measurements查询，性能很差。可以在视图中用自定义预取优化：

from django.db.models import Prefetch
from rest_framework.views import APIView
from rest_framework.response import Response
from .models import Devices, Measurements
from .serializers import DeviceSerializer

class DeviceListView(APIView):
    def get(self, request):
        # 预取所有关联的Measurement，避免重复查询
        devices = Devices.objects.all().prefetch_related(
            Prefetch(
                'measurment_details',
                queryset=Measurements.objects.all(),
                to_attr='related_measurements'
            )
        )
        serializer = DeviceSerializer(devices, many=True)
        return Response(serializer.data)

然后修改序列化器的get_lastmeasurementid方法，改用预取的数据：

def get_lastmeasurementid(self, obj):
    if obj.lastmeasurementid:
        # 从预取的列表中过滤对应ID的记录
        measurement = next((m for m in obj.related_measurements if m.measurementid == obj.lastmeasurementid), None)
        if measurement:
            return MeasurmentsSerializer(measurement).data
    return None

额外建议：尽量使用外键约束 #

虽然你提到“无外键”，但如果业务上lastmeasurementid确实关联Measurements的measurementid，建议给Devices模型添加外键约束（可以保持on_delete=models.DO_NOTHING适配原有逻辑）：

# 修改Devices模型
class Devices(models.Model):
    devicename = models.CharField(db_column='deviceName', unique=True, max_length=128)  
    lastmeasurementid = models.ForeignKey(
        Measurements, 
        on_delete=models.DO_NOTHING, 
        blank=True, 
        null=True,
        db_column='lastMeasurementId',
        related_name='related_device'
    )

这样序列化器可以简化为：

class DeviceSerializer(serializers.ModelSerializer):
    lastmeasurementid = MeasurmentsSerializer()
    
    class Meta:
        model = Devices
        fields = ("devicename", 'deviceid', 'lastmeasurementid')

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