Support for bulk upsert in CAP Node.JS

[gregorw]

Hello CAP Team,

what are the plans to support bulk upsert in CAP Node.JS? For Java there is a nice description bulk upsert. But I can't find such a functionality in the documentation for UPDATE. I would expect the following API:

UPSERT.into(Books).entries([
   { ID:201, stock:42 },
   { ID:251, stock:23 },
   { ID:271, stock:4004 }
])

Looking forward for a positive answer.

Best Regards
Gregor

[david_kunz2]

Hi Gregor,

Thanks for this suggestion, I will discuss with the team.

Best regards,
David

[VikasLamba]

Is there a mass update available if not upsert for Nodejs stack?

I have a huge table and need to update values in a specific column but for all rows. As of today I am looping into the table and then firing individual updates per row but was hoping I could do a mass update to the entire table by preparing an array and issuing a single update something on similar lines as insert

await tx.run(INSERT.into(entity).entries(list))

Regards,

Vikas

[MALATG]

david.kunz2 Is there any update on a bulk upsert in CAP Node.js?

[david_kunz2]

Hi, We think of implementing it, but it's yet unclear when this will happen, so I'm afraid I can't give you any detailed news.

In the meantime: We also allow to use plain SQL strings in cds.run(...), so that might be an option. Note that this will just propagate it to the database without any additional convenience.

[hatrigt]

Hello david.kunz2 , Did the mass update feature got implemented or still pending?

[david_kunz2]

Hi, it's still pending.