Kenny Tran
10/02/2022, 10:12 AMonDelete: Cascade
however when I perform a delete operation it only deletes the relation. Here's my models -
model Sale {
id String @id @default(uuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
index Int @unique @default(autoincrement())
rank Rank @default(ROOKIE)
services ServicesOnSales[]
}
model Service {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String
provision String
sales ServicesOnSales[]
}
model ServicesOnSales {
saleId Int
serviceId Int
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
subscription String
sale Sale @relation(fields: [saleId], references: [index], onDelete: Cascade)
service Service @relation(fields: [serviceId], references: [id], onDelete: Cascade)
@@id([saleId, serviceId])
}
enum Rank {
ROOKIE
MASTER
VETERAN
}
The query below only deletes the sale and the relation but the service is not getting removed
await prisma.sale.delete({
where: {
id
}
})
Jarupong
10/02/2022, 12:59 PMgenerator client {
provider = "prisma-client-js"
}
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
}
Jarupong
10/02/2022, 12:59 PMVladi Stevanovic
Kenny Tran
10/07/2022, 11:43 AMVladi Stevanovic
Kenny Tran
10/07/2022, 11:51 AMVladi Stevanovic