多对多关系Prisma更新

model User {
  id        Int      @id @default(autoincrement())
  name      String
  posts     Post[]   @relation(references: [id], fields: [postId])
  postId    Int?
}

model Post {
  id        Int      @id @default(autoincrement())
  title     String
  users     User[]   @relation(references: [id], fields: [userId])
  userId    Int?
}

model UserPosts {
  userId    Int
  postId    Int
  user      User     @relation(fields: [userId], references: [id])
  post      Post     @relation(fields: [postId], references: [id])

  @@id([userId, postId])
}

const user = await prisma.user.findUnique({
  where: { id: userId },
});

const post = await prisma.post.findUnique({
  where: { id: postId },
});

await prisma.user.update({
  where: { id: userId },
  data: {
    posts: {
      connect: { id: postId },
    },
  },
});

await prisma.user.update({
  where: { id: userId },
  data: {
    posts: {
      disconnect: { id: postId },
    },
  },
});