sql-cli 1.71.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

use sql_cli::data::data_view::DataView;
use sql_cli::data::datatable::{DataTable, DataColumn, DataRow, DataValue};
use sql_cli::ui::viewport_manager::ViewportManager;
use std::sync::Arc;

fn main() {
    // Create a simple table
    let mut table = DataTable::new("test");
    table.add_column(DataColumn::new("Name"));
    table.add_column(DataColumn::new("Age"));
    table.add_column(DataColumn::new("City"));
    table.add_column(DataColumn::new("Comments"));
    table.add_column(DataColumn::new("Status"));
    
    table.add_row(DataRow::new(vec![
        DataValue::String("Alice".to_string()),
        DataValue::Integer(30),
        DataValue::String("NYC".to_string()),
        DataValue::String("Long comment".to_string()),
        DataValue::String("Active".to_string()),
    ])).unwrap();
    
    let mut dataview = DataView::new(Arc::new(table));
    
    // Hide the "Comments" column (index 3)
    println!("Before hiding: {} columns", dataview.column_count());
    dataview.hide_column(3);
    println!("After hiding: {} columns", dataview.column_count());
    
    // Create viewport
    let mut viewport = ViewportManager::new(Arc::new(dataview));
    
    // Get visual display
    let rows = vec![vec![
        "Alice".to_string(),
        "30".to_string(),
        "NYC".to_string(),
        "Long comment".to_string(),
        "Active".to_string(),
    ]];
    
    let (headers, data, widths) = viewport.get_visual_display(100, &rows);
    
    println!("\nHeaders: {:?}", headers);
    println!("Data: {:?}", data);
    println!("\nAlignment check:");
    for (i, header) in headers.iter().enumerate() {
        if let Some(row) = data.first() {
            if let Some(value) = row.get(i) {
                println!("  {} -> {}", header, value);
            }
        }
    }
}