batch() — drizzle-orm Function Reference

Architecture documentation for the batch() function in session.ts from the drizzle-orm codebase.

Function typescript DrizzleORM SQLDialects calls 1

Entity Profile

DrizzleORM→ SQLDialects→ batch() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  cfd4dd2e_9055_cc46_2dd9_d7260b39e9f1["batch()"]
  8547eb9d_d783_00ed_fafd_5d4e77e8be54["SQLiteRemoteSession"]
  cfd4dd2e_9055_cc46_2dd9_d7260b39e9f1 -->|defined in| 8547eb9d_d783_00ed_fafd_5d4e77e8be54
  61b10eb0_70cd_a305_00c8_bd3f955929a3["getQuery()"]
  cfd4dd2e_9055_cc46_2dd9_d7260b39e9f1 -->|calls| 61b10eb0_70cd_a305_00c8_bd3f955929a3
  style cfd4dd2e_9055_cc46_2dd9_d7260b39e9f1 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/sqlite-proxy/session.ts lines 76–89

	async batch<T extends BatchItem<'sqlite'>[] | readonly BatchItem<'sqlite'>[]>(queries: T) {
		const preparedQueries: PreparedQuery[] = [];
		const builtQueries: { sql: string; params: any[]; method: 'run' | 'all' | 'values' | 'get' }[] = [];

		for (const query of queries) {
			const preparedQuery = query._prepare();
			const builtQuery = (preparedQuery as RemotePreparedQuery).getQuery();
			preparedQueries.push(preparedQuery);
			builtQueries.push({ sql: builtQuery.sql, params: builtQuery.params, method: builtQuery.method });
		}

		const batchResults = await (this.batchCLient as AsyncBatchRemoteCallback)(builtQueries);
		return batchResults.map((result, i) => preparedQueries[i]!.mapResult(result, true));
	}