I've an interesting question and want expert views on it.
I've the following models.
class A(models.Model):
b = ForeignKey(B)
c = ForeignKey(B)
d = ForeignKey(B)
class B(models.Model):
pass
class C(models.Model):
pass
class D(models.Model):
pass
Following are my serializers:
class ASearializer(serializers.Serializer):
b = BSearializer()
c = CSearializer()
d = DSearializer()
class Meta:
model = A
fields = ('b', 'c', 'd')
def create(self, data):
# I create the instance of A, B, C and D.
return instance_of_A
class BSearializer(serializers.Serializer):
class Meta:
model = B
fields = '__all__'
class CSearializer(serializers.Serializer):
class Meta:
model = C
fields = '__all__'
class DSearializer(serializers.Serializer):
class Meta:
model = D
fields = '__all__'
My views:-
class View(CreateAPIView):
serializer_class = Aserializer
queryset = A.object.all().select_related('b').select_related('c').select_related('d')
Everything works as expected. The request and the response works correctly.
However, the queries fired are not the way it was expected. While returning the data, DRF fires 3 extra queries to filter B, C and D, thereby ignoring the queryset.
1) How to make DRF fire one single JOIN query?