Class Exists

Hierarchy

SQLFunction
- Exists

Constructors

constructor

new Exists(expr, aliaz?): Exists
Parameters
- expr: any
- aliaz: null | string | SQLLiteral = null
Returns Exists
Inherited from SQLFunction.constructor
- Defined in src/nodes/SQLFunction.ts:13

Properties

alias

alias: null | SQLLiteral = null

distinct

distinct: null | boolean

expressions

expressions: any

Methods

add

add(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.add
- Defined in src/mixins/Math.ts:14

and

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

as

as(aliaz): SQLFunction
Parameters
- aliaz: any
Returns SQLFunction
Inherited from SQLFunction.as
- Defined in src/nodes/SQLFunction.ts:23

asc

asc(this): Ascending
Parameters
- this: Visitable
Returns Ascending
Inherited from SQLFunction.asc
- Defined in src/mixins/OrderPredications.ts:7

average

average(): Avg
Returns Avg
Inherited from SQLFunction.average
- Defined in src/mixins/Expressions.ts:9

between

between(begin, end, inclusive?): Between | GreaterThanOrEqual | LessThan | LessThanOrEqual | NotIn | And
Parameters
- begin: number | BindParam | Quoted
- end: number | BindParam | Quoted
- inclusive: boolean = true
Returns Between | GreaterThanOrEqual | LessThan | LessThanOrEqual | NotIn | And
Inherited from SQLFunction.between
- Defined in src/mixins/Predications.ts:257

bitwiseAnd

bitwiseAnd(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.bitwiseAnd
- Defined in src/mixins/Math.ts:18

bitwiseNot

bitwiseNot(): BitwiseNot
Returns BitwiseNot
Inherited from SQLFunction.bitwiseNot
- Defined in src/mixins/Math.ts:22

bitwiseOr

bitwiseOr(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.bitwiseOr
- Defined in src/mixins/Math.ts:26

bitwiseShiftLeft

bitwiseShiftLeft(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.bitwiseShiftLeft
- Defined in src/mixins/Math.ts:30

bitwiseShiftRight

bitwiseShiftRight(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.bitwiseShiftRight
- Defined in src/mixins/Math.ts:34

bitwiseXor

bitwiseXor(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.bitwiseXor
- Defined in src/mixins/Math.ts:38

coalesce

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

concat

concat(other): Concat
Parameters
- other: any
Returns Concat
Inherited from SQLFunction.concat
- Defined in src/mixins/ConcatPredication.ts:4

count

count(distinct?): Count
Parameters
- distinct: boolean = false
Returns Count
Inherited from SQLFunction.count
- Defined in src/mixins/Expressions.ts:13

createAnd

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

createFalse

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

createJoin

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

createOn

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

createStringJoin

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

createTableAlias

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

createTrue

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

desc

desc(this): Descending
Parameters
- this: Visitable
Returns Descending
Inherited from SQLFunction.desc
- Defined in src/mixins/OrderPredications.ts:11

divide

divide(other): Division
Parameters
- other: any
Returns Division
Inherited from SQLFunction.divide
- Defined in src/mixins/Math.ts:42

doesNotMatch

doesNotMatch(other, escape?, caseSensitive?): DoesNotMatch
Parameters
- other: any
- escape: any = null
- caseSensitive: boolean = false
Returns DoesNotMatch
Inherited from SQLFunction.doesNotMatch
- Defined in src/mixins/Predications.ts:57

doesNotMatchAll

doesNotMatchAll(others, escape?, caseSensitive?): Grouping
Parameters
- others: any
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from SQLFunction.doesNotMatchAll
- Defined in src/mixins/Predications.ts:65

doesNotMatchAny

doesNotMatchAny(others, escape?, caseSensitive?): Grouping
Parameters
- others: any
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from SQLFunction.doesNotMatchAny
- Defined in src/mixins/Predications.ts:78

doesNotMatchRegexp

doesNotMatchRegexp(other, caseSensitive?): NotRegexp
Parameters
- other: any
- caseSensitive: boolean = true
Returns NotRegexp
Inherited from SQLFunction.doesNotMatchRegexp
- Defined in src/mixins/Predications.ts:91

eq

eq(other): Equality<any, any>
Parameters
- other: any
Returns Equality<any, any>
Inherited from SQLFunction.eq
- Defined in src/mixins/Predications.ts:95

eqAll

eqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.eqAll
- Defined in src/mixins/Predications.ts:99

eqAny

eqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.eqAny
- Defined in src/mixins/Predications.ts:103

extract

extract(field): Extract
Parameters
- field: any
Returns Extract
Inherited from SQLFunction.extract
- Defined in src/mixins/Expressions.ts:17

grouping

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

`Protected` groupingAll

groupingAll(method, others, ...extras): Grouping
Parameters
- method: ((expr, ...extras) => any)
  - - (expr, ...extras): any
    - Parameters
      
      expr: any
      
      Rest ...extras: any[]
      
      Returns any
- others: any[]
- Rest ...extras: any[]
Returns Grouping
Inherited from SQLFunction.groupingAll
- Defined in src/mixins/Predications.ts:25

`Protected` groupingAny

groupingAny(method, others, ...extras): Grouping
Parameters
- method: ((expr, ...extras) => any)
  - - (expr, ...extras): any
    - Parameters
      
      expr: any
      
      Rest ...extras: any[]
      
      Returns any
- others: any[]
- Rest ...extras: any[]
Returns Grouping
Inherited from SQLFunction.groupingAny
- Defined in src/mixins/Predications.ts:35

gt

gt(other): GreaterThan
Parameters
- other: any
Returns GreaterThan
Inherited from SQLFunction.gt
- Defined in src/mixins/Predications.ts:107

gtAll

gtAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.gtAll
- Defined in src/mixins/Predications.ts:111

gtAny

gtAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.gtAny
- Defined in src/mixins/Predications.ts:115

gteq

gteq(other): GreaterThanOrEqual
Parameters
- other: any
Returns GreaterThanOrEqual
Inherited from SQLFunction.gteq
- Defined in src/mixins/Predications.ts:119

gteqAll

gteqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.gteqAll
- Defined in src/mixins/Predications.ts:123

gteqAny

gteqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.gteqAny
- Defined in src/mixins/Predications.ts:127

inAll

inAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.inAll
- Defined in src/mixins/Predications.ts:143

inAny

inAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.inAny
- Defined in src/mixins/Predications.ts:147

inVal

inVal(other): In
Parameters
- other: any
Returns In
Inherited from SQLFunction.inVal
- Defined in src/mixins/Predications.ts:131

isDistinctFrom

isDistinctFrom(other): IsDistinctFrom
Parameters
- other: any
Returns IsDistinctFrom
Inherited from SQLFunction.isDistinctFrom
- Defined in src/mixins/Predications.ts:155

`Protected` isInfinity

isInfinity(value): boolean
Parameters
- value: any
Returns boolean
Inherited from SQLFunction.isInfinity
- Defined in src/mixins/Predications.ts:45

isNotDistinctFrom

isNotDistinctFrom(other): IsNotDistinctFrom
Parameters
- other: any
Returns IsNotDistinctFrom
Inherited from SQLFunction.isNotDistinctFrom
- Defined in src/mixins/Predications.ts:151

`Protected` isOpenEnded

isOpenEnded(value): boolean
Parameters
- value: any
Returns boolean
Inherited from SQLFunction.isOpenEnded
- Defined in src/mixins/Predications.ts:49

`Protected` isUnboundable

isUnboundable(value): boolean
Parameters
- value: any
Returns boolean
Inherited from SQLFunction.isUnboundable
- Defined in src/mixins/Predications.ts:53

lower

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

lt

lt(other): LessThan
Parameters
- other: any
Returns LessThan
Inherited from SQLFunction.lt
- Defined in src/mixins/Predications.ts:159

ltAll

ltAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.ltAll
- Defined in src/mixins/Predications.ts:163

ltAny

ltAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.ltAny
- Defined in src/mixins/Predications.ts:167

lteq

lteq(other): LessThanOrEqual
Parameters
- other: any
Returns LessThanOrEqual
Inherited from SQLFunction.lteq
- Defined in src/mixins/Predications.ts:171

lteqAll

lteqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.lteqAll
- Defined in src/mixins/Predications.ts:175

lteqAny

lteqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.lteqAny
- Defined in src/mixins/Predications.ts:179

matches

matches(other, escape?, caseSensitive?): Matches
Parameters
- other: any
- escape: any = null
- caseSensitive: boolean = false
Returns Matches
Inherited from SQLFunction.matches
- Defined in src/mixins/Predications.ts:183

matchesAll

matchesAll(others, escape?, caseSensitive?): Grouping
Parameters
- others: any[]
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from SQLFunction.matchesAll
- Defined in src/mixins/Predications.ts:187

matchesAny

matchesAny(others, escape?, caseSensitive?): Grouping
Parameters
- others: any[]
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from SQLFunction.matchesAny
- Defined in src/mixins/Predications.ts:200

matchesRegexp

matchesRegexp(other, caseSensitive?): Regexp
Parameters
- other: any
- caseSensitive: boolean = true
Returns Regexp
Inherited from SQLFunction.matchesRegexp
- Defined in src/mixins/Predications.ts:213

maximum

maximum(): Max
Returns Max
Inherited from SQLFunction.maximum
- Defined in src/mixins/Expressions.ts:21

minimum

minimum(): Min
Returns Min
Inherited from SQLFunction.minimum
- Defined in src/mixins/Expressions.ts:25

multiply

multiply(other): Multiplication
Parameters
- other: any
Returns Multiplication
Inherited from SQLFunction.multiply
- Defined in src/mixins/Math.ts:46

not

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

notBetween

notBetween(begin, end, inclusive?): Grouping | In | GreaterThan | GreaterThanOrEqual | LessThan
Parameters
- begin: number | BindParam | Quoted
- end: number | BindParam | Quoted
- inclusive: boolean = true
Returns Grouping | In | GreaterThan | GreaterThanOrEqual | LessThan
Inherited from SQLFunction.notBetween
- Defined in src/mixins/Predications.ts:292

notEq

notEq(other): NotEqual
Parameters
- other: any
Returns NotEqual
Inherited from SQLFunction.notEq
- Defined in src/mixins/Predications.ts:217

notEqAll

notEqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.notEqAll
- Defined in src/mixins/Predications.ts:221

notEqAny

notEqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.notEqAny
- Defined in src/mixins/Predications.ts:225

notInAll

notInAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.notInAll
- Defined in src/mixins/Predications.ts:241

notInAny

notInAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from SQLFunction.notInAny
- Defined in src/mixins/Predications.ts:245

notInVal

notInVal(other): NotIn
Parameters
- other: any
Returns NotIn
Inherited from SQLFunction.notInVal
- Defined in src/mixins/Predications.ts:229

or

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

over

over(expr?): Over
Parameters
- expr: null | string | Node | SQLLiteral = null
Returns Over
Inherited from SQLFunction.over
- Defined in src/mixins/WindowPredication.ts:6

quotedArray

quotedArray(others): any[]
Parameters
- others: any[]
Returns any[]
Inherited from SQLFunction.quotedArray
- Defined in src/mixins/Predications.ts:253

quotedNode

quotedNode(other): any
Parameters
- other: any
Returns any
Inherited from SQLFunction.quotedNode
- Defined in src/mixins/Predications.ts:249

subtract

subtract(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from SQLFunction.subtract
- Defined in src/mixins/Math.ts:50

sum

sum(): Sum
Returns Sum
Inherited from SQLFunction.sum
- Defined in src/mixins/Expressions.ts:29

toSQL

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

when

when(other): Case
Parameters
- other: any
Returns Case
Inherited from SQLFunction.when
- Defined in src/mixins/WhenPredication.ts:5

Class Exists

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

expr: any

aliaz: null | string | SQLLiteral = null

Returns Exists

Properties

alias

distinct

expressions

Methods

add

Parameters

other: any

Returns Grouping

and

Parameters

right: any

Returns And

as

Parameters

aliaz: any

Returns SQLFunction

asc

Parameters

this: Visitable

Returns Ascending

average

Returns Avg

between

Parameters

begin: number | BindParam | Quoted

end: number | BindParam | Quoted

inclusive: boolean = true

Returns Between | GreaterThanOrEqual | LessThan | LessThanOrEqual | NotIn | And

bitwiseAnd

Parameters

other: any

Returns Grouping

bitwiseNot

Returns BitwiseNot

bitwiseOr

Parameters

other: any

Returns Grouping

bitwiseShiftLeft

Parameters

other: any

Returns Grouping

bitwiseShiftRight

Parameters

other: any

Returns Grouping

bitwiseXor

Parameters

other: any

Returns Grouping

coalesce

Parameters

Rest ...exprs: any[]

Returns NamedSQLFunction

concat

Parameters

other: any

Returns Concat

count

Parameters

distinct: boolean = false

Returns Count

createAnd

Parameters

clauses: any[]

Returns And

createFalse

`Rest` ...exprs: any[]