explicit prisma many-to-many self relation in typescript

To explicitly define a many-to-many self-relation using Prisma and TypeScript, you can follow these steps:

Define the Prisma model for the entity, let's call it User, in your Prisma schema file (usually named schema.prisma). This model will have a many-to-many relation with itself. Here's an example:


model User {
  id    Int    @id @default(autoincrement())
  name  String
  friends User[] @relation("Friends", references: [id])
}
131 chars
6 lines

Generate the Prisma client by running the npx prisma generate command in your terminal. This will generate the necessary TypeScript typings for your Prisma schema.
In your TypeScript code, import and use the generated PrismaClient instance. You can create, update, or query users using the generated Prisma methods. Here's an example:


index.ts
import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function createUsers() {
  const user1 = await prisma.user.create({
    data: {
      name: 'User 1',
      friends: {
        create: [{ name: 'Friend 1' }, { name: 'Friend 2' }],
      },
    },
  })

  const user2 = await prisma.user.create({
    data: {
      name: 'User 2',
      friends: {
        create: [{ name: 'Friend 3' }, { name: 'Friend 4' }],
      },
    },
  })

  // Add user1 and user2 as friends of each other
  await prisma.user.update({
    where: { id: user1.id },
    data: {
      friends: { connect: [{ id: user2.id }] },
    },
  })

  // Query user1 with its friends
  const userWithFriends = await prisma.user.findUnique({
    where: { id: user1.id },
    include: { friends: true },
  })

  console.log(userWithFriends)
}

createUsers()
856 chars
42 lines

In the above example, we create two users, and then connect them as friends. Finally, we query user1 with its friends included.

That's it! You can now use Prisma and TypeScript to define and interact with a many-to-many self-relation using Prisma.

similar typescript code snippets

how to create a prisma schema for milliseconds in typescript

store generic into localstorage in typescript

create a generic interface in typescript

split a provided array into chunks of a provided size in javascript in typescript

check if enum is valid in typescript

create a function that calculates volume of a cube in typescript

a generic function for storing cache into localstorage in typescript

how to define an interface in typescript

loop in typescript

create a loop in typescript

related categories