Class SelectManager

Hierarchy

TreeManager<SelectManager, SelectStatement>
default
- SelectManager

Index

Constructors

constructor

new SelectManager(table?): SelectManager
Parameters
- table: any = null
Returns SelectManager
Overrides TreeManager.constructor
- Defined in src/managers/SelectManager.ts:101

Properties

`Readonly` ast

ast: SelectStatement

`Protected` ctx

ctx: SelectCore

Accessors

constraints

get constraints(): any[]
Returns any[]
- Defined in src/managers/SelectManager.ts:49

froms

get froms(): SelectCore[]
Returns SelectCore[]
- Defined in src/managers/SelectManager.ts:53

joinSources

get joinSources(): any
Returns any
- Defined in src/managers/SelectManager.ts:57

limit

get limit(): any
Returns any
- Defined in src/managers/SelectManager.ts:61
set limit(limit): void
Parameters
- limit: any
Returns void
- Defined in src/managers/SelectManager.ts:65

locked

get locked(): any
Returns any
- Defined in src/managers/SelectManager.ts:69

offset

get offset(): any
Returns any
- Defined in src/managers/SelectManager.ts:73
set offset(amount): void
Parameters
- amount: any
Returns void
- Defined in src/managers/SelectManager.ts:77

orders

get orders(): any[]
Returns any[]
- Defined in src/managers/SelectManager.ts:81

projections

get projections(): any[]
Returns any[]
- Defined in src/managers/SelectManager.ts:85
set projections(projections): void
Parameters
- projections: any[]
Returns void
- Defined in src/managers/SelectManager.ts:89

source

get source(): JoinSource
Returns JoinSource
- Defined in src/managers/SelectManager.ts:93

taken

get taken(): any
Returns any
- Defined in src/managers/SelectManager.ts:97

Methods

as

as(other): TableAlias
Parameters
- other: any
Returns TableAlias
- Defined in src/managers/SelectManager.ts:127

coalesce

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

`Private` collapse

collapse(exprs): any
Parameters
- exprs: any[]
Returns any
- Defined in src/managers/SelectManager.ts:109

comment

comment(...values): SelectManager
Parameters
- Rest ...values: any
Returns SelectManager
- Defined in src/managers/SelectManager.ts:131

compileDelete

compileDelete(): DeleteManager
Returns DeleteManager
- Defined in src/mixins/CRUD.ts:49

compileInsert

compileInsert(values): InsertManager
Parameters
- values: any
Returns InsertManager
- Defined in src/mixins/CRUD.ts:37

compileUpdate

compileUpdate(values, pk): UpdateManager
Parameters
- values: any
- pk: any
Returns UpdateManager
- Defined in src/mixins/CRUD.ts:15

createAnd

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

createFalse

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

createInsert

createInsert(): InsertManager
Returns InsertManager
- Defined in src/mixins/CRUD.ts:45

createJoin

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

createOn

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

createStringJoin

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

createTableAlias

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

createTrue

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

distinct

distinct(value?): SelectManager
Parameters
- value: boolean = true
Returns SelectManager
- Defined in src/managers/SelectManager.ts:137

distinctOn

distinctOn(value): SelectManager
Parameters
- value: any
Returns SelectManager
- Defined in src/managers/SelectManager.ts:143

except

except(other): Except
Parameters
- other: TreeManager<SelectManager, SelectStatement>
Returns Except
- Defined in src/managers/SelectManager.ts:149

exists

exists(): Exists
Returns Exists
- Defined in src/managers/SelectManager.ts:153

from

from(table): SelectManager
Parameters
- table: any
Returns SelectManager
- Defined in src/managers/SelectManager.ts:157

group

group(...columns): SelectManager
Parameters
- Rest ...columns: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:169

grouping

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

having

having(expr): SelectManager
Parameters
- expr: any
Returns SelectManager
- Defined in src/managers/SelectManager.ts:183

intersect

intersect(other): Intersect
Parameters
- other: TreeManager<SelectManager, SelectStatement>
Returns Intersect
- Defined in src/managers/SelectManager.ts:189

join

join(relation, klass?): SelectManager
Parameters
- relation: null | string | SQLLiteral | Relation
- klass: typeof Join = InnerJoin
Returns SelectManager
- Defined in src/managers/SelectManager.ts:193

lateral

lateral(tableName?): Lateral
Parameters
- tableName: null | string = null
Returns Lateral
- Defined in src/managers/SelectManager.ts:218

lock

lock(locking?): SelectManager
Parameters
- locking: any = ...
Returns SelectManager
- Defined in src/managers/SelectManager.ts:224

lower

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

minus

minus(other): Except
Parameters
- other: TreeManager<SelectManager, SelectStatement>
Returns Except
- Defined in src/managers/SelectManager.ts:237

on

on(...exprs): SelectManager
Parameters
- Rest ...exprs: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:241

optimizerHints

optimizerHints(...hints): SelectManager
Parameters
- Rest ...hints: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:249

order

order(...expr): SelectManager
Parameters
- Rest ...expr: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:257

outerJoin

outerJoin(relation): SelectManager
Parameters
- relation: null | Relation
Returns SelectManager
- Defined in src/managers/SelectManager.ts:265

project

project(...projections): SelectManager
Parameters
- Rest ...projections: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:269

skip

skip(amount): SelectManager
Parameters
- amount: any
Returns SelectManager
- Defined in src/managers/SelectManager.ts:279

take

take(limit): SelectManager
Parameters
- limit: any
Returns SelectManager
- Defined in src/managers/SelectManager.ts:285

toSQL

toSQL(engine?): null | string
Parameters
- engine: undefined | null | Engine = undefined
Returns null | string
Inherited from TreeManager.toSQL
- Defined in src/managers/TreeManager.ts:23

union

union(other): Union
Parameters
- other: TreeManager<SelectManager, SelectStatement>
Returns Union
- Defined in src/managers/SelectManager.ts:295

unionAll

unionAll(other): UnionAll
Parameters
- other: TreeManager<SelectManager, SelectStatement>
Returns UnionAll
- Defined in src/managers/SelectManager.ts:299

where

where(this, expr): SelectManager
Parameters
- this: SelectManager
- expr: any
Returns SelectManager
Inherited from TreeManager.where
- Defined in src/managers/TreeManager.ts:49

whereSQL

whereSQL(engine?): null | SQLLiteral
Parameters
- engine: undefined | null | Engine = undefined
Returns null | SQLLiteral
- Defined in src/managers/SelectManager.ts:303

window

window(name): NamedWindow
Parameters
- name: any
Returns NamedWindow
- Defined in src/managers/SelectManager.ts:329

with

with(...subqueries): SelectManager
Parameters
- Rest ...subqueries: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:337

withRecursive

withRecursive(...subqueries): SelectManager
Parameters
- Rest ...subqueries: any[]
Returns SelectManager
- Defined in src/managers/SelectManager.ts:345

Generated using TypeDoc