drizzle-orm Architecture Docs
Home / Function/ buildUpdateQuery() — drizzle-orm Function Reference

buildUpdateQuery() — drizzle-orm Function Reference

Architecture documentation for the buildUpdateQuery() function in dialect.ts from the drizzle-orm codebase.

Function typescript DrizzleORM DatabaseDrivers calls 5

Entity Profile

Dependency Diagram

graph TD
  51652aaf_93cd_307b_be64_ec6b5cfd33e6["buildUpdateQuery()"]
  3977a3fd_2f08_73b1_4df4_3d0fd1858514["PgDialect"]
  51652aaf_93cd_307b_be64_ec6b5cfd33e6 -->|defined in| 3977a3fd_2f08_73b1_4df4_3d0fd1858514
  bcbd4f74_c6c7_2989_e283_a503bf2039fa["buildWithCTE()"]
  51652aaf_93cd_307b_be64_ec6b5cfd33e6 -->|calls| bcbd4f74_c6c7_2989_e283_a503bf2039fa
  a779c29a_e3fb_1425_428d_6ff1a9724427["buildUpdateSet()"]
  51652aaf_93cd_307b_be64_ec6b5cfd33e6 -->|calls| a779c29a_e3fb_1425_428d_6ff1a9724427
  a3d42ee8_7394_7230_8590_b17469f33bad["buildFromTable()"]
  51652aaf_93cd_307b_be64_ec6b5cfd33e6 -->|calls| a3d42ee8_7394_7230_8590_b17469f33bad
  b947243c_21ad_f757_2719_e0aeb7980c05["buildJoins()"]
  51652aaf_93cd_307b_be64_ec6b5cfd33e6 -->|calls| b947243c_21ad_f757_2719_e0aeb7980c05
  e700cd38_c0c8_fbeb_26a9_7fbf17216117["buildSelection()"]
  51652aaf_93cd_307b_be64_ec6b5cfd33e6 -->|calls| e700cd38_c0c8_fbeb_26a9_7fbf17216117
  style 51652aaf_93cd_307b_be64_ec6b5cfd33e6 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/pg-core/dialect.ts lines 174–198

	buildUpdateQuery({ table, set, where, returning, withList, from, joins }: PgUpdateConfig): SQL {
		const withSql = this.buildWithCTE(withList);

		const tableName = table[PgTable.Symbol.Name];
		const tableSchema = table[PgTable.Symbol.Schema];
		const origTableName = table[PgTable.Symbol.OriginalName];
		const alias = tableName === origTableName ? undefined : tableName;
		const tableSql = sql`${tableSchema ? sql`${sql.identifier(tableSchema)}.` : undefined}${
			sql.identifier(origTableName)
		}${alias && sql` ${sql.identifier(alias)}`}`;

		const setSql = this.buildUpdateSet(table, set);

		const fromSql = from && sql.join([sql.raw(' from '), this.buildFromTable(from)]);

		const joinsSql = this.buildJoins(joins);

		const returningSql = returning
			? sql` returning ${this.buildSelection(returning, { isSingleTable: !from })}`
			: undefined;

		const whereSql = where ? sql` where ${where}` : undefined;

		return sql`${withSql}update ${tableSql} set ${setSql}${fromSql}${joinsSql}${whereSql}${returningSql}`;
	}

Domain

Subdomains

Defined In

Calls

Source

Frequently Asked Questions

What does buildUpdateQuery() do?
buildUpdateQuery() is a function in the drizzle-orm codebase, defined in drizzle-orm/src/pg-core/dialect.ts.
Where is buildUpdateQuery() defined?
buildUpdateQuery() is defined in drizzle-orm/src/pg-core/dialect.ts at line 174.
What does buildUpdateQuery() call?
buildUpdateQuery() calls 5 function(s): buildFromTable, buildJoins, buildSelection, buildUpdateSet, buildWithCTE.

Analyze Your Own Codebase

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

Try Supermodel Free