jsonInsert() — drizzle-orm Function Reference

Architecture documentation for the jsonInsert() function in index.ts from the drizzle-orm codebase.

Function typescript DrizzleORM QueryBuilders calls 1 called by 1

Entity Profile

DrizzleORM→ QueryBuilders→ jsonInsert() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  aae50675_4d97_3be7_7187_ecb1ba3ff4e0["jsonInsert()"]
  6cb45eda_1631_75ee_ac78_b494a5539774["MyDurableObject"]
  aae50675_4d97_3be7_7187_ecb1ba3ff4e0 -->|defined in| 6cb45eda_1631_75ee_ac78_b494a5539774
  1428f97b_b1ee_5af6_bf50_3d68d3f0ff2b["default.fetch()"]
  1428f97b_b1ee_5af6_bf50_3d68d3f0ff2b -->|calls| aae50675_4d97_3be7_7187_ecb1ba3ff4e0
  ffb57055_8b65_a390_e35a_0aaa90745e0c["beforeEach()"]
  aae50675_4d97_3be7_7187_ecb1ba3ff4e0 -->|calls| ffb57055_8b65_a390_e35a_0aaa90745e0c
  style aae50675_4d97_3be7_7187_ecb1ba3ff4e0 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 824–845

	async jsonInsert(): Promise<void> {
		try {
			await this.beforeEach();
			this.db
				.insert(usersTable)
				.values({ name: 'John', json: ['foo', 'bar'] })
				.run();
			const result = this.db
				.select({
					id: usersTable.id,
					name: usersTable.name,
					json: usersTable.json,
				})
				.from(usersTable)
				.all();

			expect(result).deep.equal([{ id: 1, name: 'John', json: ['foo', 'bar'] }]);
		} catch (error: any) {
			console.error(error);
			throw new Error(`jsonInsert error`);
		}
	}