An alternate method (my preferrence) to get the "full" type, or the model with all of its possible relations, is to use the GetPayload version of your model type. The type is a generic that can receive the same object you pass to your query.

import { PrismaClient, Prisma } from "@prisma/client";

const prisma = new PrismaClient();

type UserWithCars = Prisma.UserGetPayload<{
  include: {
    cars: true;
  }
}>

const usersWithCars = await prisma.user.findMany({
  include: {
    cars: true,
  }
});

As your query grows more complex, you may want to abstract it and ensure that it is strongly typed.

import { Prisma, PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

const userInclude = Prisma.validator<Prisma.UserInclude>()({
  cars: true,
});

type UserWithCars = Prisma.UserGetPayload<{
  include: typeof userInclude;
}>;

const usersWithCars = await prisma.user.findMany({
  include: userInclude,
});

Hey @andreasqlight 👋 ,

You should be able to import any of Prisma's generated types from the @prisma/client package.

model User {
 ...
}

import type { User } from '@prisma/client'

Let me know if that works!

Hello @haltcase

Actually we have a similar request like this here: #6980. So above is not quite possible right now. I will suggest you follow the issue.

I can see that this Todo type is exported. But when I use Primsa.Todo as a type, it doesn't work...

EDIT: I GOT IT NOW!

I have to import it directly like this:

import { Todo } from "@prisma/client";

Yes, Prisma.ModelName is what you are looking for:

import { Prisma } from '@prisma/client';

// This is what you need probably:
Prisma.ModelName

All the types are contained in the node_modules/.prisma/client/index.d.ts file, so if you need some type you can just look into this file and try to find, maybe it is there.

Hey @dannysmc95 👋 !

Since Prisma queries do not include relations by default (you have to use the include option), the generated types do not include them either. You can create the type you are looking for using one of our built-in utility types, though.

import { Prisma } from '@prisma/client'
type FactionWithOwner = Prisma.FactionGetPayload<{
  include: { owner: true }
}>

Here we use the FactionGetPayload type and pass in some query options as the generic parameter to get the desired type.

Let me know if you have any questions about this!

You get error because modelName could be any string, while it can only receive "user" or "participant" (according to schema.prisma model).

So to get list of your model you can get it with Prisma type

/* 
file schema.prisma models:

model User {
  id          Int      @id @default(autoincrement())
  name        String
  password    String
  job         String   @default("")
  location    String   @default("")
  phone       String   @default("")
  email       String
}

model Participant {
  id         Int       @id @default(autoincrement())
  userID     Int
  groupID    Int
}

*/

import { Prisma, PrismaClient } from "@prisma/client";

type PrismaOption = PrismaClient<
  Prisma.PrismaClientOptions,
  never,
  Prisma.RejectOnNotFound | Prisma.RejectPerOperation | undefined
>

// this will return "user" | "participant"
export type PrismaModel = keyof Omit<
  PrismaOption,
  | "$connect"
  | "$disconnect"
  | "$executeRaw"
  | "$executeRawUnsafe"
  | "$on"
  | "$queryRaw"
  | "$queryRawUnsafe"
  | "$transaction"
  | "$use"
>

function loadModel(modelName: PrismaModel) { // modelName type will be "user" | "participant"
  const prisma = new PrismaClient();
  return prisma[modelName]
}

loadModel("user")