Hey guys a question. Why prisma client do not supp...
# orm-helpx
xiaoqf10
01/08/2019, 3:52 AMHey guys a question. Why prisma client do not support "updateMany" in unscalar fields?
z
Zhao
01/08/2019, 4:02 AMit seems it was disabled on purpose: https://github.com/prisma/prisma/issues/2010#issuecomment-411130455
Zhao
01/08/2019, 4:04 AM@do4gr is ' allowing nested mutations in updateMany’ still being discussed or tracked somewhere?
d
do4gr
01/08/2019, 8:05 AM
At the moment there are no active discussions to change that. We think it would be very easy to get into deadlock situations.
z
Zhao
01/08/2019, 8:20 AMI see. I’m facing a problem where this feature could be really handy. If it’s a no go, what is an alternative way to make ‘update many relations’ a atomic operation?
d
do4gr
01/08/2019, 8:50 AM
You could use the raw SQL escape hatch and try to write a raw sql query that does exactly what you want.