Function createTablesFromMetadata

src/lib/data/import-metadata/import/tables.ts:42–258

({
    databaseMetadata,
    databaseType,
}: {
    databaseMetadata: DatabaseMetadata;
    databaseType: DatabaseType;
})

};

export const createTablesFromMetadata = ({
    databaseMetadata,
    databaseType,
}: {
    databaseMetadata: DatabaseMetadata;
    databaseType: DatabaseType;
}): DBTable[] => {
    const {
        tables: tableInfos,
        pk_info: primaryKeys,
        columns,
        indexes,
        views: views,
        check_constraints: checkConstraints,
    } = databaseMetadata;

    // Pre-compute view names for faster lookup if there are views
    const viewNamesSet = new Set<string>();
    const materializedViewNamesSet = new Set<string>();

    if (views && views.length > 0) {
        views.forEach((view) => {
            const key = generateTableKey({
                schemaName: view.schema,
                tableName: view.view_name,
            });
            viewNamesSet.add(key);

            if (
                view.view_definition &&
                decodeViewDefinition(databaseType, view.view_definition)
                    .toLowerCase()
                    .includes('materialized')
            ) {
                materializedViewNamesSet.add(key);
            }
        });
    }

    // Pre-compute lookup maps for better performance
    const columnsByTable = new Map<string, (typeof columns)[0][]>();
    const indexesByTable = new Map<string, (typeof indexes)[0][]>();
    const primaryKeysByTable = new Map<string, (typeof primaryKeys)[0][]>();

    // Group columns by table
    columns.forEach((col) => {
        const key = generateTableKey({
            schemaName: col.schema,
            tableName: col.table,
        });
        if (!columnsByTable.has(key)) {
            columnsByTable.set(key, []);
        }
        columnsByTable.get(key)!.push(col);
    });

    // Group indexes by table
    indexes.forEach((idx) => {