Add upsertMany CRUD operation

[tomdohnal]

Problem

I want to upsert a large number of items to the DB efficiently and I'd like to use a prisma.myModel.upsertMany(...) method.

Suggested solution

The upsertMany method would batch-upsert an array of models into the DB.

Alternatives

An alternative I came up with is using something like this:

const requests = items.map(item => prisma.myModel.upsert(item))

await prisma.$transaction(requests)

[pantharshit00]

Closing in favour of #4134

[goleary]

@pantharshit00 curious why you closed this request?

If I'm not mistaken the functionality described in #4134 is different than what's requested here.

#4134 describes updating many records (or the first) using the same data, but what I'd expect upsertMany to do is update many records, all with (potentially) different data.

Perhaps the name of that issue should be changed & this one reopened?

Or the description of the other one updated to reflect what upsertMany could reasonably be expected to do?

[pantharshit00]

I would suggest you to comment on #4134 about this functionality.

There is no final proposal for upsertMany yet so having multiple feature request about the similar thing describing it would just increase the issue count of the repository. If updateMany already existed and it was well defined, then I would have kept this open.

We could have data an array to include the above usecase.