Skip to main content

extract_crud_tables

Function extract_crud_tables 

Source
pub fn extract_crud_tables(
    dialect: &dyn Dialect,
    sql: &str,
) -> Result<Vec<Result<CrudTables, Error>>, Error>
Expand description

Parse sql under dialect and return one CrudTables per statement.

ยงExample

use sql_insight::sqlparser::dialect::GenericDialect;

let dialect = GenericDialect {};
let sql = "INSERT INTO t1 (a) SELECT a FROM t2";
let result = sql_insight::extractor::extract_crud_tables(&dialect, sql).unwrap();
println!("{:#?}", result);
assert_eq!(result[0].as_ref().unwrap().to_string(), "Create: [t1], Read: [t2], Update: [], Delete: []");