insertWithOnConflictDoUpdateUsingCompositePk() — drizzle-orm Function Reference

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 2446–2468

	async insertWithOnConflictDoUpdateUsingCompositePk(): Promise<void> {
		try {
			await this.beforeEach();
			this.db.insert(pkExampleTable).values({ id: 1, name: 'John', email: 'john@example.com' }).run();

			this.db
				.insert(pkExampleTable)
				.values({ id: 1, name: 'John', email: 'john@example.com' })
				.onConflictDoUpdate({ target: [pkExampleTable.id, pkExampleTable.name], set: { email: 'john1@example.com' } })
				.run();

			const res = this.db
				.select({ id: pkExampleTable.id, name: pkExampleTable.name, email: pkExampleTable.email })
				.from(pkExampleTable)
				.where(eq(pkExampleTable.id, 1))
				.all();

			expect(res).deep.equal([{ id: 1, name: 'John', email: 'john1@example.com' }]);
		} catch (error: any) {
			console.error(error);
			throw new Error(`insertWithOnConflictDoUpdateUsingCompositePk error`);
		}
	}