18 releases

Uses old Rust 2015

0.9.4 Mar 9, 2023
0.9.3 Oct 22, 2021
0.9.2 Sep 22, 2021
0.9.1 Nov 16, 2016
0.4.2 Mar 24, 2016

#158 in Database interfaces

Download history 48/week @ 2023-02-01 66/week @ 2023-02-08 71/week @ 2023-02-15 32/week @ 2023-02-22 19/week @ 2023-03-01 46/week @ 2023-03-08 9/week @ 2023-03-15 31/week @ 2023-03-22 40/week @ 2023-03-29 10/week @ 2023-04-05 12/week @ 2023-04-12 21/week @ 2023-04-19 20/week @ 2023-04-26 28/week @ 2023-05-03 25/week @ 2023-05-10 8/week @ 2023-05-17

82 downloads per month

MIT/Apache

96KB
2.5K SLoC

SQL lexer

Build Status Crate

Rust library to lex and sanitize SQL. To lex a query and write back to a string:

extern crate sql_lexer;

fn main() {
  let sql = sql_lexer::lex("SELECT * FROM `table`".to_string()).lex();
  println!("{}", sql_lexer::write(sql));
}

To sanitize all content from a query so you just get the generic components:

extern crate sql_lexer;

fn main() {
  println!("{}", sql_lexer::sanitize_string("SELECT * FROM `table` WHERE id = 1".to_string()));
}

This will output:

SELECT * FROM `table` WHERE id = ?

The documentation is available here.

Command line

There's a utility included to sanitize a sql query in a file to facilitate testing:

cargo run -- <path-to-file>

License

Licensed under either of

at your option.

Contribution

Contributions are very welcome. Please make sure that you add a test for any use case you want to add.

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.

No runtime deps