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 SQLDialects 9 imports 2 functions

Entity Profile

Dependency Diagram

graph LR
  20d20271_669e_bb2d_537b_ef209a0ba63d["set-operators.ts"]
  9a56da77_7540_380c_f8b9_d8bde4914940["db.ts"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 9a56da77_7540_380c_f8b9_d8bde4914940
  87dcb46e_0d95_8341_e760_d59ef620c68d["tables.ts"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 87dcb46e_0d95_8341_e760_d59ef620c68d
  1f73ed82_3972_0f5c_0eb2_24d4fff59c90["cities"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 1f73ed82_3972_0f5c_0eb2_24d4fff59c90
  4ab9a9c4_1106_593b_a4df_f1f81ed18599["newYorkers"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 4ab9a9c4_1106_593b_a4df_f1f81ed18599
  05a4464c_b137_3d56_0f64_434dce6f7bad["users"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 05a4464c_b137_3d56_0f64_434dce6f7bad
  25b05299_f48f_bceb_01ca_1343d330a8f7["utils.ts"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 25b05299_f48f_bceb_01ca_1343d330a8f7
  5c46beaf_8b59_d2e3_def3_8af6daf1fccd["index.ts"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 5c46beaf_8b59_d2e3_def3_8af6daf1fccd
  944a2bed_8787_5f43_03e5_9a3b696c293c["index.ts"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> 944a2bed_8787_5f43_03e5_9a3b696c293c
  c9460fa2_b68e_584b_2be3_a4db38ea6f7c["index.ts"]
  20d20271_669e_bb2d_537b_ef209a0ba63d --> c9460fa2_b68e_584b_2be3_a4db38ea6f7c
  style 20d20271_669e_bb2d_537b_ef209a0ba63d fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { type Equal, Expect } from 'type-tests/utils.ts';
import { eq } from '~/sql/expressions/index.ts';
import { desc, sql } from '~/sql/index.ts';
import { except, intersect, type SQLiteSetOperator, union, unionAll } from '~/sqlite-core/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, text: users.name })
	.from(users)
	.unionAll(
		db.select({ id: users.id, text: users.name })
			.from(users)
			.leftJoin(cities, eq(users.id, cities.id)),
	);

Expect<Equal<{ id: number; text: string | null }[], 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)
// ... (219 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, SQLDialects 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/sqlite/set-operators.ts (domain: DrizzleORM, subdomain: SQLDialects, directory: drizzle-orm/type-tests/sqlite).

Analyze Your Own Codebase

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

Try Supermodel Free