Version: 6.3

TruncateQueryBuilder <T>

Hierarchy

RunQueryBuilder<T>
- TruncateQueryBuilder

Properties

alias

alias: string

helper

helper: QueryBuilderHelper

mainAlias

mainAlias: Alias<T>

Methods

addSelect

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

Inherited from RunQueryBuilder.addSelect
Parameters
- fields: Field<T> | Field<T>[]
Returns SelectQueryBuilder<T, any, any, never>

andWhere

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

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

applyFilters

applyFilters(filterOptions?: boolean | string[] | Dictionary<boolean | Dictionary>): Promise<QueryBuilder<T, any, any, never>>

Inherited from RunQueryBuilder.applyFilters
Apply filters to the QB where condition.
Parameters
- filterOptions: boolean | string[] | Dictionary<boolean | Dictionary> = {}
Returns Promise<QueryBuilder<T, any, any, never>>

as

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

Inherited from RunQueryBuilder.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 RunQueryBuilder.cache
Parameters
- config: number | boolean | [string, number] = true
Returns this

clone

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

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

comment

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

Inherited from RunQueryBuilder.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 RunQueryBuilder.count
Parameters
- optionalfield: string | string[]
- distinct: boolean = false
Returns CountQueryBuilder<T>

delete

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

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

distinct

distinct(): SelectQueryBuilder<T, any, any, never>

Inherited from RunQueryBuilder.distinct
Returns SelectQueryBuilder<T, any, any, never>

distinctOn

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

Inherited from RunQueryBuilder.distinctOn
postgres only
Parameters
- fields: string | string[]
Returns SelectQueryBuilder<T, any, any, never>

execute

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

Inherited from RunQueryBuilder.execute
Type parameters
- Result = QueryResult<T>
Parameters
- optionalmethod: get | all | run
- optionalmapResults: boolean
Returns Promise<Result>

from

from<Entity>(target: QueryBuilder<Entity, never, never, never>, aliasName?: string): SelectQueryBuilder<Entity, any, any, never>
from<Entity>(target: EntityName<Entity>): SelectQueryBuilder<Entity, any, any, never>

Inherited from RunQueryBuilder.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
- Entity: Partial<Entity> = Partial<any>
Parameters
- target: QueryBuilder<Entity, never, never, never>
- optionalaliasName: string
Returns SelectQueryBuilder<Entity, any, any, never>

getCount

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

Inherited from RunQueryBuilder.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 RunQueryBuilder.getFormattedQuery
Returns raw interpolated query string with all the parameters inlined.
Returns string

getKnex

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

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

getKnexQuery

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

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

getLoggerContext

getLoggerContext<T>(): T

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

getParams

getParams(): readonly Value[]

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

getQuery

getQuery(): string

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

getResultAndCount

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

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

groupBy

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

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

hasFlag

hasFlag(flag: QueryFlag): boolean

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

having

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

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

hintComment

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

Inherited from RunQueryBuilder.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 RunQueryBuilder.ignore
Returns this

indexHint

indexHint(sql: string): this

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

innerJoin

innerJoin<Field, Alias>(field: QueryBuilder<any, any> | QueryBuilder<any, never, never, never> | Field, alias: Alias, cond?: QBFilterQuery, schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, false>[K] }>

Inherited from RunQueryBuilder.innerJoin
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: QueryBuilder<any, any> | QueryBuilder<any, never, never, never> | Field
- alias: Alias
- cond: QBFilterQuery = {}
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, false>[K] }>

innerJoinAndSelect

innerJoinAndSelect<Field, Alias>(field: Field | [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>], alias: Alias, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

Inherited from RunQueryBuilder.innerJoinAndSelect
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: Field | [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>]
- alias: Alias
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

innerJoinLateral

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

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

innerJoinLateralAndSelect

innerJoinLateralAndSelect<Field, Alias>(field: [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>], alias: Alias, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

Inherited from RunQueryBuilder.innerJoinLateralAndSelect
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>]
- alias: Alias
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

insert

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

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

join

join<Field, Alias>(field: QueryBuilder<any, any> | QueryBuilder<any, never, never, never> | Field, alias: Alias, cond?: QBFilterQuery, type?: JoinType, path?: string, schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, false>[K] }>

Inherited from RunQueryBuilder.join
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: QueryBuilder<any, any> | QueryBuilder<any, never, never, never> | Field
- alias: Alias
- cond: QBFilterQuery = {}
- type: JoinType = JoinType.innerJoin
- optionalpath: string
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, false>[K] }>

joinAndSelect

joinAndSelect<Field, Alias>(field: Field | [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>], alias: Alias, cond?: QBFilterQuery, type?: JoinType, path?: string, fields?: string[], schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

Inherited from RunQueryBuilder.joinAndSelect
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: Field | [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>]
- alias: Alias
- cond: QBFilterQuery = {}
- type: JoinType = JoinType.innerJoin
- optionalpath: string
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

leftJoin

leftJoin<Field, Alias>(field: QueryBuilder<any, any> | QueryBuilder<any, never, never, never> | Field, alias: Alias, cond?: QBFilterQuery, schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, false>[K] }>

Inherited from RunQueryBuilder.leftJoin
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: QueryBuilder<any, any> | QueryBuilder<any, never, never, never> | Field
- alias: Alias
- cond: QBFilterQuery = {}
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, false>[K] }>

leftJoinAndSelect

leftJoinAndSelect<Field, Alias>(field: Field | [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>], alias: Alias, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

Inherited from RunQueryBuilder.leftJoinAndSelect
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: Field | [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>]
- alias: Alias
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

leftJoinLateral

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

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

leftJoinLateralAndSelect

leftJoinLateralAndSelect<Field, Alias>(field: [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>], alias: Alias, cond?: QBFilterQuery, fields?: string[], schema?: string): SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

Inherited from RunQueryBuilder.leftJoinLateralAndSelect
Type parameters
- Field: string | AnyString
- Alias: string
Parameters
- field: [field: Field, qb: QueryBuilder<any, any> | QueryBuilder<any, never, never, never>]
- alias: Alias
- cond: QBFilterQuery = {}
- optionalfields: string[]
- optionalschema: string
Returns SelectQueryBuilder<T, any, any, { [ K in string ]: AddToContext<GetType<T, object, Field>, object, Field, Alias, true>[K] }>

limit

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

Inherited from RunQueryBuilder.limit
Parameters
- optionallimit: number
- offset: number = 0
Returns SelectQueryBuilder<T, any, any, never>

merge

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

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

offset

offset(offset?: number): SelectQueryBuilder<T, any, any, never>

Inherited from RunQueryBuilder.offset
Parameters
- optionaloffset: number
Returns SelectQueryBuilder<T, any, any, never>

onConflict

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

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

orWhere

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

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

orderBy

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

Inherited from RunQueryBuilder.orderBy
Parameters
- orderBy: QBQueryOrderMap<T> | QBQueryOrderMap<T>[]
Returns SelectQueryBuilder<T, any, any, never>

returning

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

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

select

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

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

setFlag

setFlag(flag: QueryFlag): this

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

setFlushMode

setFlushMode(flushMode?: FlushMode): this

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

setLockMode

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

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

setLoggerContext

setLoggerContext(context: LoggingOptions & Dictionary): void

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

then

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

Inherited from RunQueryBuilder.then
Type parameters
- TResult1 = QueryResult<T>
- TResult2 = never
Parameters
- optionalonfulfilled: null | (value: QueryResult<T>) => TResult1 | PromiseLike<TResult1>
- optionalonrejected: null | (reason: any) => TResult2 | PromiseLike<TResult2>
Returns Promise<QueryResult<T>>

toQuery

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

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

truncate

truncate(): TruncateQueryBuilder<T>

Inherited from RunQueryBuilder.truncate
Returns TruncateQueryBuilder<T>

unsetFlag

unsetFlag(flag: QueryFlag): this

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

update

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

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

where

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

Inherited from RunQueryBuilder.where
Parameters
- cond: string | QBFilterQuery<T>
- optionalparams: any[] | $and | $or
- optionaloperator: $and | $or
Returns this

withSchema

withSchema(schema?: string): this

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

withSubQuery

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

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

Hierarchy

Index

Properties

Methods

Properties

alias

helper

mainAlias

Methods

addSelect

Parameters

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

Returns SelectQueryBuilder<T, any, any, never>

andWhere

Parameters

cond: QBFilterQuery<T>

Returns this

applyFilters

Parameters

filterOptions: boolean | string[] | Dictionary<boolean | Dictionary> = {}

Returns Promise<QueryBuilder<T, any, any, never>>

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, never, never, never>

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, any, any, never>

distinctOn

Parameters

fields: string | string[]

Returns SelectQueryBuilder<T, any, any, never>

execute

Type parameters

Parameters

optionalmethod: get | all | run

optionalmapResults: boolean

Returns Promise<Result>

from

Type parameters

Parameters

target: QueryBuilder<Entity, never, never, never>

optionalaliasName: string

Returns SelectQueryBuilder<Entity, any, any, never>

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