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("_x"));
assert!(!is_valid_identifier(""));
assert!(!is_valid_identifier("1a"));
assert!(!is_valid_identifier("a;b"));
assert!(!is_valid_identifier("a\"b"));
}
#[test]
fn test_quote_identifier() {
assert_eq!(quote_identifier("users").unwrap(), "\"users\"");
assert!(quote_identifier("user;DROP").is_err());
}
#[test]
fn test_quote_qualified() {
assert_eq!(quote_qualified("name").unwrap(), "\"name\"");
assert_eq!(quote_qualified("u.name").unwrap(), "\"u\".\"name\"");
assert!(quote_qualified("a.b.c").is_err());
}
}