Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

UniqueConstraintViolationException overview ticket #12369

Open
6 of 15 tasks
MorrisJobke opened this issue Nov 9, 2018 · 4 comments
Open
6 of 15 tasks

UniqueConstraintViolationException overview ticket #12369

MorrisJobke opened this issue Nov 9, 2018 · 4 comments
Labels
2. developing Work in progress overview

Comments

@MorrisJobke
Copy link
Member

MorrisJobke commented Nov 9, 2018 •
edited
Loading

@MorrisJobke MorrisJobke added this to the Nextcloud 15 milestone Nov 9, 2018
This was referenced Nov 9, 2018
Closed
Closed
Closed
Closed
Closed
@nextcloud-bot

This comment has been minimized.

Sign in to view
MorrisJobke added a commit that referenced this issue Nov 9, 2018
@MorrisJobke
Catch UniqueConstraintViolationException inside insertIfNotExist
230e93f 
This is the most common case for the usage of this method.

See also #12369 and the linked tickets.

Signed-off-by: Morris Jobke <hey@morrisjobke.de>
@MorrisJobke MorrisJobke mentioned this issue Nov 9, 2018
Merged
@MorrisJobke MorrisJobke self-assigned this Nov 14, 2018
@skjnldsv skjnldsv mentioned this issue Dec 12, 2018
Closed
@MorrisJobke MorrisJobke modified the milestones: Nextcloud 16, Nextcloud 17 Apr 5, 2019
@stale

This comment was marked as outdated.

Sign in to view
@stale stale bot added the stale Ticket or PR with no recent activity label Jun 5, 2019
@skjnldsv skjnldsv added the 2. developing Work in progress label Jun 12, 2019
@ghost ghost removed the stale Ticket or PR with no recent activity label Jun 12, 2019
@rullzer rullzer modified the milestones: Nextcloud 17.0.4, Nextcloud 17.0.5 Mar 11, 2020
@rullzer rullzer modified the milestones: Nextcloud 17.0.5, Nextcloud 17.0.6 Mar 23, 2020
@kesselb kesselb removed this from the Nextcloud 17.0.6 milestone Apr 11, 2020
@J0WI
Copy link
Contributor

J0WI commented Dec 27, 2020

The insertIgnoreConflict function introduced in #13721 might be an even better fix.
See also:

@cartman29 cartman29 mentioned this issue Dec 10, 2021
Closed
@J0WI
Copy link
Contributor

J0WI commented Feb 22, 2022

The insertIgnoreConflictpattern does not work for all, some, including #19494, need a insertOrUpdate. The main blocker there is that Doctrine DBAL does not support the ON CONFLICT ... DO UPDATE SET syntax. Is there any other way to avoid writing fields and values in plain SQL?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
2. developing Work in progress overview
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@rullzer @MorrisJobke @kesselb @J0WI @skjnldsv @nextcloud-bot