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

#!/usr/bin/expect -f

set timeout 5
spawn ./target/release/sql-cli test_fuzzy_clear.csv -e "select * from data"

# Wait for initial load - should show 10 rows
expect {
    "Rows: 10" { puts "✓ Initial load shows 10 rows" }
    timeout { puts "✗ Failed to see initial 10 rows"; exit 1 }
}

# Enter fuzzy filter mode
send "F"
expect {
    "Fuzzy Filter:" { puts "✓ Entered fuzzy filter mode" }
    timeout { puts "✗ Failed to enter fuzzy filter mode"; exit 1 }
}

# Type "rejected" to filter
send "rejected"
sleep 0.5

# Apply the filter
send "\r"
expect {
    "Rows: 3" { puts "✓ Filter applied, showing 3 rows" }
    timeout { puts "✗ Failed to filter to 3 rows"; exit 1 }
}

# Re-enter fuzzy filter mode
send "F"
expect {
    "Fuzzy Filter:" { puts "✓ Re-entered fuzzy filter mode" }
    timeout { puts "✗ Failed to re-enter fuzzy filter mode"; exit 1 }
}

# Press Enter with empty input to clear filter
send "\r"
expect {
    "Rows: 10" { 
        puts "✓ Empty filter cleared - showing all 10 rows again"
        puts "\n✅ TEST PASSED: Empty fuzzy filter correctly clears and shows all rows"
    }
    "Rows: 3" { 
        puts "✗ BUG STILL EXISTS: Still showing 3 filtered rows"
        exit 1
    }
    timeout { 
        puts "✗ Failed to verify row count after clearing filter"
        exit 1
    }
}

# Exit cleanly
send "q"
expect eof