Skip to content

@tsdrivers/mssql / PoolBulkInsertBuilder

Class: PoolBulkInsertBuilder ​

Defined in: projects/ts-mssql/core/pool.ts:268

Bulk insert builder that acquires a pool connection on execute.

Constructors ​

Constructor ​

new PoolBulkInsertBuilder(table, pool): PoolBulkInsertBuilder

Defined in: projects/ts-mssql/core/pool.ts:275

Parameters ​

table ​

string

pool ​

MssqlPool

Returns ​

PoolBulkInsertBuilder

Methods ​

batchSize() ​

batchSize(size): this

Defined in: projects/ts-mssql/core/pool.ts:313

Parameters ​

size ​

number

Returns ​

this


columns() ​

columns(cols): this

Defined in: projects/ts-mssql/core/pool.ts:280

Parameters ​

cols ​

BulkColumn[]

Returns ​

this


execute() ​

execute(): Promise<number>

Defined in: projects/ts-mssql/core/pool.ts:318

Returns ​

Promise<number>


fromAsyncIterable() ​

fromAsyncIterable<T>(source, transform): Promise<PoolBulkInsertBuilder>

Defined in: projects/ts-mssql/core/pool.ts:303

Type Parameters ​

T ​

T

Parameters ​

source ​

AsyncIterable<T>

transform ​

(item) => ParamValue[]

Returns ​

Promise<PoolBulkInsertBuilder>


fromObjects() ​

fromObjects(objects): this

Defined in: projects/ts-mssql/core/pool.ts:290

Parameters ​

objects ​

Record<string, ParamValue>[]

Returns ​

this


rows() ​

rows(rows): this

Defined in: projects/ts-mssql/core/pool.ts:285

Parameters ​

rows ​

ParamValue[][]

Returns ​

this