setOperationsUnionAllFromQueryBuilder() — drizzle-orm Function Reference

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 2729–2765

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

			const result = this.db
				.select({ id: citiesTable.id, name: citiesTable.name })
				.from(citiesTable)
				.unionAll(this.db.select({ id: citiesTable.id, name: citiesTable.name }).from(citiesTable))
				.orderBy(asc(citiesTable.id))
				.limit(5)
				.offset(1).all();

			expect(result).length(5);

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

			expect(() => {
				this.db
					.select({ id: citiesTable.id, name: citiesTable.name })
					.from(citiesTable).unionAll(
						this.db
							.select({ name: citiesTable.name, id: citiesTable.id })
							.from(citiesTable),
					).orderBy(asc(citiesTable.id)).limit(5).offset(1).run();
			}).throw();
		} catch (error: any) {
			console.error(error);
			throw new Error(`setOperationsUnionAllFromQueryBuilder error`);
		}
	}