Interface BaseQueryBuilder

BaseQueryBuilder provides a basic implementation of QueryBuilder.

Hierarchy

BaseQueryBuilder

Index

Methods

buildFrom buildGroupBy buildHaving buildJoin buildLimit buildOrderBy buildOrderByAndLimit buildSelect buildUnion buildWhere db

Methods

buildFrom

buildFrom(tables): string
BuildFrom generates a FROM clause from the given tables.
Parameters
- tables: string[]
Returns string
- Defined in types.d.ts:4356

buildGroupBy

buildGroupBy(cols): string
BuildGroupBy generates a GROUP BY clause from the given group-by columns.
Parameters
- cols: string[]
Returns string
- Defined in types.d.ts:4380

buildHaving

buildHaving(e, params): string
BuildHaving generates a HAVING clause from the given expression.
Parameters
- e: Expression
- params: Params
Returns string
- Defined in types.d.ts:4374

buildJoin

buildJoin(joins, params): string
BuildJoin generates a JOIN clause from the given join information.
Parameters
- joins: JoinInfo[]
- params: Params
Returns string
- Defined in types.d.ts:4362

buildLimit

buildLimit(limit, offset): string
BuildLimit generates the LIMIT clause.
Parameters
- limit: number
- offset: number
Returns string
- Defined in types.d.ts:4404

buildOrderBy

buildOrderBy(cols): string
BuildOrderBy generates the ORDER BY clause.
Parameters
- cols: string[]
Returns string
- Defined in types.d.ts:4398

buildOrderByAndLimit

buildOrderByAndLimit(sql, cols, limit, offset): string
BuildOrderByAndLimit generates the ORDER BY and LIMIT clauses.
Parameters
- sql: string
- cols: string[]
- limit: number
- offset: number
Returns string
- Defined in types.d.ts:4386

buildSelect

buildSelect(cols, distinct, option): string
BuildSelect generates a SELECT clause from the given selected column names.
Parameters
- cols: string[]
- distinct: boolean
- option: string
Returns string
- Defined in types.d.ts:4350

buildUnion

buildUnion(unions, params): string
BuildUnion generates a UNION clause from the given union information.
Parameters
- unions: UnionInfo[]
- params: Params
Returns string
- Defined in types.d.ts:4392

buildWhere

buildWhere(e, params): string
BuildWhere generates a WHERE clause from the given expression.
Parameters
- e: Expression
- params: Params
Returns string
- Defined in types.d.ts:4368

db

db(): dbx.DB
DB returns the DB instance associated with the query builder.

Returns dbx.DB
- Defined in types.d.ts:4344

Generated using TypeDoc