Class: ProjectedGroupedQuery<T, TResult>
Defined in: src/query/GroupedQueryBuilder.ts:264
Projected query awaiting terminal execution (toList, first, etc.)
Type Parameters
| Type Parameter |
|---|
T extends object |
TResult extends Record<string, unknown> |
Constructors
Constructor
new ProjectedGroupedQuery<
T,TResult>(adapter,queryBuilder,groupColumns,havingConditions,projection,transaction?):ProjectedGroupedQuery<T,TResult>
Defined in: src/query/GroupedQueryBuilder.ts:269
Parameters
| Parameter | Type |
|---|---|
adapter | IDbAdapter |
queryBuilder | QueryBuilder<T> |
groupColumns | string[] |
havingConditions | HavingCondition[] |
projection | TResult |
transaction? | DbTransaction |
Returns
ProjectedGroupedQuery<T, TResult>
Methods
orderBy()
orderBy(
field,direction?):this
Defined in: src/query/GroupedQueryBuilder.ts:278
Parameters
| Parameter | Type | Default value |
|---|---|---|
field | string & object | keyof TResult & string | undefined |
direction | "desc" | "asc" | 'asc' |
Returns
this
take()
take(
limit):this
Defined in: src/query/GroupedQueryBuilder.ts:289
Parameters
| Parameter | Type |
|---|---|
limit | number |
Returns
this
skip()
skip(
offset):this
Defined in: src/query/GroupedQueryBuilder.ts:294
Parameters
| Parameter | Type |
|---|---|
offset | number |
Returns
this
toSql()
toSql():
object
Defined in: src/query/GroupedQueryBuilder.ts:299
Returns
object
| Name | Type | Defined in |
|---|---|---|
sql | string | src/query/GroupedQueryBuilder.ts:299 |
params | AdapterParam[] | src/query/GroupedQueryBuilder.ts:299 |
toList()
toList():
Promise<TResult[]>
Defined in: src/query/GroupedQueryBuilder.ts:334
Returns
Promise<TResult[]>
first()
first():
Promise<TResult|null>
Defined in: src/query/GroupedQueryBuilder.ts:345
Returns
Promise<TResult | null>
firstOrThrow()
firstOrThrow():
Promise<TResult>
Defined in: src/query/GroupedQueryBuilder.ts:350
Returns
Promise<TResult>