nestjs-paginator

Installation

Add the library via

npm i @bit-architect/nestjs-paginator

or

yarn add @bit-architect/nestjs-paginator

Usage

The library provides a handy decorator that can be added to any NestJS controller. Consider the following example:

1import { Paginator, PaginatorQuery } from '@bit-architect/nestjs-paginator';
2import { Controller, Get } from '@nestjs/common';
3import { UserService } from './user.service';
4
5@Controller('users')
6export class UserController {
7  constructor(private service: UserService) {}
8
9  @Get()
10  getUsers(@Paginator() query: PaginatorQuery) {
11    // console.log(query);
12    return await this.service.getUsers(query);
13  }
14}

Currently, the Paginator supports the following query parameters:

• page: number
• limit: number
• sort: string
• filter: object

Now, you can make a HTTP Call to the endpoint and pass the params as follows:

1http://api.example.com/users?limit=20&page=3&sort=-email,username

This will return

• 20 users
• from the 3rd page (i.e., entry 21-30 from the database according to your sort and filter parameters)
• ordered by email descending (note the -) and username ascending

Different Format

The Paginator is designed to be ORM agnostic, i.e., it can be easily extended / adapted to work with common ORMs, like TypeORM or Prisma.

The easiest approach would be to simply create a PrismaPaginator Decorator and call the PaginatorService, and adapt the response as required. This may look like this:

1import { PaginatorService, PaginatorOptions } from '@bit-architect/nestjs-paginator';
2import { createParamDecorator, ExecutionContext } from '@nestjs/common';
3
4import { PrismaPaginatorQuery } from './prisma-paginator-query.model';
5
6export const PrismaPaginator = createParamDecorator((data: Partial<PaginatorOptions>, ctx: ExecutionContext) => {
7  const request = ctx.switchToHttp().getRequest();
8  const query = new PaginatorService().parseQuery(request.query, data);
9
10  const prismaQuery: PrismaPaginatorQuery = {
11    skip: query.skip,
12    take: query.take,
13    orderBy: query.sort, // note that prisma uses the orderBy instead of sort parameter!
14  };
15
16  return prismaQuery;
17});

Now you can just use the PrismaPaginator instead of the default Paginator in your controllers.