How to select nested relation in query

[JaLe29]

I have example schema:

model Post {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  published Boolean
  title     String
  content   String?
 
  comments Comment[]
}
 
model Comment {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  content   String
 
  post   Post   @relation(fields: [postID], references: [id])
  postID String
}

and I would like to fetch all Posts with all Comments in single query.

There is a documentation about some, every, none https://goprisma.org/docs/walkthrough/find#querying-for-relations but I would like to select all without any special condition.

[steebchen]

I believe what you want is Fetch():

// find a post
post, err := client.Post.FindFirst(
  db.Post.Title.Equals("hi"),
).With(
  // also fetch 3 of its comments
  db.Post.Comments.Fetch().Take(3),
).Exec(ctx)
check(err)
log.Printf("post's title: %s", post.Title)
 
comments := post.Comments()
for _, comment := range comments {
  log.Printf("comment: %+v", comment)
}

https://goprisma.org/docs/walkthrough/fetch