I have a Multi where I create and insert a business and some other structs that depend on it such as admin relation to the creating user.
In the business changeset I am generating a slug using:
with unique constraint on the slug.
If the slug is used the Multi fails and the user needs to change the slug and retry, nothing surprising here.
Now business requirements changed and if the unique constraint fails it should keep retrying by appending
_x+1 until it gets a unique slug.
Essentially append a number and keep increasing it until it is unique.
This could be done in many ways like checking the slug before attempting to insert in the multi and then passing the slug that would be accepted but that feels a bit manual.
I was looking at on_conflict
But it updates the one in the db, not the item I am trying to insert, is it possible to have the on_conflict applied to the item that I am trying to insert?