ow to ‘bulk update’ with Django?

Update:

Django 2.2 version now has a bulk_update.

Old answer:

Refer to the following django documentation section

Updating multiple objects at once

In short you should be able to use:

ModelClass.objects.filter(name='bar').update(name="foo")

You can also use F objects to do things like incrementing rows:

from django.db.models import F
Entry.objects.all().update(n_pingbacks=F('n_pingbacks') + 1)

See the documentation.

However, note that:

  • This won’t use ModelClass.save method (so if you have some logic inside it won’t be triggered).
  • No django signals will be emitted.
  • You can’t perform an .update() on a sliced QuerySet, it must be on an original QuerySet so you’ll need to lean on the .filter() and .exclude() methods.

Related Posts:

  1. ‘NOT NULL constraint failed’ after adding to models.py
  2. Django __str__ returned non-string (type NoneType)
  3. How can I upgrade specific packages using pip and a requirements file?
  4. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  5. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  6. How to switch Python versions in Terminal?
  7. django display message after POST form submit
  8. CommandError: You must set settings.ALLOWED_HOSTS if DEBUG is False
  9. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  10. “The path python3 (from –python=python3) does not exist” error
  11. How can I get the file name from request.FILES?
  12. Django TemplateDoesNotExist?
  13. Django: no such table: django_session
  14. Implementing a SOA in Django using celery
  15. Django 1.7 upgrade error: AppRegistryNotReady: Apps aren’t loaded yet
  16. Python/Django: log to console under runserver, log to file under Apache
  17. What is a NoReverseMatch error, and how do I fix it?
  18. python: can’t open file ‘manage.py’: [Errno 2] No such file or directory
  19. What is the use of PYTHONUNBUFFERED in docker file?
  20. What is a “slug” in Django?
  21. Cannot find command ‘git’ – windows
  22. How to revert the last migration?
  23. What does on_delete do on Django models?
  24. Output Django queryset as JSON
  25. Getting stuck at Django error: No module named registration
  26. How to query as GROUP BY in django?
  27. What is the most efficient way to store a list in the Django models?
  28. __init__() got an unexpected keyword argument ‘user’
  29. Why do I get sqlite error, “unable to open database file”?
  30. Where does pip install its packages?
  31. Does Python have a toString() equivalent, and can I convert a class to String?
  32. Where does pip install its packages?
  33. django: TypeError: ‘tuple’ object is not callable
  34. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  35. No module named ‘psycopg2’
  36. Is #include bad practice?
  37. No module named MySQLdb
  38. No module named MySQLdb
  39. How to check Django version
  40. python3 is not recognized as an internal or external command, operable program or batch file showing for creating django runserver
  41. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  42. is not JSON serializable
  43. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  44. Install mysql-python (Windows)
  45. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  46. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  47. No module named pkg_resources
  48. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  49. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  50. django import error – No module named core.management
  51. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  52. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  53. Setting Django up to use MySQL
  54. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  55. OSError – Errno 13 Permission denied
  56. React Error: Target Container is not a DOM Element
  57. Pylint “unresolved import” error in Visual Studio Code
  58. Django – no such table exception
  59. django MultiValueDictKeyError error, how do I deal with it
  60. Django – no such table exception
  61. Print type of variable in python3.5 on django 1.8
  62. Is there a list of Pytz Timezones?
  63. Django – “no module named django.core.management”
  64. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  65. In Django, how do I know the currently logged-in user?
  66. NumPy array is not JSON serializable
  67. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  68. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  69. super(type, obj): obj must be an instance or subtype of type
  70. Django Rest Framework — no module named rest_framework
  71. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  72. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  73. sqlite3.OperationalError: unable to open database file
  74. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  75. Django reverse lookup of foreign keys
  76. ImportError: No module named ‘django.core.urlresolvers’
  77. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  78. How to set environment variables in PyCharm?
  79. H14 error in heroku – “no web processes running”
  80. What does this Django regular expression mean? `?P`
  81. OperationalError: database is locked
  82. Is it better to use path() or url() in urls.py for django 2.0?
  83. Uncaught Reference Error: stLight is not defined (in Chrome only)
  84. TemplateDoesNotExist at /
  85. No module named django but it is installed
  86. What is the easiest way to clear a database from the CLI with manage.py in Django?
  87. Check if an object exists
  88. Find object in list that has attribute equal to some value (that meets any condition)
  89. How to check if a user is logged in (how to properly use user.is_authenticated)?
  90. The view didn’t return an HttpResponse object. It returned None instead
  91. CSV new-line character seen in unquoted field error
  92. gunicorn.errors.HaltServer: django
  93. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  94. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  95. Error loading MySQLdb module: No module named ‘MySQLdb’
  96. What is related_name used for?
  97. TypeError: ManyRelatedManager object is not iterable
  98. Line is too long. Django PEP8
  99. Why do I need Nginx and something like Gunicorn?
  100. Why do I need nginx when I have uWSGI

Leave a Comment

tech