use crate::dialect;
use crate::error::DbError;
pub fn is_valid_identifier(s: &str) -> bool {
dialect::is_valid_identifier(s)
}
pub fn quote_identifier(ident: &str) -> Result<String, DbError> {
dialect::quote_identifier(dialect::MYSQL, ident)
}
pub fn quote_qualified(ident: &str) -> Result<String, DbError> {
dialect::quote_qualified(dialect::MYSQL, ident)
}
#[cfg(test)]
#[allow(clippy::unwrap_used)]
mod tests {
use super::*;
#[test]
fn test_is_valid_identifier() {
assert!(is_valid_identifier("users"));
assert!(is_valid_identifier("user_id"));
assert!(is_valid_identifier("_internal"));
assert!(is_valid_identifier("a1"));
assert!(!is_valid_identifier(""));
assert!(!is_valid_identifier("1users"));
assert!(!is_valid_identifier("user name"));
assert!(!is_valid_identifier("user-name"));
assert!(!is_valid_identifier("user;DROP"));
assert!(!is_valid_identifier("a.b"));
assert!(!is_valid_identifier("COUNT(*)"));
assert!(!is_valid_identifier("a`b"));
}
#[test]
fn test_quote_identifier() {
assert_eq!(quote_identifier("users").unwrap(), "`users`");
assert_eq!(quote_identifier("user_id").unwrap(), "`user_id`");
assert!(quote_identifier("user;DROP").is_err());
assert!(quote_identifier("a b").is_err());
}
#[test]
fn test_quote_qualified() {
assert_eq!(quote_qualified("name").unwrap(), "`name`");
assert_eq!(quote_qualified("users.name").unwrap(), "`users`.`name`");
assert_eq!(
quote_qualified("db.users.name").unwrap(),
"`db`.`users`.`name`"
);
assert!(quote_qualified("a.b.c.d").is_err());
assert!(quote_qualified("users.COUNT(*)").is_err());
}
}