sql_lexer 0.9.9

Library to lex and sanitize SQL
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

fn long_insert_into_values_query(rows: usize) -> String {
    let mut query = r#"INSERT INTO "table_name" ("one","two","three") VALUES "#.to_owned();
    for i in 0..rows {
        query.push_str(&format!("({}, {}, {}),", i, i + 1, i + 2));
    }
    query.push_str("(0, 0, 0);");
    query
}

extern crate sql_lexer;

fn main() {
    for rows in [200, 2000, 20000] {
        println!("Sanitising long_insert_into_values_query with {rows} rows");
        let query = long_insert_into_values_query(rows);
        let start = std::time::Instant::now();
        let output = sql_lexer::sanitize_string(query);
        let elapsed = start.elapsed();
        println!("Output: {}", output);
        println!("Elapsed: {:?}", elapsed);
    }
}