use crate::dialect;
use crate::error::DbError;
use crate::sql_types::{Identifier, QualifiedIdentifier, POSTGRES_MAX_IDENTIFIER_BYTES};
pub fn is_valid_identifier(s: &str) -> bool {
if s.len() > POSTGRES_MAX_IDENTIFIER_BYTES {
return false;
}
dialect::is_valid_identifier(s) || Identifier::parse_postgres(s).is_ok()
}
pub fn quote_identifier(ident: &str) -> Result<String, DbError> {
Ok(QualifiedIdentifier::parse_postgres_with_max_parts(ident, 1)?.render_postgres())
}
pub fn quote_qualified(ident: &str) -> Result<String, DbError> {
Ok(QualifiedIdentifier::parse_postgres(ident)?.render_postgres())
}
pub fn quote_table(ident: &str) -> Result<String, DbError> {
let parsed = QualifiedIdentifier::parse_postgres_with_max_parts(ident, 2)?;
match dialect::quote_table(dialect::POSTGRES, ident) {
Ok(quoted) => Ok(quoted),
Err(_) => Ok(parsed.render_postgres()),
}
}
#[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"));
assert!(!is_valid_identifier("a b"));
}
#[test]
fn postgres_identifier_rules() {
assert!(is_valid_identifier("用户"));
assert!(is_valid_identifier("a$b"));
assert!(!is_valid_identifier("$a"));
assert!(is_valid_identifier("a\"b"));
assert!(!is_valid_identifier("a\0b"));
assert!(!is_valid_identifier("a\nb"));
assert!(!is_valid_identifier("\u{7f}"));
}
#[test]
fn postgres_identifier_63_byte_limit() {
assert!(is_valid_identifier(&"a".repeat(63)));
assert!(!is_valid_identifier(&"a".repeat(64)));
assert!(is_valid_identifier(&"用".repeat(21)));
assert!(!is_valid_identifier(&"用".repeat(22)));
}
#[test]
fn test_quote_identifier() {
assert_eq!(quote_identifier("users").unwrap(), "\"users\"");
assert!(quote_identifier("user;DROP").is_err());
assert!(quote_identifier("$a").is_err());
assert!(quote_identifier("a\0b").is_err());
assert!(quote_identifier(&"a".repeat(64)).is_err());
}
#[test]
fn quote_postgres_unicode_and_embedded_quotes() {
assert_eq!(quote_identifier("用户").unwrap(), "\"用户\"");
assert_eq!(quote_identifier("a$b").unwrap(), "\"a$b\"");
assert_eq!(quote_identifier("a\"b").unwrap(), "\"a\"\"b\"");
assert_eq!(quote_qualified("模式.用户").unwrap(), "\"模式\".\"用户\"");
assert_eq!(
quote_qualified("audit.u.a\"b").unwrap(),
"\"audit\".\"u\".\"a\"\"b\""
);
assert_eq!(quote_table("审计.事件").unwrap(), "\"审计\".\"事件\"");
}
#[test]
fn test_quote_qualified() {
assert_eq!(quote_qualified("name").unwrap(), "\"name\"");
assert_eq!(quote_qualified("u.name").unwrap(), "\"u\".\"name\"");
assert_eq!(
quote_qualified("audit.u.name").unwrap(),
"\"audit\".\"u\".\"name\""
);
assert!(quote_qualified("a.b.c.d").is_err());
}
#[test]
fn test_quote_table() {
assert_eq!(quote_table("users").unwrap(), "\"users\"");
assert_eq!(quote_table("audit.users").unwrap(), "\"audit\".\"users\"");
assert!(quote_table("a.b.c").is_err());
assert!(quote_table("users;DROP").is_err());
}
}