Class UpdateStatement

Hierarchy

Node
- UpdateStatement

Index

Constructors

Properties

key limit offset orders relation values wheres

Accessors

Methods

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

Constructors

constructor

new UpdateStatement(): UpdateStatement
Returns UpdateStatement

Inherited from Node.constructor

Properties

key

key: any = null

limit

limit: any = null

offset

offset: any = null

orders

orders: any[] = []

relation

relation: null | SQLLiteral | Relation | JoinSource = null

values

values: any[] = []

wheres

wheres: any[] = []

Accessors

value

set value(expr): void
Parameters
- expr: any
Returns void
- Defined in src/nodes/UpdateStatement.ts:23

where

set where(expr): void
Parameters
- expr: any
Returns void
- Defined in src/nodes/UpdateStatement.ts:27

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