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

use sql_cli::data::data_view::DataView;
use sql_cli::data::datatable::{DataColumn, DataRow, DataTable, 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 for row 0
    let row_indices = vec![0];

    let (headers, data, widths) = viewport.get_visual_display(100, &row_indices);

    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}");
            }
        }
    }
}