Warm tip: This article is reproduced from serverfault.com, please click

其他-如何在Prisma中过滤相关对象?

(其他 - How to filter for related objects in Prisma?)

发布于 2020-11-29 16:17:53

如何查询Prisma中的关系?我有以下架构:

model User {
  id      Int      @id @default(autoincrement())
  name    String?
  profile Profile 
}

model Profile {
  id     Int    @id @default(autoincrement())
  user   User   @relation(fields: [userId], references: [id])
  userId Int
}

如何查询Profile特定的User

Questioner
nburk
Viewed
0
nburk 2020-11-30 00:24:56

自己找到答案:

prisma.user.findUnique({ where: { id: 42 }}).profile()