How to update manytomany field in Django?

by

Note: This code will delete the bad ‘georfe’ author, as well as updating the books to point to the correct author. If you don’t want to do that, then use .remove() as @jcdyer’s answer mentions.

Can you do something like this?

george_author = Author.objects.get(name="George")
for book in Book.objects.filter(authors__name="Georfe"):
    book.authors.add(george_author.id)
    book.authors.filter(name="Georfe").delete()

I suspect that this would be easier if you had an explicit table joining the two models (with the “through” keyword arg) — in that case, you would have access to the relationship table directly, and could just do a .update(id=george_author.id) on it.

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Execute code when Django starts ONCE only?
  3. Programmatically saving image to Django ImageField
  4. Does SQLAlchemy have an equivalent of Django’s get_or_create?
  5. Custom Filter in Django Admin on Django 1.3 or below
  6. Django Aggregation: Summation of Multiplication of two fields
  7. How to redirect with post data (Django)
  8. Django: How to manage development and production settings?
  9. ImportError: No module named ‘django.core.urlresolvers’
  10. Django migration strategy for renaming a model and relationship fields
  11. What is the most efficient way to store a list in the Django models?
  12. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  13. How does Django Know the Order to Render Form Fields?
  14. Django server killed frequently
  15. Django Server Error: port is already in use
  16. How do you join two tables on a foreign key field using django ORM?
  17. How to create virtual env with python3
  18. How to make/use a custom database function in Django
  19. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  20. How to monkey patch Django?
  21. How to get the previous URL from a POST in Django
  22. creating a MIME email template with images to send with python / django
  23. FullCalendar in Django
  24. Heroku: ModuleNotFoundError :No module named ‘requests’
  25. Apache not serving django admin static files
  26. Django ChoiceField
  27. How to run cloned Django project?
  28. Writable nested serializer in django-rest-framework?
  29. Add custom form fields that are not part of the model (Django)
  30. Can a dictionary be passed to django models on create?

Leave a Comment