Bulk create model objects in django

Question

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

User · Answer

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

User · Answer

worked for me to use manual transaction handling for the loop postgres 9 1    from django db import transaction with transaction commit on success        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

User · Answer

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

User · Answer

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

User · Answer

Check out this blog post on the bulkops module    On my django 1 3 app  I have experienced significant speedup

User · Answer

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

User · Answer

for a single line implementation  you can use a lambda expression in a map  map lambda x MyModel objects get or create name x   items    Here  lambda matches each item in items list to x and create a Database record if necessary    Lambda Documentation

User · Answer

The easiest way is to use the create Manager method  which creates and saves the object in a single step   for item in items      MyModel objects create name item name

[django] Bulk create model objects in django

Examples related to django

Examples related to django-models