use crate::error::DbError;
use crate::sql_types::{Identifier, QualifiedIdentifier};
pub fn is_valid_identifier(s: &str) -> bool {
Identifier::parse(s).is_ok()
}
pub fn quote_identifier(ident: &str) -> Result<String, DbError> {
Ok(QualifiedIdentifier::Unqualified(Identifier::parse(ident)?).render('`'))
}
pub fn quote_qualified(ident: &str) -> Result<String, DbError> {
Ok(QualifiedIdentifier::parse(ident)?.render('`'))
}
#[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!(quote_qualified("a.b.c").is_err());
assert!(quote_qualified("users.COUNT(*)").is_err());
}
}