getCreateIndexQueries() — astro Function Reference

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

Function typescript CoreAstro CoreMiddleware calls 1

Entity Profile

CoreAstro→ CoreMiddleware→ getCreateIndexQueries() — astro Function Reference

Dependency Diagram

graph TD
  2533a6b6_cf6e_b7b3_5729_79d99c5ff5a9["getCreateIndexQueries()"]
  ad642171_aa4f_abf2_da4d_c5b2e217a132["queries.ts"]
  2533a6b6_cf6e_b7b3_5729_79d99c5ff5a9 -->|defined in| ad642171_aa4f_abf2_da4d_c5b2e217a132
  9f3cbb71_dd98_b8a0_1397_58e6f2abb8fc["asArray()"]
  2533a6b6_cf6e_b7b3_5729_79d99c5ff5a9 -->|calls| 9f3cbb71_dd98_b8a0_1397_58e6f2abb8fc
  style 2533a6b6_cf6e_b7b3_5729_79d99c5ff5a9 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

packages/db/src/core/queries.ts lines 54–67

export function getCreateIndexQueries(tableName: string, table: Pick<DBTable, 'indexes'>) {
	let queries: string[] = [];
	for (const [indexName, indexProps] of Object.entries(table.indexes ?? {})) {
		const onColNames = asArray(indexProps.on);
		const onCols = onColNames.map((colName) => sqlite.escapeName(colName));

		const unique = indexProps.unique ? 'UNIQUE ' : '';
		const indexQuery = `CREATE ${unique}INDEX ${sqlite.escapeName(
			indexName,
		)} ON ${sqlite.escapeName(tableName)} (${onCols.join(', ')})`;
		queries.push(indexQuery);
	}
	return queries;
}