insertWithOnConflictDoNothingUsingCompositePkAsTarget() — drizzle-orm Function Reference

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 2369–2391

	async insertWithOnConflictDoNothingUsingCompositePkAsTarget(): 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: 'john1@example.com' })
				.onConflictDoNothing({ target: [pkExampleTable.id, pkExampleTable.name] })
				.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: 'john@example.com' }]);
		} catch (error: any) {
			console.error(error);
			throw new Error(`insertWithOnConflictDoNothingUsingCompositePkAsTarget error`);
		}
	}