Override Django (DRF) Serializer object GET

Question

I'm trying to "inject" some raw sql into my DRF nested Serializer:

# SERIALIZERS

class CarSerializer(serializers.ModelSerializer):

    class Meta:
        model = Car
        fields = '__all__'

class DriverSerializer(serializers.ModelSerializer):
    car = CarSerializer()   # <--- here I don't want to get the Car object but rather inject a raw sql.

    class Meta:
        model = Driver
        fields = '__all__'

The SQL injection is needed to request for a specific version of the data since I'm using MariaDB versioning tables but this is not relevant. How do I override the method that gets the object from CarSerializer? Thank you.

question from:https://stackoverflow.com/questions/66063405/override-django-drf-serializer-object-get

Answer 1

This is untested but I think you want to override the __init__ in DriverSerializer and then load the result of your raw SQL via data, something like this:

class DriverSerializer(serializers.ModelSerializer):
     [...]
     def __init__(self, *args, **kwargs):
          super(DriverSerializer, self).__init__(*args, **kwargs)
          name_map = {'column_1': 'obj_attr_1', 'column_2': 'obj_attr_1', 'pk': 'id'}
          raw = Car.objects.raw('SELECT ... FROM ...', translations=name_map)
          data = {k: getattr(raw[0], k) for k in name_map.keys()}
          self.car = CarSerializer(data=data)