Class PostgresDeleteBuilder

Hierarchy (View Summary)

PostgresDeleteBuilder
- MySqlDeleteBuilder

Index

Constructors

Methods

where andWhere orWhere returning toSQL run runAsync allReturning firstReturning allReturningAsync firstReturningAsync

Constructors

constructor

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

Methods

where

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

andWhere

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

orWhere

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

returning

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

toSQL

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

run

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

runAsync

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

allReturning

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

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:1900

allReturningAsync

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

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:1909