rbatis_plus_sqlparser/parser/
sql_parser.rs1use regex::Regex;
12
13use super::parsed_sql::ParsedSql;
14use super::statement_type::StatementType;
15
16pub struct SqlParser;
21
22impl SqlParser {
23 pub fn parse(sql: &str) -> ParsedSql {
25 let trimmed = sql.trim().to_string();
26 let upper = trimmed.to_uppercase();
27
28 let statement_type = if upper.starts_with("SELECT") {
29 StatementType::Select
30 } else if upper.starts_with("INSERT") {
31 StatementType::Insert
32 } else if upper.starts_with("UPDATE") {
33 StatementType::Update
34 } else if upper.starts_with("DELETE") {
35 StatementType::Delete
36 } else {
37 StatementType::Other(trimmed.clone())
38 };
39
40 ParsedSql {
41 statement_type,
42 original_sql: sql.to_string(),
43 trimmed_sql: trimmed,
44 has_distinct: upper.contains(" DISTINCT "),
45 has_group_by: upper.contains(" GROUP BY "),
46 has_order_by: upper.contains(" ORDER BY "),
47 has_union: upper.contains(" UNION "),
48 has_for_update: upper.contains(" FOR UPDATE") || upper.contains(" FOR SHARE"),
49 has_limit: upper.contains(" LIMIT "),
50 }
51 }
52
53 pub fn get_count_sql(sql: &str) -> String {
58 let parsed = Self::parse(sql);
59
60 if parsed.has_group_by || parsed.has_union || parsed.has_distinct {
61 format!("SELECT COUNT(*) AS total FROM ({}) _t", sql.trim_end())
63 } else {
64 Self::simple_count_rewrite(sql)
66 }
67 }
68
69 fn simple_count_rewrite(sql: &str) -> String {
71 let re = Regex::new(r"(?is)^\s*SELECT\s+.+?\s+FROM\s+").unwrap();
72 if re.find(sql).is_some() {
73 re.replace(sql, "SELECT COUNT(*) AS total FROM ").to_string()
74 } else {
75 format!("SELECT COUNT(*) AS total FROM ({}) _t", sql.trim_end())
77 }
78 }
79
80 pub fn replace_select_star(sql: &str, columns: &[&str]) -> String {
84 let re = Regex::new(r"(?is)^\s*SELECT\s+\*\s+FROM\s+").unwrap();
85 if re.find(sql).is_some() {
86 let cols = columns.join(", ");
87 re.replace(sql, &format!("SELECT {} FROM ", cols)).to_string()
88 } else {
89 sql.to_string()
90 }
91 }
92}