Class SqlHandler

Hierarchy

SqlHandler

Index

Constructors

Accessors

Constructors

constructor

new SqlHandler(): SqlHandler
Returns SqlHandler
- Defined in core/sql-handler.ts:10

Accessors

query

get query(): string
Returns string
- Defined in core/sql-handler.ts:302

Methods

and

and(condition: StringOrNumber): SqlHandler
Parameters
- condition: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:261

as

as(newName: string): SqlHandler
Parameters
- newName: string
Returns SqlHandler
- Defined in core/sql-handler.ts:55

between

between(val: StringOrNumber): SqlHandler
Parameters
- val: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:256

crossJoin

crossJoin(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:275

delete

delete(): SqlHandler
Returns SqlHandler
- Defined in core/sql-handler.ts:107

equalTo

equalTo(val: StringOrNumber): SqlHandler
Parameters
- val: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:181

fetchNextRows

fetchNextRows(rowCount: number): SqlHandler
Parameters
- rowCount: number
  
  the number of rows to fetch.
Returns SqlHandler
- Defined in core/sql-handler.ts:88

from

from(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:48

fullOuterJoin

fullOuterJoin(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:280

greaterThan

greaterThan(value: number): SqlHandler
Parameters
- value: number
Returns SqlHandler
- Defined in core/sql-handler.ts:219

greaterThanOrEqual

greaterThanOrEqual(value: StringOrNumber): SqlHandler
Parameters
- value: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:241

gt

gt(value: number): SqlHandler
same as greaterThan
Parameters
- value: number
Returns SqlHandler
- Defined in core/sql-handler.ts:226

gte

gte(value: StringOrNumber): SqlHandler
Parameters
- value: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:245

in

in(values: StringOrNumber[]): SqlHandler
Parameters
- values: StringOrNumber[]
Returns SqlHandler
- Defined in core/sql-handler.ts:192

innerJoin

innerJoin(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:286

insertInto

insertInto<T>(options: InsertOpts<T>): SqlHandler
Type Parameters
Type Parameters
- T = object
Parameters
- options: InsertOpts<T>
Returns SqlHandler
- Defined in core/sql-handler.ts:117

isEqual

isEqual(table: string, column: string): SqlHandler
Parameters
- table: string
- column: string
Returns SqlHandler
- Defined in core/sql-handler.ts:187

isNotNull

isNotNull(): SqlHandler
Returns SqlHandler
- Defined in core/sql-handler.ts:210

isNull

isNull(): SqlHandler
Returns SqlHandler
- Defined in core/sql-handler.ts:214

leftOuterJoin

leftOuterJoin(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:291

lessThan

lessThan(value: number): SqlHandler
Parameters
- value: number
Returns SqlHandler
- Defined in core/sql-handler.ts:230

lessThanOrEqual

lessThanOrEqual(value: StringOrNumber): SqlHandler
Parameters
- value: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:234

like

like(pattern: string): SqlHandler
Parameters
- pattern: string
Returns SqlHandler
- Defined in core/sql-handler.ts:197

limit

limit(limit: number): SqlHandler
Parameters
- limit: number
  
  specifying the max records.
Returns SqlHandler
- Defined in core/sql-handler.ts:63

lt

lt(value: number): SqlHandler
same as lessThan
Parameters
- value: number
Returns SqlHandler
- Defined in core/sql-handler.ts:252

lte

lte(value: StringOrNumber): SqlHandler
Parameters
- value: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:238

offset

offset(offset: number): SqlHandler
Parameters
- offset: number
  
  the number of rows to skip.
Returns SqlHandler
- Defined in core/sql-handler.ts:72

offsetRows

offsetRows(offset: number): SqlHandler
Parameters
- offset: number
  
  the number of rows to skip.
Returns SqlHandler
- Defined in core/sql-handler.ts:79

on

on(table: string, column: string): SqlHandler
Parameters
- table: string
- column: string
Returns SqlHandler
- Defined in core/sql-handler.ts:205

or

or(condition: StringOrNumber): SqlHandler
Parameters
- condition: StringOrNumber
Returns SqlHandler
- Defined in core/sql-handler.ts:268

order

order(order: Order): SqlHandler
Parameters
- order: Order
Returns SqlHandler
- Defined in core/sql-handler.ts:102

orderBy

orderBy(columns: string[]): SqlHandler
Parameters
- columns: string[]
Returns SqlHandler
- Defined in core/sql-handler.ts:95

rightOuterJoin

rightOuterJoin(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:297

select

select(columns: string[], distinct?: boolean): SqlHandler
Parameters
- columns: string[]
  
  an array of column names.
- distinct: boolean = false
  
  whether to include 'DISTINCT' keyword, default is false.
Returns SqlHandler
- Defined in core/sql-handler.ts:17

selectAvg

selectAvg(column: string): SqlHandler
Parameters
- column: string
Returns SqlHandler
- Defined in core/sql-handler.ts:32

selectCount

selectCount(column: string): SqlHandler
Parameters
- column: string
Returns SqlHandler
- Defined in core/sql-handler.ts:24

selectSum

selectSum(column: string): SqlHandler
Parameters
- column: string
Returns SqlHandler
- Defined in core/sql-handler.ts:40

set

set<T>(records: T[]): SqlHandler
Type Parameters
Type Parameters
- T = object
Parameters
- records: T[]
Returns SqlHandler
- Defined in core/sql-handler.ts:146

update

update(schema: string, table: string): SqlHandler
Parameters
- schema: string
- table: string
Returns SqlHandler
- Defined in core/sql-handler.ts:112

where

where(condition: string): SqlHandler
Parameters
- condition: string
Returns SqlHandler
- Defined in core/sql-handler.ts:164

whereNot

whereNot(condition: string): SqlHandler
Parameters
- condition: string
Returns SqlHandler
- Defined in core/sql-handler.ts:173