Prisma•4w ago

Custom method in a model, gives a "not found" error

I am trying to create a custom method in my model, but when I try to use it, it says not a function. I am confused by the docs that I quoted below as the works/not works are the same code?

In the above example, prisma.user.signUp works, but prisma.user.signUp does not, because the original prisma is not modified.

https://www.prisma.io/docs/orm/prisma-client/client-extensions/model#example Here is my usage in my NextJS project: Prisma client with custom method

new PrismaClient().$extends({
    model: {
      utm: {
        async totalClicks(utmId: string) {
          const utmStats = await prisma.utmStats.findMany({
            where: { utmId },
          });
          return utmStats.reduce((a, b) => a + b.clicks, 0) || 0;
        },
      },
    },
  });

new PrismaClient().$extends({
    model: {
      utm: {
        async totalClicks(utmId: string) {
          const utmStats = await prisma.utmStats.findMany({
            where: { utmId },
          });
          return utmStats.reduce((a, b) => a + b.clicks, 0) || 0;
        },
      },
    },
  });

Usage

const utm = await prisma.utm.findUnique({ ... });
const totalClicks = await utm.totalClicks(utm.id); // ERROR: Property 'totalClicks' does not exist

const utm = await prisma.utm.findUnique({ ... });
const totalClicks = await utm.totalClicks(utm.id); // ERROR: Property 'totalClicks' does not exist

I tried "generate" also, but no change. Any help appreciated

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Custom method in a model, gives a "not found" error