Class SelectCore

Hierarchy

Node
- SelectCore

Index

Constructors

Properties

comment groups havings optimizerHints projections setQuantifier source wheres windows

Accessors

Methods

and coalesce createAnd createFalse createJoin createOn createStringJoin createTableAlias createTrue grouping lower not or toSQL

Constructors

constructor

new SelectCore(): SelectCore
Returns SelectCore

Inherited from Node.constructor

Properties

comment

comment: any = null

groups

groups: any[] = []

havings

havings: any[] = []

optimizerHints

optimizerHints: any = null

projections

projections: any[] = []

setQuantifier

setQuantifier: any = null

source

source: JoinSource = ...

wheres

wheres: any[] = []

windows

windows: any[] = []

Accessors

from

get from(): any
Returns any
- Defined in src/nodes/SelectCore.ts:23
set from(val): void
Parameters
- val: any
Returns void
- Defined in src/nodes/SelectCore.ts:27

froms

get froms(): any
Returns any
- Defined in src/nodes/SelectCore.ts:31
set froms(val): void
Parameters
- val: any
Returns void
- Defined in src/nodes/SelectCore.ts:35

Methods

and

and(right): And
Parameters
- right: any
Returns And
Inherited from Node.and
- Defined in src/mixins/NodeMethods.ts:11

coalesce

coalesce(...exprs): NamedSQLFunction
Parameters
- Rest ...exprs: any[]
Returns NamedSQLFunction
Inherited from Node.coalesce
- Defined in src/mixins/FactoryMethods.ts:22

createAnd

createAnd(clauses): And
Parameters
- clauses: any[]
Returns And
Inherited from Node.createAnd
- Defined in src/mixins/FactoryMethods.ts:26

createFalse

createFalse(): False
Returns False
Inherited from Node.createFalse
- Defined in src/mixins/FactoryMethods.ts:30

createJoin

createJoin(to): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
Returns InnerJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:34
createJoin(to, constraint): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
Returns InnerJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:35
createJoin(to, constraint, Klass): FullOuterJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof FullOuterJoin
Returns FullOuterJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:39
createJoin(to, constraint, Klass): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof InnerJoin
Returns InnerJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:44
createJoin(to, constraint, Klass): OuterJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof OuterJoin
Returns OuterJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:49
createJoin(to, constraint, Klass): RightOuterJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof RightOuterJoin
Returns RightOuterJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:54
createJoin(to, constraint, Klass): StringJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof StringJoin
Returns StringJoin
Inherited from Node.createJoin
- Defined in src/mixins/FactoryMethods.ts:59

createOn

createOn(expr): On
Parameters
- expr: any
Returns On
Inherited from Node.createOn
- Defined in src/mixins/FactoryMethods.ts:72

createStringJoin

createStringJoin(to): StringJoin
Parameters
- to: null | string | SQLLiteral | Relation
Returns StringJoin
Inherited from Node.createStringJoin
- Defined in src/mixins/FactoryMethods.ts:76

createTableAlias

createTableAlias(relation, name): TableAlias
Parameters
- relation: Relation | Grouping
- name: string | SQLLiteral
Returns TableAlias
Inherited from Node.createTableAlias
- Defined in src/mixins/FactoryMethods.ts:80

createTrue

createTrue(): True
Returns True
Inherited from Node.createTrue
- Defined in src/mixins/FactoryMethods.ts:87

grouping

grouping(expr): Grouping
Parameters
- expr: any
Returns Grouping
Inherited from Node.grouping
- Defined in src/mixins/FactoryMethods.ts:91

lower

lower(column): NamedSQLFunction
Parameters
- column: any
Returns NamedSQLFunction
Inherited from Node.lower
- Defined in src/mixins/FactoryMethods.ts:95

not

not(this): Not
Parameters
- this: Node
Returns Not
Inherited from Node.not
- Defined in src/mixins/NodeMethods.ts:15

or

or<T>(right): Grouping
Type Parameters
- T extends Visitable
Parameters
- right: T
Returns Grouping
Inherited from Node.or
- Defined in src/mixins/NodeMethods.ts:19

toSQL

toSQL(engine?): any
Parameters
- engine: undefined | null | Engine = undefined
Returns any
Inherited from Node.toSQL
- Defined in src/nodes/Node.ts:16

Generated using TypeDoc