Function mapSQLTypeToGenericType

src/lib/data/sql-import/common.ts:345–421

(
    sqlType: string,
    databaseType?: DatabaseType
)

// Map SQL data type to generic data type in our system
export function mapSQLTypeToGenericType(
    sqlType: string,
    databaseType?: DatabaseType
): DataType {
    if (!sqlType) {
        return genericDataTypes.find((t) => t.id === 'text')!;
    }

    // Normalize the SQL type to lowercase for consistency
    const normalizedSqlType = sqlType.toLowerCase();

    // Add special case handling for SQLite INTEGER type
    if (
        databaseType === DatabaseType.SQLITE &&
        (normalizedSqlType === 'integer' || normalizedSqlType === 'int')
    ) {
        return genericDataTypes.find((t) => t.id === 'integer')!;
    }

    // Get dialect-specific type mappings
    const dialectAffinity =
        (databaseType && typeAffinity[databaseType]) ||
        typeAffinity[DatabaseType.GENERIC];

    // Handle specific database dialect mappings
    if (databaseType) {
        // Try to find a mapping for the normalized type
        const typeMapping = dialectAffinity[normalizedSqlType];
        if (typeMapping) {
            const foundType = genericDataTypes.find(
                (t) => t.id === typeMapping
            );
            if (foundType) return foundType;
        }
    }

    // Try direct mapping by normalizing the input type
    const normalizedType = normalizedSqlType.replace(/\(.*\)/, '');
    const matchedType = genericDataTypes.find((t) => t.id === normalizedType);
    if (matchedType) return matchedType;

    // Generic type mappings as a fallback
    const typeMap: Record<string, string> = {
        int: 'integer',
        integer: 'integer',
        smallint: 'smallint',
        bigint: 'bigint',
        decimal: 'decimal',
        numeric: 'numeric',
        float: 'float',
        double: 'double',
        varchar: 'varchar',
        'character varying': 'varchar',
        char: 'char',
        character: 'char',
        text: 'text',
        boolean: 'boolean',
        bool: 'boolean',