在django中高效地导入多个嵌套外键关系中的所有对象

from django.db import models

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

class ModelB(models.Model):
    name = models.CharField(max_length=100)
    model_a = models.ForeignKey(ModelA, on_delete=models.CASCADE)

class ModelC(models.Model):
    name = models.CharField(max_length=100)
    model_b = models.ForeignKey(ModelB, on_delete=models.CASCADE)

# 在视图函数中使用select_related和prefetch_related方法
def my_view(request):
    queryset = ModelA.objects.select_related('modelb_set__modelc_set').prefetch_related('modelb_set__modelc_set')
    # 这里的modelb_set和modelc_set是根据related_name或默认的反向关联名生成的

    # 遍历查询结果
    for model_a in queryset:
        # 访问嵌套的外键关联对象
        for model_b in model_a.modelb_set.all():
            for model_c in model_b.modelc_set.all():
                # 处理model_c对象

    # 其他操作...