Class SqliteInsertBuilder

Index

Constructors

Methods

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

Constructors

constructor

new SqliteInsertBuilder(
connection: Database,
table: string,
): SqliteInsertBuilder
Parameters
- connection: Database
- table: string
Returns SqliteInsertBuilder
- Defined in query-builder/query-builder.ts:2299

Methods

values

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

value

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

orIgnore

orIgnore(): this
Returns this
- Defined in query-builder/query-builder.ts:2333

orReplace

orReplace(): this
Returns this
- Defined in query-builder/query-builder.ts:2338

onConflict

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

doNothing

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

doUpdateFromExcluded

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

conflictWhere

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

returning

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

toSQL

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

run

run(): QueryRunResult
Returns QueryRunResult
- Defined in query-builder/query-builder.ts:2476

runAsync

runAsync(): Promise<QueryRunResult>
Returns Promise<QueryRunResult>
- Defined in query-builder/query-builder.ts:2489

allReturning

allReturning<TRow extends Record<string, unknown> = Record<string, unknown>>(): TRow[]
Type Parameters
- TRow extends Record<string, unknown> = Record<string, unknown>
Returns TRow[]
- Defined in query-builder/query-builder.ts:2493

firstReturning

firstReturning<TRow extends Record<string, unknown> = Record<string, unknown>>():
| TRow
| undefined
Type Parameters
- TRow extends Record<string, unknown> = Record<string, unknown>
Returns TRow | undefined
- Defined in query-builder/query-builder.ts:2502

allReturningAsync

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

firstReturningAsync

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