Library to parse and edit database dump for Postgres, MySQL and MongoDB.
Example for Postgres
let q = r"
INSERT INTO public.customers (customer_id, company_name, contact_name, contact_title)
VALUES (1, 'Alfreds Futterkiste', 'Maria Anders', NULL);
";
let mut tokenizer = Tokenizer::new(q);
let tokens_result = tokenizer.tokenize();
assert_eq!(tokens_result.is_ok(), true);
let tokens = trim_pre_whitespaces(tokens_result.unwrap());
let column_values = get_column_values_from_insert_into_query(&tokens);
assert_eq!(
column_values,
vec![
&Token::Number("1".to_string(), false),
&Token::SingleQuotedString("Alfreds Futterkiste".to_string()),
&Token::SingleQuotedString("Maria Anders".to_string()),
&Token::make_keyword("NULL"),
]
);