getCreateTableQuery() — astro Function Reference

Architecture documentation for the getCreateTableQuery() function in queries.ts from the astro codebase.

Function typescript CoreAstro CoreMiddleware calls 3

Entity Profile

CoreAstro→ CoreMiddleware→ getCreateTableQuery() — astro Function Reference

Dependency Diagram

graph TD
  2c5d4a4f_0281_5dcc_4f4b_c395276b2c64["getCreateTableQuery()"]
  ad642171_aa4f_abf2_da4d_c5b2e217a132["queries.ts"]
  2c5d4a4f_0281_5dcc_4f4b_c395276b2c64 -->|defined in| ad642171_aa4f_abf2_da4d_c5b2e217a132
  b0dfb0b2_023c_63a7_0aa6_f744f456b081["schemaTypeToSqlType()"]
  2c5d4a4f_0281_5dcc_4f4b_c395276b2c64 -->|calls| b0dfb0b2_023c_63a7_0aa6_f744f456b081
  8d1b704b_bb80_1aba_c294_631b6d77405c["getModifiers()"]
  2c5d4a4f_0281_5dcc_4f4b_c395276b2c64 -->|calls| 8d1b704b_bb80_1aba_c294_631b6d77405c
  5343da8f_869a_7aae_4608_c9250b0cad11["getCreateForeignKeyQueries()"]
  2c5d4a4f_0281_5dcc_4f4b_c395276b2c64 -->|calls| 5343da8f_869a_7aae_4608_c9250b0cad11
  style 2c5d4a4f_0281_5dcc_4f4b_c395276b2c64 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

packages/db/src/core/queries.ts lines 31–52

export function getCreateTableQuery(tableName: string, table: DBTable) {
	let query = `CREATE TABLE ${sqlite.escapeName(tableName)} (`;

	const colQueries = [];
	const colHasPrimaryKey = Object.entries(table.columns).find(([, column]) =>
		hasPrimaryKey(column),
	);
	if (!colHasPrimaryKey) {
		colQueries.push('_id INTEGER PRIMARY KEY');
	}
	for (const [columnName, column] of Object.entries(table.columns)) {
		const colQuery = `${sqlite.escapeName(columnName)} ${schemaTypeToSqlType(
			column.type,
		)}${getModifiers(columnName, column)}`;
		colQueries.push(colQuery);
	}

	colQueries.push(...getCreateForeignKeyQueries(tableName, table));

	query += colQueries.join(', ') + ')';
	return query;
}