Class PostgresUpdateBuilder

Hierarchy (View Summary)

PostgresUpdateBuilder
- MySqlUpdateBuilder

Index

Constructors

Methods

set where andWhere orWhere returning toSQL run runAsync allReturning firstReturning allReturningAsync firstReturningAsync

Constructors

constructor

new PostgresUpdateBuilder(
connection: PostgresQueryConnection,
table: string,
): PostgresUpdateBuilder
Parameters
- connection: PostgresQueryConnection
- table: string
Returns PostgresUpdateBuilder
- Defined in query-builder/query-builder.ts:1677

Methods

set

set(values: QuerySetValues): this
Parameters
- values: QuerySetValues
Returns this
- Defined in query-builder/query-builder.ts:1684

where

where(condition: string, ...params: QueryValue[]): this
Parameters
- condition: string
- ...params: QueryValue[]
Returns this
- Defined in query-builder/query-builder.ts:1698

andWhere

andWhere(condition: string, ...params: QueryValue[]): this
Parameters
- condition: string
- ...params: QueryValue[]
Returns this
- Defined in query-builder/query-builder.ts:1712

orWhere

orWhere(condition: string, ...params: QueryValue[]): this
Parameters
- condition: string
- ...params: QueryValue[]
Returns this
- Defined in query-builder/query-builder.ts:1716

returning

returning(columns?: SelectColumns): this
Parameters
- columns: SelectColumns = "*"
Returns this
- Defined in query-builder/query-builder.ts:1730

toSQL

toSQL(): QueryBuildResult
Returns QueryBuildResult
- Defined in query-builder/query-builder.ts:1736

run

run(): Promise<{ rowCount: number }>
Returns Promise<{ rowCount: number }>
- Defined in query-builder/query-builder.ts:1766

runAsync

runAsync(): Promise<{ rowCount: number }>
Returns Promise<{ rowCount: number }>
- Defined in query-builder/query-builder.ts:1778

allReturning

allReturning<TRow extends QueryResultRow = QueryResultRow>(): Promise<TRow[]>
Type Parameters
- TRow extends QueryResultRow = QueryResultRow
Returns Promise<TRow[]>
- Defined in query-builder/query-builder.ts:1782

firstReturning

firstReturning<TRow extends QueryResultRow = QueryResultRow>(): Promise<
TRow
| undefined,
>
Type Parameters
- TRow extends QueryResultRow = QueryResultRow
Returns Promise<TRow | undefined>
- Defined in query-builder/query-builder.ts:1792

allReturningAsync

allReturningAsync<TRow extends QueryResultRow = QueryResultRow>(): Promise<
TRow[],
>
Type Parameters
- TRow extends QueryResultRow = QueryResultRow
Returns Promise<TRow[]>
- Defined in query-builder/query-builder.ts:1797

firstReturningAsync

firstReturningAsync<TRow extends QueryResultRow = QueryResultRow>(): Promise<
TRow
| undefined,
>
Type Parameters
- TRow extends QueryResultRow = QueryResultRow
Returns Promise<TRow | undefined>
- Defined in query-builder/query-builder.ts:1801