django DRF: how to Get related model field in serializer

Question

I'm trying to return a HttpResponse from Django Rest Framework including data from 3 linked models. The models are

class ErrorDb(models.Model):
    error_id = models.AutoField(primary_key=True)
    error_msg = models.CharField(max_length=500)
    user_name = models.CharField(max_length=45)
    class Meta:
        #managed = False
        db_table = 'error_db'

class ErrordbKey(models.Model):
    key_id = models.AutoField(primary_key=True)
    parent_areaid = models.IntegerField(blank=True, null=True)

    class Meta:
        #managed = False
        db_table = 'errordb_key'


class ErrordbMapping(models.Model):
    table_id = models.AutoField(primary_key=True)
    key = models.ForeignKey(ErrordbKey)
    error = models.ForeignKey(ErrorDb)
    class Meta:
        #managed = False
        db_table = 'errordb_mapping'
        unique_together = (('key', 'error'),)

following is the views.py:

def area_detail(request, area_id):

obj_ErrordbKey = ErrordbKey.objects.filter(parent_areaid=area_id)
#objects to get specific rows where area_id exists

if request.method == 'GET':
    obj_ErrordbMapping = ErrordbMapping.objects.filter(key__in=obj_ErrordbKey)
    serializer = TaskSerializer(obj_ErrordbMapping, many=True)
    return Response(serializer.data)

I tried following serialization methods,please see the foeign key relation ship serializers.py:

class ErrorDbSerializer(serializers.HyperlinkedModelSerializer):
    class Meta:
        model = ErrorDb
        fields = ('error_msg','user_name')


class ErrordbKeySerializer(serializers.HyperlinkedModelSerializer):
    class Meta:
        model = ErrordbKey
        fields = ('area', 'filename')


class TaskSerializer(serializers.HyperlinkedModelSerializer):
    # errorDbdata = ErrorDbSerializer()
    # errordbKeydata = ErrordbKeySerializer()
    error = ErrorDbSerializer(source='error')
    key = ErrordbKeySerializer(source='key')
    class Meta:
        model = ErrordbMapping
        fields = ('key', 'error')

Ivan Semochkin · Answer 1 · 2016-07-11T20:21:29.323

4

you can use source of serializer.CharField and access to field throw fk as usual:

class TaskSerializer(serializers.HyperlinkedModelSerializer):
    error_field = serializers.CharField(read_only=True, source='error.error_msg')
    key_field = serializers.CharField(read_only=True, source='key.parent_areaid')
    class Meta:
        model = ErrordbMapping
        fields = ('error_field', 'key_field')

edited Jul 11 '16 at 20:21

answered Jul 11 '16 at 20:13

Ivan Semochkin

8,649
3
43
75

I have tried your code but still not able to get any o/p . just a empty list – vm-power Jul 11 '16 at 20:28
@vm-power you have some exception or what? – Ivan Semochkin Jul 11 '16 at 20:28
I can see the valid data objects from the django shell : >>>obj_ErrordbKey = ErrordbKey.objects.filter(parent_areaid=3) >>>obj_ErrordbMapping = ErrordbMapping.objects.filter(key__in=obj_ErrordbKey) >>> obj_ErrordbMapping [, , ] – vm-power Jul 11 '16 at 20:29

django DRF: how to Get related model field in serializer

1 Answers1