sql-cli 1.73.1

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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76

use sql_cli::data::csv_datasource::CsvDataSource;
use sql_cli::data::datatable::DataValue;
use std::env;
use std::path::PathBuf;

#[test]
fn test_null_vs_empty_string() {
    // Create a test CSV file
    let csv_content = r#"id,name,value,notes
1,Alice,,empty_field
2,Bob,"",quoted_empty
3,,100,null_name
4,"",200,quoted_empty_name
5,Charlie,,"double_null""#;

    // Use cross-platform temp directory
    let mut temp_path = env::temp_dir();
    temp_path.push("test_null_empty.csv");
    let temp_file = temp_path.to_str().unwrap();

    // Write to temp file
    std::fs::write(&temp_path, csv_content).unwrap();

    // Load the CSV
    let datasource = CsvDataSource::load_from_file(temp_file, "test").unwrap();

    // Convert to DataTable for easier testing
    let data_table = datasource.to_datatable();

    // Get the rows
    let rows = &data_table.rows;

    // Test row 1: Alice with unquoted empty value field -> should be NULL
    let row1 = &rows[0];
    assert_eq!(
        row1.values[2],
        DataValue::Null,
        "Row 1 value should be NULL (unquoted empty)"
    );

    // Test row 2: Bob with quoted empty name -> should be empty string
    let row2 = &rows[1];
    assert_eq!(row2.values[1], DataValue::String("Bob".to_string()));
    assert_eq!(
        row2.values[2],
        DataValue::String("".to_string()),
        "Row 2 value should be empty string (quoted empty)"
    );

    // Test row 3: unquoted empty name -> should be NULL
    let row3 = &rows[2];
    assert_eq!(
        row3.values[1],
        DataValue::Null,
        "Row 3 name should be NULL (unquoted empty)"
    );

    // Test row 4: quoted empty name -> should be empty string
    let row4 = &rows[3];
    assert_eq!(
        row4.values[1],
        DataValue::String("".to_string()),
        "Row 4 name should be empty string (quoted empty)"
    );

    // Test row 5: Charlie with unquoted empty value -> should be NULL
    let row5 = &rows[4];
    assert_eq!(
        row5.values[2],
        DataValue::Null,
        "Row 5 value should be NULL (unquoted empty)"
    );

    // Clean up
    std::fs::remove_file(&temp_path).ok();
}