Check if an object exists

Since filter returns a QuerySet, you can use count to check how many results were returned. This is assuming you don’t actually need the results.

num_results = User.objects.filter(email = cleaned_info['username']).count()

After looking at the documentation though, it’s better to just call len on your filter if you are planning on using the results later, as you’ll only be making one sql query:

A count() call performs a SELECT COUNT(*) behind the scenes, so you should always use count() rather than loading all of the record into Python objects and calling len() on the result (unless you need to load the objects into memory anyway, in which case len() will be faster).

num_results = len(user_object)

Related Posts:

  1. sqlite3.OperationalError: unable to open database file
  2. OperationalError: database is locked
  3. Where does pip install its packages?
  4. Where does pip install its packages?
  5. django: TypeError: ‘tuple’ object is not callable
  6. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  7. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  8. No module named ‘psycopg2’
  9. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  10. No module named MySQLdb
  11. No module named MySQLdb
  12. How to check Django version
  13. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  14. is not JSON serializable
  15. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  16. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  17. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  18. No module named pkg_resources
  19. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  20. TypeError: tuple indices must be integers, not str
  21. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  22. django import error – No module named core.management
  23. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  24. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  25. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  26. Setting Django up to use MySQL
  27. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  28. OSError – Errno 13 Permission denied
  29. Pylint “unresolved import” error in Visual Studio Code
  30. Django – no such table exception
  31. django MultiValueDictKeyError error, how do I deal with it
  32. Django – no such table exception
  33. Is there a list of Pytz Timezones?
  34. Django – “no module named django.core.management”
  35. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  36. NumPy array is not JSON serializable
  37. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  38. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  39. super(type, obj): obj must be an instance or subtype of type
  40. Django Rest Framework — no module named rest_framework
  41. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  42. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  43. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  44. Django reverse lookup of foreign keys
  45. ImportError: No module named ‘django.core.urlresolvers’
  46. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  47. How to set environment variables in PyCharm?
  48. H14 error in heroku – “no web processes running”
  49. What does this Django regular expression mean? `?P`
  50. Is it better to use path() or url() in urls.py for django 2.0?
  51. What is a “slug” in Django?
  52. TemplateDoesNotExist at /
  53. No module named django but it is installed
  54. What is the easiest way to clear a database from the CLI with manage.py in Django?
  55. What does on_delete do on Django models?
  56. Find object in list that has attribute equal to some value (that meets any condition)
  57. How to check if a user is logged in (how to properly use user.is_authenticated)?
  58. The view didn’t return an HttpResponse object. It returned None instead
  59. CSV new-line character seen in unquoted field error
  60. gunicorn.errors.HaltServer: django
  61. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  62. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  63. How to query as GROUP BY in django?
  64. Error loading MySQLdb module: No module named ‘MySQLdb’
  65. What is related_name used for?
  66. TypeError: ManyRelatedManager object is not iterable
  67. ValueError: Must pass DataFrame with boolean values only
  68. What is the most efficient way to store a list in the Django models?
  69. Line is too long. Django PEP8
  70. __init__() got an unexpected keyword argument ‘user’
  71. TypeError: ‘float’ object is not subscriptable
  72. How to show all columns’ names on a large pandas dataframe?
  73. ImportError: No module named matplotlib.pyplot
  74. How to remove EOFError: EOF when reading a line?
  75. pygame.error: video system not initialized
  76. How to draw a circle in PyGame?
  77. TypeError: ‘numpy.float64’ object is not callable?
  78. Why do I get: “Length of values does not match length of index” error?
  79. How to remove all the punctuation in a string? (Python)
  80. Cross Entropy in PyTorch
  81. Convert hex to binary
  82. TypeError: ‘encoding’ is an invalid keyword argument for this function
  83. How to calculate a logistic sigmoid function in Python?
  84. Why is python setup.py saying invalid command ‘bdist_wheel’ on Travis CI?
  85. How to write bytes to file?
  86. PyLint “Unable to import” error – how to set PYTHONPATH?
  87. How do you split a list into evenly sized chunks?
  88. Ignoring NaNs with str.containsv
  89. How to split a string into a list of characters in Python?
  90. Find where python is installed (if it isn’t default dir)
  91. log2 in python math module
  92. Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()
  93. Error “‘type’ object has no attribute ‘__getitem__'” when iterating over list[“a”,”b”,”c”]
  94. Python: “TypeError: __str__ returned non-string” but still prints to output?
  95. Boolean Series key will be reindexed to match DataFrame index
  96. Printing one character at a time from a string, using the while loop
  97. Change the name of a key in dictionary
  98. ImportError: no module named win32api
  99. Python code to remove HTML tags from a string 
  100. Sorting list based on values from another list

Leave a Comment