use regex::Regex;
use super::parsed_sql::ParsedSql;
use super::statement_type::StatementType;
pub struct SqlParser;
impl SqlParser {
pub fn parse(sql: &str) -> ParsedSql {
let trimmed = sql.trim().to_string();
let upper = trimmed.to_uppercase();
let statement_type = if upper.starts_with("SELECT") {
StatementType::Select
} else if upper.starts_with("INSERT") {
StatementType::Insert
} else if upper.starts_with("UPDATE") {
StatementType::Update
} else if upper.starts_with("DELETE") {
StatementType::Delete
} else {
StatementType::Other(trimmed.clone())
};
ParsedSql {
statement_type,
original_sql: sql.to_string(),
trimmed_sql: trimmed,
has_distinct: upper.contains(" DISTINCT "),
has_group_by: upper.contains(" GROUP BY "),
has_order_by: upper.contains(" ORDER BY "),
has_union: upper.contains(" UNION "),
has_for_update: upper.contains(" FOR UPDATE") || upper.contains(" FOR SHARE"),
has_limit: upper.contains(" LIMIT "),
}
}
pub fn get_count_sql(sql: &str) -> String {
let parsed = Self::parse(sql);
if parsed.has_group_by || parsed.has_union || parsed.has_distinct {
format!("SELECT COUNT(*) AS total FROM ({}) _t", sql.trim_end())
} else {
Self::simple_count_rewrite(sql)
}
}
fn simple_count_rewrite(sql: &str) -> String {
let re = Regex::new(r"(?is)^\s*SELECT\s+.+?\s+FROM\s+").unwrap();
if re.find(sql).is_some() {
re.replace(sql, "SELECT COUNT(*) AS total FROM ").to_string()
} else {
format!("SELECT COUNT(*) AS total FROM ({}) _t", sql.trim_end())
}
}
pub fn replace_select_star(sql: &str, columns: &[&str]) -> String {
let re = Regex::new(r"(?is)^\s*SELECT\s+\*\s+FROM\s+").unwrap();
if re.find(sql).is_some() {
let cols = columns.join(", ");
re.replace(sql, &format!("SELECT {} FROM ", cols)).to_string()
} else {
sql.to_string()
}
}
}