'QuerySet' object has no attribute 'name' Django

Question

So I have a get function

class HorseEquipmentView(APIView):
    lookup_url_kwarg = 'horse'

    def get (self, request, format = None):
        horse = 1     
        if horse != None:
            tab = []
            #queryset = HorseEquipment.objects.raw('SELECT H.horse_id, E.name FROM horse_equipment H JOIN equipment E ON H.equipment_id = E.id WHERE H.horse_id =' + str(horse))
            queryset = HorseEquipment.objects.filter(horse_id=horse).select_related("equipment")
            for i in queryset:
                i.equipment = Equipment.objects.filter(id = 1).name  
            #equipment = HorseEquipment.objects.filter(horse_id=horse).select_related('equipment')
            serializer = HorseEquipmentSerializer(queryset, many = True)
            return Response(serializer.data)
        else:
            return Response(status = status.HTTP_400_BAD_REQUEST)

and my Equipment Model:

class Equipment(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(unique=True, max_length=30, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'equipment'

So it has id and name attributes but somehow it gives me error on my get function, precisely on my for loop where I refer to "name" attribute. Can you help me find out what's wrong?

You need to re-read the section about objects.filter(...) vs objects.get(...). — thebjorn
– thebjorn, Commented May 15, 2021 at 7:47

Lewis · Accepted Answer · 2021-05-15 07:56:36Z

3

You're using .filter() which will return a QuerySet and not a instance of a model. You should use .get() for this scenario to access the name attribute.

Replace:

Equipment.objects.filter(id=1).name

With

Equipment.objects.get(id=1).name

answered May 15, 2021 at 7:56

Lewis

2,7981 gold badge16 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

'QuerySet' object has no attribute 'name' Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related