there is update and updateMany, both accept ({ where: {}, data: {} }), also there is an intersting methods to update like upsert:
const user = await prisma.user.update({
where: { name: 'rush' },
data: {
// increment, decrement, multiply, divide
age: { increment: 1 },
// create or connect or disconnect relations when update
userPrefs: {
create: { emailUpdates: true }
},
userPrefs: {
connect: { id: 114 }
},
userPrefs: {
disconnect: true
}
},
// does'nt accept `select` and `include`
})const user = await prisma.user.upsert({
where: { name: 'rush' },
update: {
age: { increment: 1 },
userPrefs: {
create: { emailUpdates: true }
},
userPrefs: {
connect: { id: 114 }
},
userPrefs: {
disconnect: true
}
},
create: {
name: "rush",
email: "rush@wusaby.com",
age: 20,
}
})work as find, we have delete and deleteMany
// Delete a single user
const user = await prisma.user.delete({
where: { name: 'rush' },
})
// Delete multiple users
const users = await prisma.user.deleteMany({
where: { age: { lt: 18 } },
})