Class NamedWindow

Hierarchy

Window
- NamedWindow

Index

Constructors

Properties

framing name orders partitions

Methods

and coalesce createAnd createFalse createJoin createOn createStringJoin createTableAlias createTrue frame grouping lower not or order partition range rows toSQL

Constructors

constructor

new NamedWindow(name): NamedWindow
Parameters
- name: any
Returns NamedWindow
Overrides Window.constructor
- Defined in src/nodes/NamedWindow.ts:6

Properties

framing

framing: any = null

name

name: any

orders

orders: any[] = []

partitions

partitions: any[] = []

Methods

and

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

coalesce

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

createAnd

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

createFalse

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

createJoin

createJoin(to): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
Returns InnerJoin
Inherited from Window.createJoin
- Defined in src/mixins/FactoryMethods.ts:34
createJoin(to, constraint): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
Returns InnerJoin
Inherited from Window.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 Window.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 Window.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 Window.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 Window.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 Window.createJoin
- Defined in src/mixins/FactoryMethods.ts:59

createOn

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

createStringJoin

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

createTableAlias

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

createTrue

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

frame

frame(expr): any
Parameters
- expr: any
Returns any
Inherited from Window.frame
- Defined in src/nodes/Window.ts:13

grouping

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

lower

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

not

not(this): Not
Parameters
- this: Node
Returns Not
Inherited from Window.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 Window.or
- Defined in src/mixins/NodeMethods.ts:19

order

order(...expr): Window
Parameters
- Rest ...expr: any[]
Returns Window
Inherited from Window.order
- Defined in src/nodes/Window.ts:19

partition

partition(...expr): Window
Parameters
- Rest ...expr: any[]
Returns Window
Inherited from Window.partition
- Defined in src/nodes/Window.ts:27

range

range(expr?): Range
Parameters
- expr: any = null
Returns Range
Inherited from Window.range
- Defined in src/nodes/Window.ts:35

rows

rows(expr?): Rows
Parameters
- expr: any = null
Returns Rows
Inherited from Window.rows
- Defined in src/nodes/Window.ts:45

toSQL

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

Generated using TypeDoc