getAlterTableQueries() — astro Function Reference

Architecture documentation for the getAlterTableQueries() function in migration-queries.ts from the astro codebase.

Function typescript CoreAstro CoreMiddleware called by 1

Entity Profile

CoreAstro→ CoreMiddleware→ getAlterTableQueries() — astro Function Reference

Dependency Diagram

graph TD
  655b1226_3b31_6e67_5211_7e7cd4c505e3["getAlterTableQueries()"]
  d1459290_7e42_1f92_05bd_dcc3aeda9fd3["migration-queries.ts"]
  655b1226_3b31_6e67_5211_7e7cd4c505e3 -->|defined in| d1459290_7e42_1f92_05bd_dcc3aeda9fd3
  d8e591b7_f3dd_5f49_beb9_c9047d4d1e02["getTableChangeQueries()"]
  d8e591b7_f3dd_5f49_beb9_c9047d4d1e02 -->|calls| 655b1226_3b31_6e67_5211_7e7cd4c505e3
  style 655b1226_3b31_6e67_5211_7e7cd4c505e3 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

packages/db/src/core/cli/migration-queries.ts lines 230–255

function getAlterTableQueries(
	unescTableName: string,
	added: DBColumns,
	dropped: DBColumns,
): string[] {
	const queries: string[] = [];
	const tableName = sqlite.escapeName(unescTableName);

	for (const [unescColumnName, column] of Object.entries(added)) {
		const columnName = sqlite.escapeName(unescColumnName);
		const type = schemaTypeToSqlType(column.type);
		const q = `ALTER TABLE ${tableName} ADD COLUMN ${columnName} ${type}${getModifiers(
			columnName,
			column,
		)}`;
		queries.push(q);
	}

	for (const unescColumnName of Object.keys(dropped)) {
		const columnName = sqlite.escapeName(unescColumnName);
		const q = `ALTER TABLE ${tableName} DROP COLUMN ${columnName}`;
		queries.push(q);
	}

	return queries;
}