Class Table

constructor

• new Table(name, as?, typeCaster?): Table

• Parameters

  • name: string

  • as: null | string | TableAlias = null

  • typeCaster: any = null

  Returns Table

Readonly Abstract ast

name

tableAlias

tableName

• get tableName(): string

• Returns string

alias

• alias(name?): TableAlias

• Parameters

  • name: null | string = null

  Returns TableAlias

coalesce

• coalesce(...exprs): NamedSQLFunction

• Parameters

  • Rest ...exprs: any[]

  Returns NamedSQLFunction

compileDelete

• compileDelete(): DeleteManager

• Returns DeleteManager

compileInsert

• compileInsert(values): InsertManager

• Parameters

  • values: any

  Returns InsertManager

compileUpdate

• compileUpdate(values, pk): UpdateManager

• Parameters

  • values: any

  • pk: any

  Returns UpdateManager

createAnd

• createAnd(clauses): And

• Parameters

  • clauses: any[]

  Returns And

createFalse

• createFalse(): False

• Returns False

createInsert

• createInsert(): InsertManager

• Returns InsertManager

createJoin

• createJoin(to): InnerJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  Returns InnerJoin

• createJoin(to, constraint): InnerJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  • constraint: any

  Returns InnerJoin

• createJoin(to, constraint, Klass): FullOuterJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  • constraint: any

  • Klass: typeof FullOuterJoin

  Returns FullOuterJoin

• createJoin(to, constraint, Klass): InnerJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  • constraint: any

  • Klass: typeof InnerJoin

  Returns InnerJoin

• createJoin(to, constraint, Klass): OuterJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  • constraint: any

  • Klass: typeof OuterJoin

  Returns OuterJoin

• createJoin(to, constraint, Klass): RightOuterJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  • constraint: any

  • Klass: typeof RightOuterJoin

  Returns RightOuterJoin

• createJoin(to, constraint, Klass): StringJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  • constraint: any

  • Klass: typeof StringJoin

  Returns StringJoin

createOn

• createOn(expr): On

• Parameters

  • expr: any

  Returns On

createStringJoin

• createStringJoin(to): StringJoin

• Parameters

  • to: null | string | SQLLiteral | Relation

  Returns StringJoin

createTableAlias

• createTableAlias(relation, name): TableAlias

• Parameters

  • relation: Relation | Grouping

  • name: string | SQLLiteral

  Returns TableAlias

createTrue

• createTrue(): True

• Returns True

from

• from(): SelectManager

• Returns SelectManager

get

• get(name): Attribute

• Parameters

  • name: string | SQLLiteral

  Returns Attribute

group

• group(...columns): SelectManager

• Parameters

  • Rest ...columns: (string | Attribute)[]

  Returns SelectManager

grouping

• grouping(expr): Grouping

• Parameters

  • expr: any

  Returns Grouping

having

• having(expr): SelectManager

• Parameters

  • expr: any

  Returns SelectManager

isAbleToTypeCast

• isAbleToTypeCast(): boolean

• Returns boolean

join

• join(relation, klass?): SelectManager

• Parameters

  • relation: null | string | SQLLiteral | Relation

  • klass: typeof Join = InnerJoin

  Returns SelectManager

lower

• lower(column): NamedSQLFunction

• Parameters

  • column: any

  Returns NamedSQLFunction

order

• order(...expr): SelectManager

• Parameters

  • Rest ...expr: any[]

  Returns SelectManager

outerJoin

• outerJoin(relation): SelectManager

• Parameters

  • relation: null | string | SQLLiteral | Relation

  Returns SelectManager

project

• project(...things): SelectManager

• Parameters

  • Rest ...things: any[]

  Returns SelectManager

skip

• skip(amount): SelectManager

• Parameters

  • amount: any

  Returns SelectManager

take

• take(amount): SelectManager

• Parameters

  • amount: any

  Returns SelectManager

typeCastForDatabase

• typeCastForDatabase(attributeName, value): string | number

• Parameters

  • attributeName: string | SQLLiteral

  • value: Visitable

  Returns string | number

where

• where(condition): SelectManager

• Parameters

  • condition: any

  Returns SelectManager