Skip to content
# Class: SqlPaginationInjector

Defined in: packages/core/src/transformers/SqlPaginationInjector.ts:20

SqlPaginationInjector injects pagination (LIMIT/OFFSET) into a SelectQuery model, creating LIMIT and OFFSET clauses based on provided pagination options.

Constructors

Constructor

new SqlPaginationInjector(): SqlPaginationInjector

Returns

SqlPaginationInjector

Methods

removePagination()

static removePagination(query): SimpleSelectQuery

Defined in: packages/core/src/transformers/SqlPaginationInjector.ts:85

Removes LIMIT and OFFSET clauses from the given query.

Parameters

query

The SelectQuery to modify

string | SimpleSelectQuery

Returns

SimpleSelectQuery

The modified SimpleSelectQuery with pagination removed


inject()

inject(query, pagination): SimpleSelectQuery

Defined in: packages/core/src/transformers/SqlPaginationInjector.ts:28

Injects pagination as LIMIT/OFFSET clauses into the given query model.

Parameters

query

The SelectQuery to modify

string | SimpleSelectQuery

pagination

PaginationOptions

Pagination options containing page number and page size

Returns

SimpleSelectQuery

The modified SimpleSelectQuery with pagination applied

Released under the MIT License.