A simple pagination helper function for prisma 2

paginate.ts

/**
 * This is custom pagination helper that
 *  works with prisma 2
 * @author @_waptik
 */

import db from "db" // xutom prisma wrapper by blitz-js

interface Paginate {
  name: string
  by?: string
  where?: Record<string, any>
  take?: number
  cursor?: string
  direction?: "asc" | "desc"
  page?: number
  orderBy?: Record<string, any>
}

async function paginate({ name, where = {}, take = 2, cursor, page = 1, orderBy }: Paginate) {
  if (!orderBy) {
    orderBy = {
      createdAt: "asc",
    }
  }

  const skip = cursor ? 1 : (page - 1) * take

  const conditions = {
    where,
    take,
    skip,
    orderBy,
    cursor: cursor ? { id: cursor } : undefined,
  }

  const model = db[name.toLowerCase()]
  const total = await model.count()
  const nodes = await model.findMany(conditions)
  const pages = take > 0 ? Math.ceil(total / take) || 1 : null

  const next = page < pages! ? page + 1 : null
  const prev = page > 1 ? page - 1 : null
  return {
    nodes,
    pagination: {
      total,
      current: page,
      next,
      prev,
      pages,
    },
  }
}

export default paginate

Usage:

import {paginate} from "utils" // import the function from where it's saved

  const page = parseInt(req.query.page as string, 10) || 1
  const take = 2
  const skip = take * Number(page)

  const data = await paginate({
    name: "user", // model name
    where: { isActive: true },
    take,
    page,
    orderBy: {createdAt: "desc"},
  })

console.log({data})