SelectBuilder | @the-gear/pg-query-builder

Hierarchy

SelectBuilder

Index

Constructors

constructor

Properties

Methods

Constructors

constructor

new SelectBuilder(tableSource?: SqlFragment | null): SelectBuilder

- Defined in pg-query-builder.ts:15
Parameters
- Default value tableSource: SqlFragment | null = null
Returns SelectBuilder

Properties

Private command

command: SqlFragment = "SELECT"

Private joins

joins: SqlFragment[] = []

Private limit

limit: number | null = null

Private orderColumns

orderColumns: SqlFragment[] = []

Private params

params: any[] = []

Private selection

selection: SqlFragment[] = []

Private tableSource

tableSource: SqlFragment | null

Private wheres

wheres: SqlFragment[] = []

Methods

createQuery

createQuery(): object

- Defined in pg-query-builder.ts:70
Returns object
- params: any[]
- query: string

from

from(tableSource: SqlFragment): this

- Defined in pg-query-builder.ts:31
Parameters
- tableSource: SqlFragment
Returns this

join

join(join: SqlFragment): this

- Defined in pg-query-builder.ts:36
Parameters
- join: SqlFragment
Returns this

orderBy

orderBy(...orderColumns: SqlFragment[]): this

- Defined in pg-query-builder.ts:65
Parameters
- Rest ...orderColumns: SqlFragment[]
Returns this

select

select(...columns: SqlFragment[]): this

- Defined in pg-query-builder.ts:26
Parameters
- Rest ...columns: SqlFragment[]
Returns this

setCommand

setCommand(command: SqlFragment): this

- Defined in pg-query-builder.ts:21
Parameters
- command: SqlFragment
Returns this

setLimit

setLimit(maxRows: number): this

- Defined in pg-query-builder.ts:60
Parameters
- maxRows: number
Returns this

where

where(condition: SqlFragment, ...params: any[]): this

- Defined in pg-query-builder.ts:41
Parameters
- condition: SqlFragment
- Rest ...params: any[]
Returns this

Generated using TypeDoc