CODEWITHSUNDEEP
djangodjango-models
Alexis Métaireau
Alexis Métaireau

Reputation: 11215

Bulk create model objects in django

I have a lot of objects to save in database, and so I want to create Model instances with that.

With django, I can create all the models instances, with MyModel(data), and then I want to save them all.

Currently, I have something like that:

for item in items:
    object = MyModel(name=item.name)
    object.save()

I'm wondering if I can save a list of objects directly, eg:

objects = []
for item in items:
    objects.append(MyModel(name=item.name))
objects.save_all()

How to save all the objects in one transaction?

Upvotes: 145

Views: 268611

Answers (7)

ecbtln
ecbtln

Reputation: 2746

as of the django development, there exists bulk_create as an object manager method which takes as input an array of objects created using the class constructor. check out django docs

Upvotes: 133

Yagmur SAHIN
Yagmur SAHIN

Reputation: 325

name = request.data.get('name')
period = request.data.get('period')
email = request.data.get('email')
prefix = request.data.get('prefix')
bulk_number = int(request.data.get('bulk_number'))

bulk_list = list()
for _ in range(bulk_number):
    code = code_prefix + uuid.uuid4().hex.upper()
    bulk_list.append(
        DjangoModel(name=name, code=code, period=period, user=email))

bulk_msj = DjangoModel.objects.bulk_create(bulk_list)

Upvotes: 10

Thorin Schiffer
Thorin Schiffer

Reputation: 2846

worked for me to use manual transaction handling for the loop(postgres 9.1):

from django.db import transaction
with transaction.atomic():
    for item in items:
        MyModel.objects.create(name=item.name)

in fact it's not the same, as 'native' database bulk insert, but it allows you to avoid/descrease transport/orms operations/sql query analyse costs

Upvotes: 5

Danil
Danil

Reputation: 3568

Use bulk_create() method. It's standard in Django now.

Example: 

Entry.objects.bulk_create([
    Entry(headline="Django 1.0 Released"),
    Entry(headline="Django 1.1 Announced"),
    Entry(headline="Breaking: Django is awesome")
])

Upvotes: 84

Ivan Klass
Ivan Klass

Reputation: 6627

Here is how to bulk-create entities from column-separated file, leaving aside all unquoting and un-escaping routines:

SomeModel(Model):
    @classmethod
    def from_file(model, file_obj, headers, delimiter):
        model.objects.bulk_create([
            model(**dict(zip(headers, line.split(delimiter))))
            for line in file_obj],
            batch_size=None)

Upvotes: 4

MrJ
MrJ

Reputation: 1514

Check out this blog post on the bulkops module.

On my django 1.3 app, I have experienced significant speedup.

Upvotes: 2

OmerGertel
OmerGertel

Reputation: 2573

Using create will cause one query per new item. If you want to reduce the number of INSERT queries, you'll need to use something else.

I've had some success using the Bulk Insert snippet, even though the snippet is quite old. Perhaps there are some changes required to get it working again.

http://djangosnippets.org/snippets/446/

Upvotes: 3

Related Questions