Django bulk_create with ignore rows that cause IntegrityError?

by

This is now possible on Django 2.2

Django 2.2 adds a new ignore_conflicts option to the bulk_create method, from the documentation:

On databases that support it (all except PostgreSQL < 9.5 and Oracle), setting the ignore_conflicts parameter to True tells the database to ignore failure to insert any rows that fail constraints such as duplicate unique values. Enabling this parameter disables setting the primary key on each model instance (if the database normally supports it).

Example:

Entry.objects.bulk_create([
    Entry(headline="This is a test"),
    Entry(headline="This is only a test"),
], ignore_conflicts=True)

More Related Contents:

  1. IntegrityError duplicate key value violates unique constraint – django/postgres
  2. How to install libpq-fe.h?
  3. How to reset the sequence for IDs on PostgreSQL tables
  4. Django: What are the best practices to migrate a project from sqlite to PostgreSQL
  5. Django: permission denied when trying to access database after restore (migration)
  6. Migrating existing auth.User data to new Django 1.5 custom user model?
  7. Django and postgresql schemas
  8. Docker-compose with django could not translate host name “db” to address: Name or service not known
  9. Different db for testing in Django?
  10. How to customize user profile when using django-allauth
  11. How to add url parameters to Django template url tag?
  12. Override default queryset in Django admin
  13. Need to convert a string to int in a django template
  14. Django migrate –fake and –fake-initial explained
  15. Creating a model and related models with Inline formsets
  16. Use Django ORM as standalone [duplicate]
  17. _set in Django for a queryset
  18. Django: How to get current user in admin forms?
  19. Docker app server ip address 127.0.0.1 difference of 0.0.0.0 ip
  20. How to add data into ManyToMany field?
  21. ImportError: No module named django.core.wsgi Apache + VirtualEnv + AWS + WSGI
  22. Django admin: How to display a field that is marked as editable=False’ in the model?
  23. django unit tests without a db
  24. How to force a user logout in Django?
  25. Django Rest Framework: Disable field update after object is created
  26. Django unique_together with nullable ForeignKey
  27. Default image for ImageField in Django’s ORM
  28. How to dynamically provide lookup field name in Django query? [duplicate]
  29. Django: ManyToMany filter matching on ALL items in a list
  30. django : Serving static files through nginx

Leave a Comment