How to get data related from another table django rest framework

Question

I have three model Pesticide, Disease and Instruction what i want is to get all disease with relation to pesticide which relate to instruction model

class Disease(models.Model):
    name = models.CharField(max_length=100)
    def __str__(self):
        return self.name

class Pesticide(models.Model):
    name = models.CharField(max_length=50)
    def __str__(self):
        return self.name


class Treatment(models.Model):
    disease = models.ForeignKey(Disease, related_name='treatments', on_delete=models.DO_NOTHING)
    pesticide = models.ForeignKey(Pesticide, related_name='treatments', on_delete=models.DO_NOTHING)

    def __str__(self):
        return self.instruction

and serializer

class PesticideSerializer(serializers.ModelSerializer):
   
    class Meta:
        model = Pesticide
        fields = ('id', 'name')

class DiseaseSerializer(serializers.ModelSerializer):
    pesticides = PesticideSerializer(source='treatment_set', read_only=True)
    class Meta:
        model = Disease
        fields = [

            'id',
            'name',
            'pesticides',
           
        ]

My problem is that i can not get pesticides in django serializer

JPG · Accepted Answer · 2020-09-01 08:59:20Z

1

Use serializers.SerializerMethodField as

class DiseaseSerializer(serializers.ModelSerializer):
    pesticides = serializers.SerializerMethodField()

    def get_pesticides(self, disease):
        pesticide_qs = Pesticide.objects.filter(treatments__disease=disease)
        return PesticideSerializer(pesticide_qs, many=True).data

    class Meta:
        model = Disease
        fields = ['id', 'name', 'pesticides']

answered Sep 1, 2020 at 8:59

JPG

89.4k24 gold badges164 silver badges235 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Epimark Chami Over a year ago

I face another question how do i filter to get only single pesticide with instruction based on disease

JPG Over a year ago

better to ask a new question

Roham · Accepted Answer · 2020-09-01 09:16:22Z

0

I think changing the line pesticides = PesticideSerializer(source='treatment_set', read_only=True) in DiseaseSerializer to pesticides = PesticideSerializer(source='treatment_set', read_only=True, many=True) will solve your problem (you should add many=True because the relation type is one to many).

answered Sep 1, 2020 at 9:16

Roham

2,1202 gold badges8 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to get data related from another table django rest framework

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related