Howdy, I'm trying to get the TypeScript type for a Model where I'm also selecting fields from a related model. If I use

import type { CartItem } from "@prisma/client";

, that type doesn't include the product fields. Here is my query:

const items = await db.cartItem.findMany({
  select: { id: true, product: { select: { name: true, price: true } } },
  where: { userId }
});

Thanks

Hey Aydrian 👋 nice to see you here 😄 does this work for your scenario?

import { Prisma } from '@prisma/client'

type CartItemWithProduct = Prisma.CartItemGetPayload<{
  select: {
    id: true,
    product: {
      select: {
        name: true,
        price: true
      }
    }
  } 
}>

Ah. That might work. I saw that in the docs but I'm a TypeScript newb. Let me give it a try.

This page in the docs might be helpful: https://www.prisma.io/docs/concepts/components/prisma-client/advanced-type-safety/operating-against-partial-structures-of-model-types

Thank you. That worked.