Delete Prisma self-referencing (one to many)

Question

I have this prisma schema

model Directory {
  id                String      @id @default(cuid())
  name              String?
  parentDirectoryId String?
  userId            String
  parentDirectory   Directory?  @relation("parentDirectoryId", fields: [parentDirectoryId], references: [id], onDelete: NoAction, onUpdate: NoAction)
  user              User        @relation(fields: [userId], references: [id], onDelete: Cascade)
  quizess           Quiz[]
  subDirectory      Directory[] @relation("parentDirectoryId")

  @@index([parentDirectoryId])
  @@index([userId])
}

The logic behind it: I can have a folder that can be in root (parentDirectoryId = null) or it can have many additionals directories.

How do I delete directory with directiories inside of them?

This is what happens when I try to call prisma.delete:

Invalid prisma.directory.delete()` invocation:

The change you are trying to make would violate the required relation 'parentDirectoryId' between the Directory and Directory models.`

Set onDelete: Cascade, onUpdate: Cascade which doesnt work

I'm actually on the same problem but there's no answer here, have you solved it yet? — Rao Zaeem Shahid, Apr 03 '23 at 21:35
Can you please update the post with the query you performed? — Raphael Etim, May 21 '23 at 08:30

Delete Prisma self-referencing (one to many)

0 Answers0