django queryset return single value

Question

I have the following -

obj.owner_id = Owner.objects.filter(owner_name=owner_obj).values_list('owner_id')[0]

Problem is the value it's returning is a tuple. Specifically this -

(786,)

All I want to return is the integer value or 786.

What am I doing wrong?

Answer 1

For posterity, this also works and is (in my opinion) the cleanest option of all:

Owner.objects.values_list('owner_id', flat=True).get(owner_name=owner_obj)

Answer 2

Assuming owner_name is unique, either of these will do the trick:

• owner_id = Owner.objects.only('owner_id').get(owner_name=owner_name).owner_id
• owner_id = Owner.objects.values('owner_id').get(owner_name=owner_name)['owner_id']
• owner_id = Owner.objects.values_list('owner_id', flat=True).get(owner_name=owner_name)

Documentation:

• only()
• values()
• values_list()