Document that QuerySet.bulk_create() casts objs to a list

[Nir Izraeli]

When batch_size provided in bulk_create, a user might assume (As I myself have) that objs iterable will not be iterated more than batch_size times at once, and that no more than roughly batch_size Model objects reside in memory at any given time.

When using bulk_create for relatively big sets of objects provided by a generator object, it would be prefered to avoid iterating over the entire generator object. Moreover, if not iterating over the generator object is deemed unnecessary or out-of-scope for django it would be prefered to make a comment on said behavior in documentation.

I suggest two possible solutions:

1. Document this behavior (bulk_create converts passed objs iterator to a list), or
2. Avoid doing so when batch_size is given (or default is other than None. i.e. sqlite).

I did not research the possibility of avoiding the list conversion, but if that solution is accepted by the community I volunteer to investigate further and claim this ticket.

[Nir Izraeli]

CCing myself to receive updates.

[Tim Graham]

Feel free to offer a patch. Looking at the code of QuerySet.bulk_create(), I don't understand how your proposal would work.

[Nir Izraeli]

I'm thinking of creating a chunks generator method, similar to ones implemented in, for example, the following Stack Overflow Answers:

1. ​https://stackoverflow.com/a/24527424/1146713
2. ​https://stackoverflow.com/a/8290514/1146713

And then iterate over it in bulk_create and essentially run the existing bulk_create code for each batch_size-d chunks sequentially.

This means I'll be removing the need for _batched_insert and move the partition by the obj.pk is None check to after batches are made.

What do you think?

Also, if I am to create a patch should I post it here first or create a PR for it?

[Simon Charette]

Also, if I am to create a patch should I post it here first or create a PR for it?

Create a PR for it and link it back to this ticket, it will allow you to run CI against and gather feedback more easily.

[Nir Izraeli]

PR created and passing tests: ​https://github.com/django/django/pull/8540

[Nir Izraeli]

Claimed this issue and marked it as having a patch (assume a PR is considered a "patch" for tracking/reviewing purposes)

[Tim Graham]

I guess this is a duplicate of #26400 (closed as wontfix). François Freitag's comment on the PR: "I would rather document the current behavior and the reason why the iterator has to be consumed. I suggest going to the django-developers mailing list to see if others are interested."

Tentatively reclassifying as a documentation in light of this.

[Botond Béres]

Opened ​PR 9286 to document this behaviour, as explained in the discussion from ​PR 8540

[Tim Martin]

Looks good to me.

[Tim Graham <timograham@…>]

In 52aa26e:

Fixed #28231 -- Doc'd that QuerySet.bulk_create() casts objs to a list.

[Tim Graham <timograham@…>]

In 881f66b:

[2.0.x] Fixed #28231 -- Doc'd that QuerySet.bulk_create() casts objs to a list.

Backport of 52aa26e6979ba81b00f1593d5ee8c5c73aaa6391 from master