setOperationsIntersectFromQueryBuilder() — drizzle-orm Function Reference

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 2805–2838

	async setOperationsIntersectFromQueryBuilder(): Promise<void> {
		try {
			await this.beforeEach();
			await setupSetOperationTest(this.db);

			const result = this.db
				.select({ id: citiesTable.id, name: citiesTable.name })
				.from(citiesTable)
				.intersect(
					this.db.select({ id: citiesTable.id, name: citiesTable.name }).from(citiesTable).where(gt(citiesTable.id, 1)),
				)
				.orderBy(asc(sql`name`)).all();

			expect(result).length(2);

			expect(result).deep.equal([
				{ id: 2, name: 'London' },
				{ id: 3, name: 'Tampa' },
			]);

			expect(() => {
				this.db
					.select({ name: citiesTable.name, id: citiesTable.id })
					.from(citiesTable).intersect(
						this.db
							.select({ id: citiesTable.id, name: citiesTable.name })
							.from(citiesTable).where(gt(citiesTable.id, 1)),
					).orderBy(asc(sql`name`)).run();
			}).throw();
		} catch (error: any) {
			console.error(error);
			throw new Error(`setOperationsIntersectFromQueryBuilder error`);
		}
	}