Version: Next

CountQueryBuilder <T>

SQL query builder with fluent interface.

const qb = orm.em.createQueryBuilder(Publisher);
qb.select('*')
  .where({
    name: 'test 123',
    type: PublisherType.GLOBAL,
  })
  .orderBy({
    name: QueryOrder.DESC,
    type: QueryOrder.ASC,
  })
  .limit(2, 1);

const publisher = await qb.getSingleResult();

Hierarchy

QueryBuilder<T>
- CountQueryBuilder

Accessors

alias

get alias(): string

Inherited from QueryBuilder.alias
Returns string

helper

get helper(): QueryBuilderHelper

Inherited from QueryBuilder.helper
Returns QueryBuilderHelper

mainAlias

get mainAlias(): Alias<T>

Inherited from QueryBuilder.mainAlias
Returns Alias<T>

Methods

addSelect

addSelect(fields: Field<T> | Field<T>[]): SelectQueryBuilder<T>

Inherited from QueryBuilder.addSelect
Parameters
- fields: Field<T> | Field<T>[]
Returns SelectQueryBuilder<T>

andWhere

andWhere(cond: QBFilterQuery<T>): this
andWhere(cond: string, params?: any[]): this

Inherited from QueryBuilder.andWhere
Parameters
- cond: QBFilterQuery<T>
Returns this

as

as(alias: string): QueryBuilder<any, any>

Inherited from QueryBuilder.as
Returns knex instance with sub-query aliased with given alias. You can provide EntityName.propName as alias, then the field name will be used based on the metadata
Parameters
- alias: string
Returns QueryBuilder<any, any>

cache

cache(config?: number | boolean | [string, number]): this

Inherited from QueryBuilder.cache
Parameters
- config: number | boolean | [string, number] = true
Returns this

clone

clone(reset?: boolean | string[]): QueryBuilder<T>

Inherited from QueryBuilder.clone
Parameters
- optionalreset: boolean | string[]
Returns QueryBuilder<T>

comment

comment(comment: string | string[]): this

Inherited from QueryBuilder.comment
Prepend comment to the sql query using the syntax /* ... *‍/. Some characters are forbidden such as /*, *‍/ and ?.
Parameters
- comment: string | string[]
Returns this

count

count(field?: string | string[], distinct?: boolean): CountQueryBuilder<T>

Inherited from QueryBuilder.count
Parameters
- optionalfield: string | string[]
- distinct: boolean = false
Returns CountQueryBuilder<T>

delete

delete(cond?: QBFilterQuery): DeleteQueryBuilder<T>

Inherited from QueryBuilder.delete
Parameters
- optionalcond: QBFilterQuery
Returns DeleteQueryBuilder<T>

distinct

distinct(): SelectQueryBuilder<T>

Inherited from QueryBuilder.distinct
Returns SelectQueryBuilder<T>

distinctOn

distinctOn(fields: string | string[]): SelectQueryBuilder<T>

Inherited from QueryBuilder.distinctOn
postgres only
Parameters
- fields: string | string[]
Returns SelectQueryBuilder<T>

execute

execute(method?: get | all | run, mapResults?: boolean): Promise
execute(method: all, mapResults?: boolean): Promise
execute(method: get, mapResults?: boolean): Promise
execute(method: run, mapResults?: boolean): Promise

Overrides QueryBuilder.execute
Executes this QB and returns the raw results, mapped to the property names (unless disabled via last parameter). Use method to specify what kind of result you want to get (array/single/meta).
Type parameters
- U = { count: number }[]
Parameters
- optionalmethod: get | all | run
- optionalmapResults: boolean
Returns Promise

from

from<T>(target: QueryBuilder<T>, aliasName?: string): SelectQueryBuilder<T>
from<T>(target: EntityName<T>): SelectQueryBuilder<T>

Inherited from QueryBuilder.from
Specifies FROM which entity's table select/update/delete will be executed, removing all previously set FROM-s. Allows setting a main string alias of the selection data.
Type parameters
- T: Partial<T> = Partial<any>
Parameters
- target: QueryBuilder<T>
- optionalaliasName: string
Returns SelectQueryBuilder<T>

getCount

getCount(field?: string | string[], distinct?: boolean): Promise<number>

Inherited from QueryBuilder.getCount
Executes count query (without offset and limit), returning total count of results
Parameters
- optionalfield: string | string[]
- optionaldistinct: boolean
Returns Promise<number>

getFormattedQuery

getFormattedQuery(): string

Inherited from QueryBuilder.getFormattedQuery
Returns raw interpolated query string with all the parameters inlined.
Returns string

getKnex

getKnex(processVirtualEntity?: boolean): QueryBuilder<any, any>

Inherited from QueryBuilder.getKnex
Parameters
- processVirtualEntity: boolean = true
Returns QueryBuilder<any, any>

getKnexQuery

getKnexQuery(processVirtualEntity?: boolean): QueryBuilder<any, any>

Inherited from QueryBuilder.getKnexQuery
Parameters
- processVirtualEntity: boolean = true
Returns QueryBuilder<any, any>

getLoggerContext

getLoggerContext<T>(): T

Inherited from QueryBuilder.getLoggerContext
Gets logger context for this query builder.
Type parameters
- T: Dictionary & LoggingOptions = Dictionary
Returns T

getParams

getParams(): readonly Value[]

Inherited from QueryBuilder.getParams
Returns the list of all parameters for this query.
Returns readonly Value[]

getQuery

getQuery(): string

Inherited from QueryBuilder.getQuery
Returns the query with parameters as wildcards.
Returns string

getResult

getResult(): Promise<T[]>

Inherited from QueryBuilder.getResult
Alias for qb.getResultList()
Returns Promise<T[]>

getResultAndCount

getResultAndCount(): Promise<[T[], number]>

Inherited from QueryBuilder.getResultAndCount
Executes the query, returning both array of results and total count query (without offset and limit).
Returns Promise<[T[], number]>

getResultList

getResultList(limit?: number): Promise<T[]>

Inherited from QueryBuilder.getResultList
Executes the query, returning array of results
Parameters
- optionallimit: number
Returns Promise<T[]>

getSingleResult

getSingleResult(): Promise<null | T>

Inherited from QueryBuilder.getSingleResult
Executes the query, returning the first result or null
Returns Promise<null | T>

groupBy

groupBy(fields: string | keyof T | readonly (string | keyof T)[]): SelectQueryBuilder<T>

Inherited from QueryBuilder.groupBy
Parameters
- fields: string | keyof T | readonly (string | keyof T)[]
Returns SelectQueryBuilder<T>

hasFlag

hasFlag(flag: QueryFlag): boolean

Inherited from QueryBuilder.hasFlag
Parameters
- flag: QueryFlag
Returns boolean

having

having(cond?: string | QBFilterQuery, params?: any[]): SelectQueryBuilder<T>

Inherited from QueryBuilder.having
Parameters
- cond: string | QBFilterQuery = {}
- optionalparams: any[]
Returns SelectQueryBuilder<T>

hintComment

hintComment(comment: string | string[]): this

Inherited from QueryBuilder.hintComment
Add hints to the query using comment-like syntax /*+ ... *‍/. MySQL and Oracle use this syntax for optimizer hints. Also various DB proxies and routers use this syntax to pass hints to alter their behavior. In other dialects the hints are ignored as simple comments.
Parameters
- comment: string | string[]
Returns this

ignore

ignore(): this

Inherited from QueryBuilder.ignore
Returns this

indexHint

indexHint(sql: string): this

Inherited from QueryBuilder.indexHint
Adds index hint to the FROM clause.
Parameters
- sql: string
Returns this

innerJoin

innerJoin(field: string | QueryBuilder<any, any> | QueryBuilder<any>, alias: string, cond?: QBFilterQuery, schema?: string): this

Inherited from QueryBuilder.innerJoin
Parameters
- field: string | QueryBuilder<any, any> | QueryBuilder<any>
- alias: string
- cond: QBFilterQuery = {}
- optionalschema: string
Returns this

innerJoinAndSelect

innerJoinAndSelect(field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>], alias: string, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T>

Inherited from QueryBuilder.innerJoinAndSelect
Parameters
- field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>]
- alias: string
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T>

innerJoinLateral

innerJoinLateral(field: string | QueryBuilder<any, any> | QueryBuilder<any>, alias: string, cond?: QBFilterQuery, schema?: string): this

Inherited from QueryBuilder.innerJoinLateral
Parameters
- field: string | QueryBuilder<any, any> | QueryBuilder<any>
- alias: string
- cond: QBFilterQuery = {}
- optionalschema: string
Returns this

innerJoinLateralAndSelect

innerJoinLateralAndSelect(field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>], alias: string, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T>

Inherited from QueryBuilder.innerJoinLateralAndSelect
Parameters
- field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>]
- alias: string
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T>

insert

insert(data: RequiredEntityData<T> | RequiredEntityData<T>[]): InsertQueryBuilder<T>

Inherited from QueryBuilder.insert
Parameters
- data: RequiredEntityData<T> | RequiredEntityData<T>[]
Returns InsertQueryBuilder<T>

join

join(field: string | QueryBuilder<any, any> | QueryBuilder<any>, alias: string, cond?: QBFilterQuery, type?: JoinType, path?: string, schema?: string): this

Inherited from QueryBuilder.join
Parameters
- field: string | QueryBuilder<any, any> | QueryBuilder<any>
- alias: string
- cond: QBFilterQuery = {}
- type: JoinType = JoinType.innerJoin
- optionalpath: string
- optionalschema: string
Returns this

joinAndSelect

joinAndSelect(field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>], alias: string, cond?: QBFilterQuery, type?: JoinType, path?: string, fields?: string[], schema?: string): SelectQueryBuilder<T>

Inherited from QueryBuilder.joinAndSelect
Parameters
- field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>]
- alias: string
- cond: QBFilterQuery = {}
- type: JoinType = JoinType.innerJoin
- optionalpath: string
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T>

leftJoin

leftJoin(field: string | QueryBuilder<any, any> | QueryBuilder<any>, alias: string, cond?: QBFilterQuery, schema?: string): this

Inherited from QueryBuilder.leftJoin
Parameters
- field: string | QueryBuilder<any, any> | QueryBuilder<any>
- alias: string
- cond: QBFilterQuery = {}
- optionalschema: string
Returns this

leftJoinAndSelect

leftJoinAndSelect(field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>], alias: string, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T>

Inherited from QueryBuilder.leftJoinAndSelect
Parameters
- field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>]
- alias: string
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T>

leftJoinLateral

leftJoinLateral(field: string | QueryBuilder<any, any> | QueryBuilder<any>, alias: string, cond?: QBFilterQuery, schema?: string): this

Inherited from QueryBuilder.leftJoinLateral
Parameters
- field: string | QueryBuilder<any, any> | QueryBuilder<any>
- alias: string
- cond: QBFilterQuery = {}
- optionalschema: string
Returns this

leftJoinLateralAndSelect

leftJoinLateralAndSelect(field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>], alias: string, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T>

Inherited from QueryBuilder.leftJoinLateralAndSelect
Parameters
- field: string | [field: string, qb: QueryBuilder<any, any> | QueryBuilder<any>]
- alias: string
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T>

limit

limit(limit?: number, offset?: number): SelectQueryBuilder<T>

Inherited from QueryBuilder.limit
Parameters
- optionallimit: number
- offset: number = 0
Returns SelectQueryBuilder<T>

merge

merge(data?: Field<T>[] | EntityData<T>): this

Inherited from QueryBuilder.merge
Parameters
- optionaldata: Field<T>[] | EntityData<T>
Returns this

offset

offset(offset?: number): SelectQueryBuilder<T>

Inherited from QueryBuilder.offset
Parameters
- optionaloffset: number
Returns SelectQueryBuilder<T>

onConflict

onConflict(fields?: Field<T> | Field<T>[]): InsertQueryBuilder<T>

Inherited from QueryBuilder.onConflict
Parameters
- fields: Field<T> | Field<T>[] = []
Returns InsertQueryBuilder<T>

orWhere

orWhere(cond: QBFilterQuery<T>): this
orWhere(cond: string, params?: any[]): this

Inherited from QueryBuilder.orWhere
Parameters
- cond: QBFilterQuery<T>
Returns this

orderBy

orderBy(orderBy: QBQueryOrderMap<T> | QBQueryOrderMap<T>[]): SelectQueryBuilder<T>

Inherited from QueryBuilder.orderBy
Parameters
- orderBy: QBQueryOrderMap<T> | QBQueryOrderMap<T>[]
Returns SelectQueryBuilder<T>

returning

returning(fields?: Field<T> | Field<T>[]): this

Inherited from QueryBuilder.returning
Parameters
- optionalfields: Field<T> | Field<T>[]
Returns this

select

select(fields: Field<T> | Field<T>[], distinct?: boolean): SelectQueryBuilder<T>

Inherited from QueryBuilder.select
Parameters
- fields: Field<T> | Field<T>[]
- distinct: boolean = false
Returns SelectQueryBuilder<T>

setFlag

setFlag(flag: QueryFlag): this

Inherited from QueryBuilder.setFlag
Parameters
- flag: QueryFlag
Returns this

setFlushMode

setFlushMode(flushMode?: FlushMode): this

Inherited from QueryBuilder.setFlushMode
Parameters
- optionalflushMode: FlushMode
Returns this

setLockMode

setLockMode(mode?: LockMode, tables?: string[]): this

Inherited from QueryBuilder.setLockMode
Parameters
- optionalmode: LockMode
- optionaltables: string[]
Returns this

setLoggerContext

setLoggerContext(context: LoggingOptions & Dictionary): void

Inherited from QueryBuilder.setLoggerContext
Sets logger context for this query builder.
Parameters
- context: LoggingOptions & Dictionary
Returns void

then

then<TResult1, TResult2>(onfulfilled?: null | (value: number) => TResult1 | PromiseLike<TResult1>, onrejected?: null | (reason: any) => TResult2 | PromiseLike<TResult2>): Promise<number>

Overrides QueryBuilder.then
Provides promise-like interface so we can await the QB instance.
Type parameters
- TResult1 = number
- TResult2 = never
Parameters
- optionalonfulfilled: null | (value: number) => TResult1 | PromiseLike<TResult1>
- optionalonrejected: null | (reason: any) => TResult2 | PromiseLike<TResult2>
Returns Promise<number>

toQuery

toQuery(): { _sql: Sql; params: readonly unknown[]; sql: string }

Inherited from QueryBuilder.toQuery
Returns { _sql: Sql; params: readonly unknown[]; sql: string }
- _sql: Sql
- params: readonly unknown[]
- sql: string

truncate

truncate(): TruncateQueryBuilder<T>

Inherited from QueryBuilder.truncate
Returns TruncateQueryBuilder<T>

unsetFlag

unsetFlag(flag: QueryFlag): this

Inherited from QueryBuilder.unsetFlag
Parameters
- flag: QueryFlag
Returns this

update

update(data: EntityData<T>): UpdateQueryBuilder<T>

Inherited from QueryBuilder.update
Parameters
- data: EntityData<T>
Returns UpdateQueryBuilder<T>

where

where(cond: QBFilterQuery<T>, operator?: $and | $or): this
where(cond: string, params?: any[], operator?: $and | $or): this

Inherited from QueryBuilder.where
Parameters
- cond: QBFilterQuery<T>
- optionaloperator: $and | $or
Returns this

withSchema

withSchema(schema?: string): this

Inherited from QueryBuilder.withSchema
Parameters
- optionalschema: string
Returns this

withSubQuery

withSubQuery(subQuery: QueryBuilder<any, any>, alias: string): this

Inherited from QueryBuilder.withSubQuery
Parameters
- subQuery: QueryBuilder<any, any>
- alias: string
Returns this

Hierarchy

Index

Accessors

Methods

Accessors

alias

Returns string

helper

Returns QueryBuilderHelper

mainAlias

Returns Alias<T>

Methods

addSelect

Parameters

fields: Field<T> | Field<T>[]

Returns SelectQueryBuilder<T>

andWhere

Parameters

cond: QBFilterQuery<T>

Returns this

as

Parameters

alias: string

Returns QueryBuilder<any, any>

cache

Parameters

config: number | boolean | [string, number] = true

Returns this

clone

Parameters

optionalreset: boolean | string[]

Returns QueryBuilder<T>

comment

Parameters

comment: string | string[]

Returns this

count

Parameters

optionalfield: string | string[]

distinct: boolean = false

Returns CountQueryBuilder<T>

delete

Parameters

optionalcond: QBFilterQuery

Returns DeleteQueryBuilder<T>

distinct

Returns SelectQueryBuilder<T>

distinctOn

Parameters

fields: string | string[]

Returns SelectQueryBuilder<T>

execute

Type parameters

Parameters

optionalmethod: get | all | run

optionalmapResults: boolean

Returns Promise<U>

from

Type parameters

Parameters

target: QueryBuilder<T>

optionalaliasName: string

Returns SelectQueryBuilder<T>

getCount

Parameters

optionalfield: string | string[]

optionaldistinct: boolean

Returns Promise<number>

getFormattedQuery

Returns string

getKnex

Parameters

processVirtualEntity: boolean = true

Returns QueryBuilder<any, any>

getKnexQuery

Parameters

processVirtualEntity: boolean = true

Returns QueryBuilder<any, any>

getLoggerContext

Type parameters