setOperationsUnionFromQueryBuilderWithSubquery() — drizzle-orm Function Reference

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 2653–2690

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

			const sq = this.db
				.select({ id: citiesTable.id, name: citiesTable.name })
				.from(citiesTable)
				.union(this.db.select({ id: users2Table.id, name: users2Table.name }).from(users2Table))
				.orderBy(asc(sql`name`))
				.as('sq');

			const result = await this.db.select().from(sq).limit(5).offset(5);

			expect(result).length(5);

			expect(result).deep.equal([
				{ id: 2, name: 'London' },
				{ id: 7, name: 'Mary' },
				{ id: 1, name: 'New York' },
				{ id: 4, name: 'Peter' },
				{ id: 8, name: 'Sally' },
			]);

			expect(() => {
				this.db
					.select({ name: citiesTable.name, id: citiesTable.id })
					.from(citiesTable).union(
						this.db
							.select({ id: users2Table.id, name: users2Table.name })
							.from(users2Table),
					).orderBy(asc(sql`name`)).all();
			}).throw();
		} catch (error: any) {
			console.error(error);
			throw new Error(`setOperationsUnionFromQueryBuilderWithSubquery error`);
		}
	}