[Django] #31685: Add `update_or_create()` in bulk

[Django]

#31685: Add `update_or_create()` in bulk
-------------------------------------+-------------------------------------
Reporter: Vitor | Owner: nobody
Sousa Pereira |
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) | Keywords: bulk insert update
Severity: Normal | upsert
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
It would be useful having a parameter in `bulk_create()`, like
`bulk_create(objs, upsert=True)` or `bulk_create(objs,
update_conflicts=True)`, that lets you update existing rows when there's a
conflict, much like what you can already do for a single entity with
`update_or_create()`.

--
Ticket URL: <https://code.djangoproject.com/ticket/31685>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* cc: Tom Forbes (added)
* stage: Unreviewed => Accepted

Comment:

Agreed, it would be great to support updating conflicts with
`bulk_create()`:

- [https://www.postgresql.org/docs/current/sql-insert.html#SQL-ON-CONFLICT
ON CONFLICT DO UPDATE] on PostgreSQL and SQLite,
- [https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html ON
DUPLICATE KEY UPDATE] on MySQL.

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:1>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------

Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* cc: Chih Sean Hsu (added)
* owner: nobody => Chih Sean Hsu
* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:2>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Chih Sean Hsu):

I have opened PR https://github.com/django/django/pull/13065. It is still
on going.

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:3>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 0

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_docs: 0 => 1
* has_patch: 0 => 1
* needs_tests: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:4>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_docs: 1 => 0
* needs_tests: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:5>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Chih Sean Hsu):

It's done and waiting for review.

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:6>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Alexandr Tatarinov):

Added a comment to pull request about potential room for improvement.

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:7>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Adam Johnson):

* cc: Adam Johnson (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:8>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned

Component: Database layer | Version: dev

(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:9>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_better_patch: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:10>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 1
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1

* needs_docs: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:11>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_better_patch: 1 => 0

* needs_docs: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:12>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1

* needs_tests: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:13>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 0

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_better_patch: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:14>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_tests: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:15>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:16>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: bulk insert update | Triage Stage: Accepted
upsert |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Chih Sean Hsu):

* needs_better_patch: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:17>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:

Keywords: bulk insert update | Triage Stage: Ready for
upsert | checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:18>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu

Type: New feature | Status: closed

Component: Database layer | Version: dev
(models, ORM) |

Severity: Normal | Resolution: fixed

Keywords: bulk insert update | Triage Stage: Ready for
upsert | checkin

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

* status: assigned => closed
* resolution: => fixed

Comment:

In [changeset:"0f6946495a8ec955b471ca1baaf408ceb53d4796" 0f694649]:
{{{
#!CommitTicketReference repository=""
revision="0f6946495a8ec955b471ca1baaf408ceb53d4796"
Fixed #31685 -- Added support for updating conflicts to
QuerySet.bulk_create().

Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope,
and Mariusz Felisiak for reviews.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:19>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: closed
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: bulk insert update | Triage Stage: Ready for
upsert | checkin

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"c627226d05dd52aef59447dcfb29cec2c2b11b8a" c627226d]:
{{{
#!CommitTicketReference repository=""
revision="c627226d05dd52aef59447dcfb29cec2c2b11b8a"
Fixed #33799, Refs #31685 -- Added parameters for updating conflicts to
QuerySeta.abulk_create().
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:20>

[Django]

#31685: Support updating conflicts with QuerySet.bulk_create().
-------------------------------------+-------------------------------------
Reporter: Vitor Pereira | Owner: Chih Sean
| Hsu
Type: New feature | Status: closed
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: bulk insert update | Triage Stage: Ready for
upsert | checkin

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"531c96de34d746a58b9b7320378296730312c016" 531c96de]:
{{{
#!CommitTicketReference repository=""
revision="531c96de34d746a58b9b7320378296730312c016"
[4.1.x] Fixed #33799, Refs #31685 -- Added parameters for updating
conflicts to QuerySeta.abulk_create().

Backport of c627226d05dd52aef59447dcfb29cec2c2b11b8a from main
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/31685#comment:21>