sql-cli 1.31.0

Powerful CSV/JSON TUI with advanced SQL engine - vim-inspired terminal interface for data exploration
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

#!/usr/bin/expect -f

# Test search navigation with interactive search

set timeout 5
set csv_file "test_search_nav.csv"

# Create test data
exec cat > $csv_file << CSV
id,book,product
1,Fixed Income,Corporate
2,Commodities,Energy
3,Equities,Tech
4,Forex,EUR/USD
5,Derivatives,Options
6,Fixed Income,emerging
7,Commodities,Gold
8,Fixed Income,emerging
9,Equities,emerging
CSV

# Run the TUI with logging
spawn env RUST_LOG=sql_cli::ui::table_widget_manager=info,search=info ./sql-cli/target/release/sql-cli test_search_nav.csv -e "select * from data"

# Wait for initial load
expect {
    "INFO" { }
    timeout { puts "Timeout waiting for initial load"; exit 1 }
}

# Give it time to render
sleep 0.5

# Enter search mode
send "/"
sleep 0.2

# Type search pattern
send "emerging"
sleep 0.5

# Submit search (Enter)
send "\r"
sleep 0.5

# Take a screenshot equivalent - send q to quit
send "q"
sleep 0.2

expect eof

# Clean up
exec rm -f $csv_file