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

use sql_cli::history::CommandHistory;

fn main() {
    println!("Testing history functionality...");
    
    match CommandHistory::new() {
        Ok(mut history) => {
            println!("✓ CommandHistory created successfully");
            
            // Check existing entries
            let all_entries = history.get_all();
            println!("Found {} existing history entries", all_entries.len());
            
            // Try adding a new entry
            if let Err(e) = history.add_entry("SELECT * FROM test".to_string(), true, Some(100)) {
                println!("✗ Failed to add entry: {}", e);
            } else {
                println!("✓ Successfully added test entry");
            }
            
            // Check if it was added
            let new_count = history.get_all().len();
            println!("History now has {} entries", new_count);
            
            // Test search
            let matches = history.search("SELECT");
            println!("Found {} matches for 'SELECT'", matches.len());
            
            // Show first few entries
            for (i, entry) in history.get_all().iter().take(5).enumerate() {
                println!("  [{}] {}", i, entry.command);
            }
        }
        Err(e) => {
            println!("✗ Failed to create CommandHistory: {}", e);
        }
    }
}