sql-cli 1.72.0

SQL query tool for CSV/JSON with both interactive TUI and non-interactive CLI modes - perfect for exploration and automation
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

// Helper functions extracted from enhanced_tui.rs
// These are pure functions with no dependencies on self

/// Sanitize table name by removing special characters and limiting length
#[must_use]
pub fn sanitize_table_name(name: &str) -> String {
    // Replace spaces and other problematic characters with underscores
    // to create SQL-friendly table names
    // Examples: "Business Crime Borough Level" -> "Business_Crime_Borough_Level"
    let sanitized: String = name
        .trim()
        .chars()
        .map(|c| {
            if c.is_alphanumeric() || c == '_' {
                c
            } else {
                '_'
            }
        })
        .collect();

    // If the sanitized name is too complex (too long or has too many underscores),
    // fall back to a simple default name
    const MAX_LENGTH: usize = 30;
    const MAX_UNDERSCORES: usize = 5;

    let underscore_count = sanitized.chars().filter(|&c| c == '_').count();

    if sanitized.len() > MAX_LENGTH || underscore_count > MAX_UNDERSCORES {
        // Use a simple fallback name
        "data".to_string()
    } else if sanitized.is_empty() || sanitized.chars().all(|c| c == '_') {
        // If the name is empty or all underscores after sanitization
        "data".to_string()
    } else {
        sanitized
    }
}