Currently there is no way to use an insert query with ignore when duplicate key is found.
I think the best way to implement it is the following:
INSERT IGNORE
when the boolean is set.INSERT ... ON CONFLICT DO NOTHING
when the boolean is set. This brings the requirement of having version 9.5 or newer. Is this a problem? Could add an extra requirement to this specific functionality.INSERT OR IGNORE
when the boolean is set.I have also some idea's about duplicate key update solutions, but for now lets first handle this ticket.
Needs work
11.0 🔥
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.