Add where clause in QuerySet.bulk_create() when update_conflicts=True

[Alain Delplanque]

To import objects from one database to another, it would be necessary to filter rows that are subject to an update. Which in plain sql looks like:

INSERT INTO my_table (field1, ...)
VALUES ...
ON CONFLICT (pk)
DO UPDATE SET field1 = EXCLUDED.field1, ...
WHERE lastupdated < EXCLUDED.lastupdated

[Mariusz Felisiak]

Thanks for the ticket (follow up to #31685). Looks like a nice addition, we need to remember that it's not supported on MySQL/MariaDB.

[HAMA Barhamou]

Thank you for the ticket. I will work on it.
I'm new to this, so your advice would be appreciated.

[HAMA Barhamou]

Hello everyone,

I am excited to share that I have worked on implementing the feature requested in this ticket and have submitted a pull request for review. You can view and provide feedback or suggestions here: ​https://github.com/django/django/pull/17515.

Any comments or suggestions for improving the contribution are welcome. Thank you for the opportunity to contribute to Django, and I look forward to your feedback!

Best regards,

[HAMA Barhamou]

ready for another revision

[HAMA Barhamou]

ready for another revision

[HAMA Barhamou]

ready for another revision

[HAMA Barhamou]

ready for another revision

[HAMA Barhamou]

ready for another revision

[Natalia Bidart]

Setting as patch needs improvement following a reviewer request to rebase and squash commits to allow for/ease future review iterations.

[HAMA Barhamou]

ready for another revision

[HAMA Barhamou]

ready for another revision

[blighj]

It didn't make it in the 6.1 window, so the PR needs to be targeted at 6.2 now. Hopefully you still have the energy, this can get done!

[Jacob Walls]

Patch still applies cleanly, needs a review.