Remove the Prisma self-referencing relationship (one-to-many)

Question

Remove the Prisma self-referencing relationship (one-to-many)

I'm working with this particular 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 concept behind it: A folder can exist either at the root level (parentDirectoryId = null) or have several additional directories.

Question is, how do I delete a directory that contains other directories?

When attempting to use prisma.delete, I encounter the following issue:

Invalid prisma.directory.delete()

The requested operation would violate the necessary relation 'parentDirectoryId' between the Directory and Directory models.`

Tried setting onDelete: Cascade, onUpdate: Cascade without success

javascript typescript prisma self-reference self-referencing-table

Answer 1

Answer №1

Give this a shot:


let folders = await this.prisma.folder.findFirst({
        where: { id: directory.id },
        include: { subFolder: true },
      });

prisma.folder.update({
   data: {
           subFolder: {
               disconnect: folders.subFolder.map((e) => {
                  return { id: e.id };
               }),
            },
          },
})

The folder is the primary folder.

Answer 2

Give this a shot:


let folders = await this.prisma.folder.findFirst({
        where: { id: directory.id },
        include: { subFolder: true },
      });

prisma.folder.update({
   data: {
           subFolder: {
               disconnect: folders.subFolder.map((e) => {
                  return { id: e.id };
               }),
            },
          },
})

The folder is the primary folder.

Remove the Prisma self-referencing relationship (one-to-many)

Answer №1

Similar questions

Adaptable images - Adjusting image size for various screen dimensions

Tips for attaching event listeners to custom elements

Parsing of the module has failed due to the presence of an unexpected character '' while attempting to import a video file

Showing Firebase messages in a NativeScript ListView in an asynchronous manner

Retrieve all users along with their respective posts, ensuring that each post is also accompanied by its corresponding comments in

JavaScript scroll event not firing

Guide on transferring object between two $states using ui-router

Save an array of messages by making separate API calls for each one

CLI package enables exporting API facilities

Developing an Angular filter using pipes and mapping techniques

Encountering a problem with Angular 11 SSR after compilation, where the production build is causing issues and no content is being displayed in

The dictionary of parameters includes an empty value for the parameter 'imageWidth', which is of a non-nullable type 'System.Int32'

NextJS Router delays data reloading until page receives focus

Reloading a page will display [object CSSStyleDeclaration]

Passing an array of selected values from Vue.js to a text area and adding them to the existing content

How can one use an Angular Route to navigate to a distinct URL? Essentially, how does one disable matching in the process?

Retrieving input values with JQuery

Handsontable: A guide on adding up row values

Evaluating the functionality of Express Js Server with mocha and chai

Guide to showcasing images dynamically within a table