Class SelectQueryBuilder<T>

Type Parameters

T

Hierarchy (View Summary)

BaseQueryBuilder<T>
- SelectQueryBuilder

Index

Constructors

Properties

executor? tableName

Methods

build commit join limit offset orderBy paginate select where

Constructors

constructor

new SelectQueryBuilder<T>(
tableName: string,
executor?: SqlExecutor<T>,
): SelectQueryBuilder<T>
Type Parameters
- T
Parameters
- tableName: string
- Optionalexecutor: SqlExecutor<T>
Returns SelectQueryBuilder<T>
Inherited from BaseQueryBuilder.constructor
- Defined in query-builder/base.ts:5

Properties

`Protected` `Optional` `Readonly`executor

executor?: SqlExecutor<T>

`Protected` `Readonly`tableName

tableName: string

Methods

build

build(): { sql: string; values: any[] }
Returns { sql: string; values: any[] }
Overrides BaseQueryBuilder.build
- Defined in query-builder/select.ts:63

commit

commit(): Promise<QueryResult<any>>
Returns Promise<QueryResult<any>>
Inherited from BaseQueryBuilder.commit
- Defined in query-builder/base.ts:12

join

join<F>(join: Join<T, F>): this
Type Parameters
- F
Parameters
- join: Join<T, F>
Returns this
- Defined in query-builder/select.ts:31

limit

limit(limit: number): this
Parameters
- limit: number
Returns this
- Defined in query-builder/select.ts:53

offset

offset(offset: number): this
Parameters
- offset: number
Returns this
- Defined in query-builder/select.ts:58

orderBy

orderBy(orderBy: OrderBy<T> | OrderBy<T>[]): this
Parameters
- orderBy: OrderBy<T> | OrderBy<T>[]
Returns this
- Defined in query-builder/select.ts:39

paginate

paginate(options: PaginationOptions<T>): Promise<PaginatedResult<T>>
Parameters
- options: PaginationOptions<T>
Returns Promise<PaginatedResult<T>>
- Defined in query-builder/select.ts:101

select

select(columns?: (keyof T)[]): this
Parameters
- Optionalcolumns: (keyof T)[]
Returns this
- Defined in query-builder/select.ts:21

where

where(condition: WhereCondition<T>): this
Parameters
- condition: WhereCondition<T>
Returns this
- Defined in query-builder/select.ts:26