Prisma Pagination Stuff

prisma.ts

import { PrismaClient } from '@prisma/client';
import { FastifyRequest } from 'fastify';
import { getPaginationDataFromRequest } from './mysql';

type PrismaQueryTargetsRaw = Omit<PrismaClient, `$${string}`>;
type PrismaQueryTargets = {
  [K in keyof PrismaQueryTargetsRaw as K extends symbol ? never : K]: PrismaQueryTargetsRaw[K];
};
type PrismaQueryTarget = PrismaQueryTargets[keyof PrismaQueryTargets];


export function getPaginationDataFromRequest(req: FastifyRequest): { page: number; size: number } {
  let { page, size } = req.query as any;

  if (/^[0-9]+$/.test(page)) page = parseInt(page);
  else page = 1;

  if (/^[0-9]+$/.test(size)) size = parseInt(size);
  else size = 50;

  return { page, size };
}

  
export async function returnPaginationInfo<T extends PrismaQueryTarget>(
  req: FastifyRequest,
  obj: T,
  query: Parameters<T['findMany']>[0],
): Promise<{
  data: Awaited<ReturnType<T['findMany']>>;
  pagination: {
    page: number;
    size: number;
    maxPage: number;
    counts: number;
  };
}> {
  const { page, size } = getPaginationDataFromRequest(req);

  const counts = await (obj as any).count(query);
  return {
    data: await (obj as any).findMany({
      ...query,
      skip: (Math.max(page, 1) - 1) * size,
      take: size,
    }),
    pagination: {
      page,
      size,
      maxPage: Math.max(1, Math.ceil(counts / size)),
      counts,
    },
  };
}