- March 28, 2012
- Not specified
- 0 (after 0 ratings)
As of django 1.4, the newly introduced
bulk_create() function has a strong limitation when using SQLite. Namely it causes an error if you want to create more than
999/F objects, where
F is the number of fields in the object type.
safe_bulk_create(objs) function solves this issue by splitting the list of objects to appropriately sized bulks.
This solution also works fine with other db backends, and according to my experiments, it causes no significant overhead comparing to using
For more details on the issue, see https://code.djangoproject.com/ticket/17788
Thanks to charettes for pointing out how to calculate the number of fields in an object.
1 2 3 4 5 6
def safe_bulk_create(objs): """Wrapper to overcome the size limitation of standard bulk_create()""" if objs: BULK_SIZE = 900/len(objs.__class__._meta.fields) for i in range(0,len(objs),BULK_SIZE): objs.__class__.objects.bulk_create(objs[i:i+BULK_SIZE])
More like this
- "Magic Link" Management Command by webology 3 months ago
- Closest ORM models to a latitude/longitude point by simonw 3 months ago
- Log the time taken to execute each DB query by kennyx46 3 months ago
- django database snippet by ItsRLuo 3 months ago
- Serialize a model instance by chriswedgwood 4 months ago