drizzle-orm Architecture Docs
Home / File/ set-operators.ts — drizzle-orm Source File

set-operators.ts — drizzle-orm Source File

Architecture documentation for set-operators.ts, a typescript file in the drizzle-orm codebase. 9 imports, 0 dependents.

File typescript DrizzleORM DatabaseDrivers 9 imports 2 functions

Entity Profile

Dependency Diagram

graph LR
  6d5bdc53_9ccf_5949_51a4_d37a063b2043["set-operators.ts"]
  554a7c60_d7ae_c68e_f0c9_e3a02afcefb7["db.ts"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 554a7c60_d7ae_c68e_f0c9_e3a02afcefb7
  998b0a13_62af_9408_d100_2bb61b49b6b9["tables.ts"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 998b0a13_62af_9408_d100_2bb61b49b6b9
  d5069778_165e_a727_2a3f_ca5ade9bb1ab["cities"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> d5069778_165e_a727_2a3f_ca5ade9bb1ab
  8f5b95aa_c510_2285_0148_0dba2a518366["newYorkers"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 8f5b95aa_c510_2285_0148_0dba2a518366
  4d7e77e2_6504_f5a5_4a03_156acfe671d4["users"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 4d7e77e2_6504_f5a5_4a03_156acfe671d4
  25b05299_f48f_bceb_01ca_1343d330a8f7["utils.ts"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 25b05299_f48f_bceb_01ca_1343d330a8f7
  fa14e9c0_b73d_4bcb_463b_adf18df8a285["index.ts"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> fa14e9c0_b73d_4bcb_463b_adf18df8a285
  5c46beaf_8b59_d2e3_def3_8af6daf1fccd["index.ts"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 5c46beaf_8b59_d2e3_def3_8af6daf1fccd
  944a2bed_8787_5f43_03e5_9a3b696c293c["index.ts"]
  6d5bdc53_9ccf_5949_51a4_d37a063b2043 --> 944a2bed_8787_5f43_03e5_9a3b696c293c
  style 6d5bdc53_9ccf_5949_51a4_d37a063b2043 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { type Equal, Expect } from 'type-tests/utils.ts';
import { except, exceptAll, intersect, intersectAll, type PgSetOperator, union, unionAll } from '~/pg-core/index.ts';
import { eq } from '~/sql/expressions/index.ts';
import { desc, sql } from '~/sql/index.ts';
import { db } from './db.ts';
import { cities, classes, newYorkers, users } from './tables.ts';

const unionTest = await db
	.select({ id: users.id })
	.from(users)
	.union(
		db
			.select({ id: users.id })
			.from(users),
	);

Expect<Equal<{ id: number }[], typeof unionTest>>;

const unionAllTest = await db
	.select({ id: users.id, age: users.age1 })
	.from(users)
	.unionAll(
		db.select({ id: users.id, age: users.age1 })
			.from(users)
			.leftJoin(cities, eq(users.id, cities.id)),
	);

Expect<Equal<{ id: number; age: number }[], typeof unionAllTest>>;

const intersectTest = await db
	.select({ id: users.id, homeCity: users.homeCity })
	.from(users)
	.intersect(({ intersect }) =>
		intersect(
			db
				.select({ id: users.id, homeCity: users.homeCity })
				.from(users),
			db
				.select({ id: users.id, homeCity: sql`${users.homeCity}`.mapWith(Number) })
				.from(users),
		)
	);

Expect<Equal<{ id: number; homeCity: number }[], typeof intersectTest>>;

const intersectAllTest = await db
	.select({ id: users.id, homeCity: users.class })
	.from(users)
	.intersect(
		db
			.select({ id: users.id, homeCity: users.class })
			.from(users)
			.leftJoin(cities, eq(users.id, cities.id)),
	);

Expect<Equal<{ id: number; homeCity: 'A' | 'C' }[], typeof intersectAllTest>>;

const exceptTest = await db
	.select({ id: users.id, homeCity: users.homeCity })
	.from(users)
// ... (221 more lines)

Domain

Subdomains

Functions

Dependencies

Source

Frequently Asked Questions

What does set-operators.ts do?
set-operators.ts is a source file in the drizzle-orm codebase, written in typescript. It belongs to the DrizzleORM domain, DatabaseDrivers subdomain.
What functions are defined in set-operators.ts?
set-operators.ts defines 2 function(s): dynamic, intersectTest.
What does set-operators.ts depend on?
set-operators.ts imports 9 module(s): cities, db.ts, index.ts, index.ts, index.ts, newYorkers, tables.ts, users, and 1 more.
Where is set-operators.ts in the architecture?
set-operators.ts is located at drizzle-orm/type-tests/pg/set-operators.ts (domain: DrizzleORM, subdomain: DatabaseDrivers, directory: drizzle-orm/type-tests/pg).

Analyze Your Own Codebase

Get architecture documentation, dependency graphs, and domain analysis for your codebase in minutes.

Try Supermodel Free