sql_insight::extractor::crud_table_extractor

Function extract_crud_tables

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

Convenience function to extract CRUD tables from SQL.

ยงExample

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

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