How to get primary keys of objects created using django bulk_create

django django-models django-views django-queryset
mikec picture mikec · Apr 10, 2013 · Viewed 29.1k times · Source

Is there a way to get the primary keys of the items you have created using the bulk_create feature in django 1.4+?

Answer

Or Duan picture Or Duan · Sep 4, 2016

2016

Since Django 1.10 - it's now supported (on Postgres only) here is a link to the doc.

>>> list_of_objects = Entry.objects.bulk_create([
...     Entry(headline="Django 2.0 Released"),
...     Entry(headline="Django 2.1 Announced"),
...     Entry(headline="Breaking: Django is awesome")
... ])
>>> list_of_objects[0].id
1

From the change log:

Changed in Django 1.10: Support for setting primary keys on objects created using bulk_create() when using PostgreSQL was added

Related questions

Raw SQL queries in Django views

How would I perform the following using raw SQL in views.py? from app.models import Picture def results(request): all = Picture.objects.all() yes = Picture.objects.filter(vote='yes').count() return render_to_response('results.html', {'picture':picture, 'all':…

Read More
'RelatedManager' object is not iterable Django

Hey i have looked around through some simliar posts here on SO but havent found anything that has solved my problem. I have the following models, from django.db import models class Areas(models.Model): name = models.CharField(max_length = 120) …

Read More
Django request get parameters

In a Django request I have the following: POST:<QueryDict: {u'section': [u'39'], u'MAINS': [u'137']}> How do I get the values of section and MAINS? if request.method == 'GET': qd = request.GET elif request.method == 'POST': qd = …

Read More