createSetOperator() — drizzle-orm Function Reference

Architecture documentation for the createSetOperator() function in select.ts from the drizzle-orm codebase.

Function typescript DrizzleORM QueryBuilders

Entity Profile

DrizzleORM→ QueryBuilders→ createSetOperator() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  465f83df_3534_e7fb_800e_bab611533771["createSetOperator()"]
  49cf912b_062f_f482_ab61_a2b8c881ec4d["select.ts"]
  465f83df_3534_e7fb_800e_bab611533771 -->|defined in| 49cf912b_062f_f482_ab61_a2b8c881ec4d
  style 465f83df_3534_e7fb_800e_bab611533771 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/sqlite-core/query-builders/select.ts lines 968–986

function createSetOperator(type: SetOperator, isAll: boolean): SQLiteCreateSetOperatorFn {
	return (leftSelect, rightSelect, ...restSelects) => {
		const setOperators = [rightSelect, ...restSelects].map((select) => ({
			type,
			isAll,
			rightSelect: select as AnySQLiteSelect,
		}));

		for (const setOperator of setOperators) {
			if (!haveSameKeys((leftSelect as any).getSelectedFields(), setOperator.rightSelect.getSelectedFields())) {
				throw new Error(
					'Set operator error (union / intersect / except): selected fields are not the same or are in a different order',
				);
			}
		}

		return (leftSelect as AnySQLiteSelect).addSetOperators(setOperators) as any;
	};
}