How can I dynamically use prisma model with string in a function

[tetthys]

Question

For example, I assume that I am defining Paginate funciton.

const result = await Paginate(currentPage, take, 'user');

const Paginate = async (currentPage: number, take: number, model: string) => {
  const prisma = new PrismaClient();
  await prisma[model].findMany({
    //
  })
}

How to reproduce (optional)

Expected behavior (optional)

  await prisma.user.findMany({
    // do something
  })

  await prisma.product.findMany({
    // do something
  })

  await prisma.bid.findMany({
    // do something
  })

I expect this...

But there are still type problems...

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[ludralph]

Hi @tetthys 👋

Thank you for raising this question.

Does doing something like this work for you

const Paginate = async (currentPage: number, take: number, model: string) => {
  const modelType: PrismaClient[typeof modelName] = prisma[modelName];
  const record = await modelType.findMany({
    //
  });
}

If this answers your question, it would be great if you could mark this Discussion as answered to indicate that it has been resolved.

Otherwise please let us know how else we can help you further or close the Discussion if it was resolved in some other way 🙏

[tetthys]

Unfortunately, It doesn't work... Even though I changed a parameter name of your function.

[nlightnlabs]

this is working for me:

export async function getTable(tableName: string) {
const data = await ((prisma as any)[tableName]).findMany();
return data;
}

where "prisma" is a new PrismaClient query object exported from another file