PrismaP
Prisma•15mo ago•
1 reply
TJ

How to derive a type from types generated by Prisma?

Hi,
The following TypeScript code snippet is working where I'm able to derive a type X from the query result from Prisma.
const rows = await prisma.role_users.findMany({
  select: {
    users: {
      select: {
        id: true,
        email: true,
      },
    },
    roles: {
      select: {
        members: {
          select: {
            groups: {
              select: {
                id: true,
                name: true,
              },
            },
          },
        },
      },
    },
  },
});

type X = (typeof rows)[number]["users"] & {
  roles: (typeof rows)[number]["roles"]["members"][number]["groups"][];
};

May I know how to create the type outside of the function instead of defining the type X on runtime in the function? Something like deriving the type from the database table types generated by Prisma and etc?
Was this page helpful?