Prisma

image.png

uuhm, anyone knows how to do this?
I want to upsert a table where multiple conditions match.
Do i really need to  search first and then update??

and how would you update a record you don't have yet?

the other way I see to do it is to do a find, if undefined, create. else update

yes, thats obviously what i meant :smile: but this is basically recreating the upsert with multiple queries. an upsert with an whereAND clause would be more efficient

i do know why its not working, because there could exist multiple records with this dataSet

<@U02M8MNL1DZ> :wave:
Until we support <https://github.com/prisma/prisma/issues/4134|upsertMany>, this would be the only way. You could also wrap it in a transaction to make it safer.