Crates.io | sql_lexer |
lib.rs | sql_lexer |
version | 0.9.7 |
source | src |
created_at | 2016-03-01 14:03:46.512529 |
updated_at | 2024-08-01 13:06:05.047661 |
description | Library to lex and sanitize SQL |
homepage | |
repository | https://github.com/appsignal/sql_lexer |
max_upload_size | |
id | 4338 |
size | 115,987 |
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.
There's a utility included to sanitize a sql query in a file to facilitate testing:
cargo run -- <path-to-file>
Licensed under either of
at your option.
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.