How to `updateMany()` from an array without looping

[tribal gate]

I'm trying to update the values of each item which has a different ID and cost:

await prisma.item.updateMany({
  data: [
    Object.entries(prices).map(([key, value]) => ({
      where: {
        id: key
      },
      data: {
        cost: value.cost
      }
    }))
  ]
});

However, I'm getting the following error:

Argument `data`: Invalid value provided. Expected ItemUpdateManyMutationInput or ItemUncheckedUpdateManyInput, provided ((Object, Object, Object, Object, Object))

I know that this will work:

for (const [key, value] of Object.entries(prices)) {
  await prisma.item.update({
    where: {
      id: key
    },
    data: {
      cost: value.cost
    }
  });
}```
But this isn't great for performance, the amount of queries, overhead, etc.

How to updateMany() from an array without looping

[tribal gate]

Bump

[haughty tide]

Hi You can try to optimize the whole thing in a Promise.all:

await Promise.all(
 Object.entries(prices).map(([key, value]) =>
   prisma.item.update({
     where: {
       id: key
     },
     data: {
       cost: value.cost
     }
   })
 )
);

[jovial turtle]

How would you handle this if you need to make sure all of them happen, or all a reversed?

[haughty tide]

You mean if one fails, then fail everything? You can see all type of Promise there: https://dev.to/shameel/javascript-promise-all-vs-allsettled-and-race-vs-any-3foj

[jovial turtle]

right right. but like if I have 5 records being updated, if one goes through, the db will have changed even if 4 fail right?

no matter what promise I use

[haughty tide]

Indeed. Otherwise, you can use transactions for that. So if a transaction fails, then all other are reverted automatically.

[jovial turtle]

is it possible to use transactions and get all models back if it was successful? I tried figuring it out a few days ago and didnt see a way to do that

update many only returns a number. not the full record being updated

[haughty tide]

Something like that should do the job:

await prisma.$transaction(async (prisma) => {
 const user = await prisma.user.create({...});
 const post = await prisma.post.create({...});
 return [user, post];
});