Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What to do when Django query returns none? It gives me error

Tags:

python

django

to_friend = User.objects.filter(username=friend_q)[0:1]

If 'friend_q' is NOT inside the User.username...it will give error. What is the recommended tactic?

Thank you

like image 258
TIMEX Avatar asked Oct 09 '09 09:10

TIMEX


3 Answers

If friend_q is not a user present in the database, to_friend will be equal to an empty list.

>>> from django.contrib.auth.models import User
>>> User.objects.filter(username='does-not-exist')
[]

However, it's better to use the get() method to lookup a specific entry:

>>> User.objects.get(username='does-exist')
<User: does-exist>
>>> User.objects.get(username='does-not-exist')
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/usr/lib/python2.5/django/db/models/manager.py", line 120, in get
  File "/usr/lib/python2.5/django/db/models/query.py", line 305, in get
DoesNotExist: User matching query does not exist.

You can now catch the DoesNotExist exception and take appropriate actions.

try:
   to_friend = User.objects.get(username=friend_q)
except User.DoesNotExist:
   # do something, raise error, ...
like image 179
math Avatar answered Sep 16 '22 13:09

math


  1. FWIW, Username is unique. So U can use

    to_friend = User.objects.get(username=friend_q)
    
  2. If you want to raise a 404 when the user doesn't exist, you may as well,

    from django.shortcuts import get_object_or_404
    to_friend = get_object_or_404(User,username=friend_q)
    
  3. To prevent error, you may simply put it in the try except block, very pythonic.

    try:
       to_friend = User.objects.get(username=friend_q)
    except User.DoesNotExist:
       to_friend = None
    
  4. Since this is a common requirement, you should consider defining get_user_or_none on the UserManager, and other managers that would require None return, similar to get_object_or_404. This was in consideration for django core, but was not included, for what ever the reason. Still, is a handy, 4 line function, for models that need None back.

like image 45
lprsd Avatar answered Sep 20 '22 13:09

lprsd


The reason you're getting an error is because you're trying to evaluate the Query object when there's nothing in it. The [0:1] at the end is attempting to take the first item out of an empty list. If you split up the expression a little like below, you can check for an empty list before taking an element out of it.

to_friends = User.objects.filter(username=friend_q)
if to_friends:
    to_friend = to_friends[0]
like image 32
Josh Smeaton Avatar answered Sep 16 '22 13:09

Josh Smeaton