Theo's Typesafe Cult•2y ago

Is there a way to import a type from a Prisma Model on Client

I know that we have inferRouterInputs and inferRouterOutputs, but I dont feel that is what I need. TRPC provides a way to generate a type from model? or the right only way is literally the output?

13 Replies

whatplan•2y ago

Can you rephrase your question? I dont understand what your actually asking a prisma model?

kevinkaOP•2y ago

oh jeez I forgot about mention Prisma - sorry. but yes!

whatplan•2y ago

import { type nameOfModel } from @prisma/client

import { type nameOfModel } from @prisma/client

kevinkaOP•2y ago

that's literally it! thank you brodher

whatplan•2y ago

kevinkaOP•2y ago

enjoying the contact fella, do you know well prisma? I want to create a query that connects to an another model from a many to many and I'm struggling

kevinkaOP•2y ago

this is my models and I want to query an item and include the category it has by searching on the many to many ItemCategory

whatplan•2y ago

await prisma.item.findUnqiue({
  where: {
    id: id,
  },
  include: {
    categories: {
      include: {
        category: true,
      },
    },
  },
})

await prisma.item.findUnqiue({
  where: {
    id: id,
  },
  include: {
    categories: {
      include: {
        category: true,
      },
    },
  },
})

would return

{
  id: string,
  name: string,
  //...
  categories: (ItemCategory & Category)[]
}

{
  id: string,
  name: string,
  //...
  categories: (ItemCategory & Category)[]
}

whatplan•2y ago

https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries

Prisma

Relation queries (Concepts)

Prisma Client provides convenient queries for working with relations, such as a fluent API, nested writes (transactions), nested reads and relation filters.

kevinkaOP•2y ago

ohh boy, I need to start to explain better my questions lol thank you! it's almost that Ive found this article from Prisma Docs before but what I really want is almost that; by doing that I will get all the register I have from the model ItemCategory that's my control table. what I really need is a list of the category itself! The final result I would like to have would be something

{
  id: string,
  name: string,
  //...
  categories: {
     id: string,
     name: string,
     // values from the Category model
  }
}

and btw including this category on the Item query it have stopped to retrieve the rest of the item data, it seems they all are set to false. thinkies

kevinkaOP•2y ago

I can workaround my need with that but I still think there's a way to make it in one query

whatplan•2y ago

I still dont know exactly what you want to be honest I think you want the item + all the categories for that item Im pretty sure the first thing I wrote (what im replying to) works as well but this is basically what you just wrote out

const item = await ctx.prisma.item.findFirst({
  where: {
    id: input.id,
  },
})
const categories = await prisma.itemcatergory.findMany({
  where: {
    categoryId: input.id,
  },
  include: {
    category: true,
  },
})

return {
  ...item,
  categories: categories.map(x => x.category)
}

const item = await ctx.prisma.item.findFirst({
  where: {
    id: input.id,
  },
})
const categories = await prisma.itemcatergory.findMany({
  where: {
    categoryId: input.id,
  },
  include: {
    category: true,
  },
})

return {
  ...item,
  categories: categories.map(x => x.category)
}

kevinkaOP•2y ago

its because the first query (the one you wrote first) doesnt provide the category itself and the ids of them

Gaming

Programming

Is there a way to import a type from a Prisma Model on Client

Did you find this page helpful?