Class PostgresInsertBuilder

Hierarchy (View Summary)

PostgresInsertBuilder
- MySqlInsertBuilder

Index

Constructors

Methods

values value onConflict doNothing doUpdateFromExcluded conflictWhere returning toSQL run runAsync allReturning firstReturning allReturningAsync firstReturningAsync

Constructors

constructor

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

Methods

values

values(value: QuerySetValues | QuerySetValues[]): this
Parameters
- value: QuerySetValues | QuerySetValues[]
Returns this
- Defined in query-builder/query-builder.ts:1472

value

value(value: QuerySetValues): this
Parameters
- value: QuerySetValues
Returns this
- Defined in query-builder/query-builder.ts:1495

onConflict

onConflict(columns?: string | string[]): this
Parameters
- Optionalcolumns: string | string[]
Returns this
- Defined in query-builder/query-builder.ts:1499

doNothing

doNothing(): this
Returns this
- Defined in query-builder/query-builder.ts:1523

doUpdateFromExcluded

doUpdateFromExcluded(columns: string | string[]): this
Parameters
- columns: string | string[]
Returns this
- Defined in query-builder/query-builder.ts:1537

conflictWhere

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

returning

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

toSQL

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

run

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

runAsync

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

allReturning

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

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

allReturningAsync

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

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