Function dysql_core::extract_params

pub fn extract_params(
    o_sql: &str,
    sql_dial: SqlDialect
) -> ParseSqlResult<(String, Vec<String>)>

extract sql and params from raw sql

Examples

Basic usage:

let sql = "select * from abc where id=:id and name=:name order by id";
let rst = extract_params(sql, SqlDialect::postgres);
assert_eq!(
    ("select * from abc where id=$1 and name=$2 order by id".to_owned(), vec!["id".to_owned(), "name".to_owned()]),
    rst.unwrap()
);
 
let sql = "select * from abc where id=:id and name=:name order by id";
let rst = extract_params(sql, SqlDialect::mysql);
assert_eq!(
    ("select * from abc where id=? and name=? order by id".to_owned(), vec!["id".to_owned(), "name".to_owned()]),
    rst.unwrap()
);