Collect conflicts?

I am afraid you cannot do so using on_conflict. You will need to perform multiple queries inside a transaction.

Hi @sabri …here’s a question I asked recently almost along the same lines as yours… Collect conflicts?. I wanted a list of the entries just inserted.I may be completely off the mark here but can you not do this

def itemsToInsert =[items to be inserted]

outcome = Repo.insert_all(Model,itemsToInsert,on_conflict: :nothing,returning: [:somecolumn])

def newList= [You then pattern match or something and get recently inserted items]

def conflictedItems= itemsToList – newList

Hope this helps.

But, how can you get the recently inserted items? I guess using the date by using a query?
Why did you use returning: in Repo.insert_all ?
As for the link of your question, it’s the same link of my question

That would be handy if can be done in future, but is there any example about performing multiple queries inside a transaction?

@sabri …sorry..here’s the linkhttps://forum.elixirforum.com/t/getting-the-records-just-inserted/3549…I used returning to specify what column I want back after insert_all.

Thanks, your thread helped me to get all the names of users who were inserted, as I used returning

You’re welcome…I know these are not Oscar awards but the real credit goes to Jose for putting me in the right direction.