npmpackage.info

Gathering detailed insights and metrics for typeorm-paginator

Other packages similar to typeorm-paginator

typeorm-paginator-nest

1.0.3

Provide pagination for typeorm

nest-typeorm-paginator

0.0.5

nest-paginator

1.0.3

Paginating data with NestJS and TypeORM

typeorm-cursor-paginate

2.1.0

Cursor-based pagination with directional cursors.

Gathering detailed insights and metrics for typeorm-paginator

typeorm-paginator

TypeORM query builder pagination library. (cursor / page both)

0.6.2

TypeScript

182.40 kB

2.4

Installations

npm install typeorm-paginator

Developer Guide

BETA

Typescript

Yes

Module System

CommonJS

Node Version

14.17.5

NPM Version

7.21.0 Pull Requests

Open

7

Total

121

Closed

5

Merged

109

Issues

Open

1

Total

1

Closed

0

Releases

Unable to fetch releases

Languages

TypeScript

JavaScript

TypeScript (99.3%)

JavaScript (0.7%)

Developer

wan2land

Download Statistics

Total Downloads

Last Day

Last Week

Last Month

Last Year

GitHub Statistics

3 Stars

145 Commits

3 Forks

1 Watchers

8 Branches

3 Contributors

Updated on Feb 11, 2022

Maintainers

View All 3 Contributors

Package Meta Information

Latest Version

0.6.2

Package Id

typeorm-paginator@0.6.2

Unpacked Size

182.40 kB

Size

18.11 kB

File Count

NPM Version

7.21.0

Node Version

14.17.5

Total Downloads

Cumulative downloads

Total Downloads

NaN

Last Day

NaN

Compared to previous day

Last Week

NaN

Compared to previous week

Last Month

NaN

Compared to previous month

Last Year

NaN

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

regenerator-runtime

Dev Dependencies

@swc/cli @swc/core @swc/jest @types/jest @types/node browserslist eslint eslint-config-stable jest rimraf sqlite3 typeorm typescript

TypeORM Paginator

It provides cursor-based pagination and page-based pagination. Even if there is a transformer in the column, it works perfectly.

Installation

1npm install typeorm-paginator --save

Usage

Cursor-based Pagination

1import { CursorPaginator } from 'typeorm-paginator'

Single cursor-based pagination.

1const paginator = new CursorPaginator(User, {
2  orderBy: {
3    id: false,
4  },
5})
6
7const pagination = await paginator.paginate(repoUsers.createQueryBuilder())
8
9expect(pagination).toEqual({
10  nodes: [
11    /*
12    User { id: 3 },
13    User { id: 2 },
14    User { id: 1 },
15    */
16  ],
17  hasPrev: false,
18  hasNext: false,
19  nextCursor: expect.any(String),
20  prevCursor: expect.any(String),
21})

Multi cursor-based pagination.

1const paginator = new CursorPaginator(User, {
2  orderBy: [
3    { name: true },
4    { id: false },
5  ],
6})
7
8const result = await paginator.paginate(repoUsers.createQueryBuilder(), { take: 2 })
9expect(result).toEqual({
10  nodes: [
11    User { id: 3, name: 'a' },
12    User { id: 5, name: 'b' },
13  ],
14  hasPrev: false,
15  hasNext: true,
16  prevCursor: expect.any(String),
17  nextCursor: expect.any(String),
18})
19
20const resultNext = await paginator.paginate(repoUsers.createQueryBuilder(), { take: 2, nextCursor: result.nextCursor })
21expect(resultNext).toEqual({
22  nodes: [
23    User { id: 2, name: 'b' },
24    User { id: 6, name: 'c' },
25  ],
26  hasPrev: true,
27  hasNext: true,
28  prevCursor: expect.any(String),
29  nextCursor: expect.any(String),
30})
31
32const resultNextNext = await paginator.paginate(repoUsers.createQueryBuilder(), { take: 2, nextCursor: resultNext.nextCursor })
33expect(resultNextNext).toEqual({
34  nodes: [
35    User { id: 4, name: 'c' },
36    User { id: 1, name: 'c' },
37  ],
38  hasPrev: true,
39  hasNext: false,
40  prevCursor: expect.any(String),
41  nextCursor: expect.any(String),
42})
43
44const resultNextNextPrev = await paginator.paginate(repoUsers.createQueryBuilder(), { take: 2, prevCursor: resultNextNext.prevCursor })
45expect(resultNextNextPrev).toEqual({
46  nodes: [
47    User { id: 2, name: 'b' },
48    User { id: 6, name: 'c' },
49  ],
50  hasPrev: true,
51  hasNext: true,
52  prevCursor: expect.any(String),
53  nextCursor: expect.any(String),
54})

Page-based Pagination

1import { PagePaginator } from 'typeorm-paginator'

Single cursor-based pagination.

1const paginator = new PagePaginator(User, {
2  orderBy: {
3    id: false,
4  },
5  take: 3,
6})
7
8const pagination1 = await paginator.paginate(repoUsers.createQueryBuilder())
9
10expect(pagination1).toEqual({
11  nodes: [
12    /*
13    User { id: 5 },
14    User { id: 4 },
15    User { id: 3 },
16    */
17  ],
18  hasNext: true,
19})
20
21const pagination1 = await paginator.paginate(repoUsers.createQueryBuilder(), { page: 2 })
22
23expect(pagination1).toEqual({
24  nodes: [
25    /*
26    User { id: 2 },
27    User { id: 1 },
28    */
29  ],
30  hasNext: false,
31})

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

Dangerous-Workflow

Determines if the project's GitHub Action workflows avoid dangerous patterns.

3

Pinned-Dependencies

Determines if the project has declared and pinned the dependencies of its build process.

0

Maintained

Determines if the project is "actively maintained".

0

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

Token-Permissions

Determines if the project's workflows follow the principle of least privilege.

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Fuzzing

Determines if the project uses fuzzing.

0

Security-Policy

Determines if the project has published a security policy.

0

License

Determines if the project has defined a license.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

SAST

Determines if the project uses static code analysis.

0

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

Score

2.4

/10

Last Scanned on 2025-06-30

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More

typeorm-paginator - 0.6.2 | npmpackage.info