1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127

//! Extract name paramters and sql statement from the named sql template.

use crate::{sql_dialect::SqlDialect, error::{ParseSqlResult, ParseSqlError}};

///
/// extract sql and params from raw sql
/// 
/// # Examples
///
/// Basic usage:
/// 
/// ```ignore
///
/// 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()
/// );
/// ```
pub fn extract_params(o_sql: &str, sql_dial: SqlDialect) -> ParseSqlResult<(String, Vec<String>)> {
    // eprintln!("{:#?}", o_sql);
    let mut r_sql = String::new();
    let mut params: Vec<String> = vec![];

    let mut count = 0;
    let mut start: usize = 0;
    let mut cur = start;
    let end = o_sql.len();

    while cur < end {
        let (found, current_cursor) = char_index(o_sql, cur, vec![':']);

        if found {
            cur = current_cursor;
            count += 1;
            match sql_dial {
                SqlDialect::postgres => {
                    r_sql.push_str(&o_sql[start..cur]);
                    r_sql.push('$');
                    r_sql.push_str(&count.to_string());
                },
                _ => r_sql.push_str(&format!("{}?", &o_sql[start..cur])),
            }
            
            // skip ":" char
            cur += 1;
            start = cur;

            // get named parameter end index
            let err_msg = "not found named parameter after ':'".to_owned();
            if cur == end {
                return Err(ParseSqlError(err_msg))
            } else {
                let (found, current_cursor) = char_index(o_sql, cur, vec![' ', '\n', '\t', ',', ';', '{', ')', '|']);
                if found && current_cursor == cur {
                    return Err(ParseSqlError(err_msg))
                }

                cur = current_cursor;
                let p = &o_sql[start..cur];
                params.push(p.to_string());
                start = cur;
            }
        } else {
            let rail_sql = &o_sql[start..end];
            r_sql.push_str(rail_sql);
            break;
        }
    }

    Ok((r_sql, params))
}

///
/// get the index for specified chars in the string slice from begin pos
/// 
pub fn char_index(s: &str, begin: usize, search_chars:Vec<char>) -> (bool, usize) {
    let end = s.len();
    for i in begin..end {
        let c = &s[i..i+1];
        for j in 0..search_chars.len() {
            let a = &search_chars[j].to_string();
            if c == a {
                return (true, i)
            }
        }
    }
    
    (false, end)
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn test_extract_sql() {
        let sql = "select * from abc where id=:id and name=:name";
        let rst = extract_params(sql, SqlDialect::postgres);
        assert_eq!(("select * from abc where id=$1 and name=$2".to_owned(), vec!["id".to_owned(), "name".to_owned()]), rst.unwrap());
    }

    #[test]
    fn test_extract_wrong_parameter() {
        let sql = "select * from abc where id=: id and name=:name order by id";
        let rst = extract_params(sql, SqlDialect::postgres);
        match rst {
            Ok(_) => panic!("Unexpected error"),
            Err(_) => (),
        };

        let sql = "select * from abc where id=:id and name=:";
        let rst = extract_params(sql, SqlDialect::postgres);
        match rst {
            Ok(_) => panic!("Unexpected error"),
            Err(_) => (),
        };
    }
}