#36550: AssertionError raised when bulk creation model with composite primary
key
-------------------------------------+-------------------------------------
Reporter: Will-Ruddick | Owner: (none)
Type: Uncategorized | Status: new
Component: Database layer | Version: 5.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by Will-Ruddick:
Old description:
> I have a model that looks something like this
>
> {{{
> class CompositeModel(models.Model):
> pk = models.CompositePrimaryKey("other_model", "the_time",
> "created_at")
>
> other_model = models.ForeignKey("test.OtherModel",
> on_delete=models.CASCADE)
> the_time = models.DateTimeField()
> created_at = models.DateTimeField(auto_now_add=True)
>
> }}}
>
> And when I try and bulk create it in the code I get the following
> exception.
>
> {{{
> CompositeModel.objects.bulk_create(new_items)
> File "django/db/models/manager.py", line 87, in manager_method
> return getattr(self.get_queryset(), name)(*args, **kwargs)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> File "django/db/models/query.py", line 836, in bulk_create
> assert len(returned_columns) == len(objs_without_pk)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> AssertionError
> }}}
>
> Where `returned_columns` is an empty list and `objs_without_pk ` is a
> list of the objects I'm trying to create.
>
> If I use `ignore_conflicts=True` then everything works fine and the
> objects are created properly in the DB. I think this is a bug, but it
> could be user error.
>
> This is happening on version 5.2.5
New description:
I have a model that looks something like this
{{{
class CompositeModel(models.Model):
pk = models.CompositePrimaryKey("other_model", "the_time",
"created_at")
other_model = models.ForeignKey("test.OtherModel",
on_delete=models.CASCADE)
the_time = models.DateTimeField()
created_at = models.DateTimeField(auto_now_add=True)
}}}
And when I try and bulk create it in the code I get the following
exception.
{{{
CompositeModel.objects.bulk_create(new_items)
File "django/db/models/manager.py", line 87, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "django/db/models/query.py", line 836, in bulk_create
assert len(returned_columns) == len(objs_without_pk)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError
}}}
Where `returned_columns` is an empty list and `objs_without_pk ` is a list
of the objects I'm trying to create.
If I use `ignore_conflicts=True` then everything works fine and the
objects are created properly in the DB. I think this is a bug, but it
could be user error.
This is happening on version 5.2.5 with a postgres DB
--
--
Ticket URL: <https://code.djangoproject.com/ticket/36550#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/django-updates/01070198a36601ad-5eaa8c3c-76fa-455a-8ebd-50aac5dfd347-000000%40eu-central-1.amazonses.com.
