IQueryBuilder <T>

Index

Properties

• _fields
• alias
• type

Methods

• addSelect
• andWhere
• clone
• count
• delete
• from
• getAliasForJoinPath
• getJoinForPath
• getNextAlias
• groupBy
• hasFlag
• having
• innerJoin
• innerJoinAndSelect
• insert
• join
• joinAndSelect
• leftJoin
• leftJoinAndSelect
• orderBy
• orWhere
• select
• setFlag
• truncate
• unsetFlag
• update
• where
• withSubQuery

Properties

optional_fields

_fields?: Field<T>[]

readonlyalias

alias: string

optionalreadonlytype

type?: QueryType

Methods

addSelect

• addSelect(fields): this

• Parameters

  • fields: string | string[]

  Returns this

andWhere

• andWhere(cond): this
• andWhere(cond, params): this

• Parameters

  • cond: QBFilterQuery<T>

  Returns this

clone

• clone(reset): IQueryBuilder<T>

• Parameters

  • optionalreset: boolean

  Returns IQueryBuilder<T>

count

• count(field, distinct): this

• Parameters

  • optionalfield: string | string[]

  • optionaldistinct: boolean

  Returns this

delete

• delete(cond): this

• Parameters

  • optionalcond: QBFilterQuery

  Returns this

from

• from(target, aliasName): IQueryBuilder<T>

• Parameters

  • target: EntityName<T> | IQueryBuilder<T>

  • optionalaliasName: string

  Returns IQueryBuilder<T>

getAliasForJoinPath

• getAliasForJoinPath(path, options): undefined | string

• Parameters

  • path: string

  • optionaloptions: ICriteriaNodeProcessOptions

  Returns undefined | string

getJoinForPath

• getJoinForPath(path, options): undefined | JoinOptions

• Parameters

  • optionalpath: string

  • optionaloptions: ICriteriaNodeProcessOptions

  Returns undefined | JoinOptions

getNextAlias

• getNextAlias(entityName): string

• Parameters

  • optionalentityName: string

  Returns string

groupBy

• groupBy(fields): this

• Parameters

  • fields: string | keyof T | (string | keyof T)[]

  Returns this

hasFlag

• hasFlag(flag): boolean

• Parameters

  • flag: QueryFlag

  Returns boolean

having

• having(cond, params): this

• Parameters

  • optionalcond: string | QBFilterQuery

  • optionalparams: any[]

  Returns this

innerJoin

• innerJoin(field, alias, cond): this

• Parameters

  • field: string

  • alias: string

  • optionalcond: QBFilterQuery

  Returns this

innerJoinAndSelect

• innerJoinAndSelect(field, alias, cond, fields): this

• Parameters

  • field: string

  • alias: string

  • optionalcond: QBFilterQuery

  • optionalfields: string[]

  Returns this

insert

• insert(data): this

• Parameters

  • data: any

  Returns this

join

• join(field, alias, cond, type, path): this

• Parameters

  • field: string

  • alias: string

  • optionalcond: QBFilterQuery

  • optionaltype: JoinType

  • optionalpath: string

  Returns this

joinAndSelect

• joinAndSelect(field, alias, cond): this

• Parameters

  • field: string

  • alias: string

  • optionalcond: QBFilterQuery

  Returns this

leftJoin

• leftJoin(field, alias, cond): this

• Parameters

  • field: string

  • alias: string

  • optionalcond: QBFilterQuery

  Returns this

leftJoinAndSelect

• leftJoinAndSelect(field, alias, cond, fields): this

• Parameters

  • field: string

  • alias: string

  • optionalcond: QBFilterQuery

  • optionalfields: string[]

  Returns this

orderBy

• orderBy(orderBy): this

• Parameters

  • orderBy: QueryOrderMap<T>

  Returns this

orWhere

• orWhere(cond): this
• orWhere(cond, params): this

• Parameters

  • cond: QBFilterQuery<T>

  Returns this

select

• select(fields, distinct): this

• Parameters

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

  • optionaldistinct: boolean

  Returns this

setFlag

• setFlag(flag): this

• Parameters

  • flag: QueryFlag

  Returns this

truncate

• truncate(): this

• Returns this

unsetFlag

• unsetFlag(flag): this

• Parameters

  • flag: QueryFlag

  Returns this

update

• update(data): this

• Parameters

  • data: any

  Returns this

where

• where(cond, operator): this
• where(cond, params, operator): this

• Parameters

  • cond: QBFilterQuery<T>

  • optionaloperator: $and | $or

  Returns this

withSubQuery

• withSubQuery(subQuery, alias): this

• Parameters

  • subQuery: QueryBuilder<any, any>

  • alias: string

  Returns this