pub(crate) fn pg_ident(ident: &str) -> String {
ident
.split('.')
.map(|p| format!("\"{}\"", p.replace('"', "\"\"")))
.collect::<Vec<_>>()
.join(".")
}
pub(crate) fn pg_bare(ident: &str) -> String {
format!(
"\"{}\"",
ident.split('.').next_back().unwrap_or(ident).replace('"', "\"\"")
)
}
pub(crate) fn mysql_ident(ident: &str) -> String {
ident
.split('.')
.map(|p| format!("`{}`", p.replace('`', "``")))
.collect::<Vec<_>>()
.join(".")
}
pub(crate) fn mysql_col(name: &str) -> String {
format!("`{}`", name.replace('`', "``"))
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn pg_quotes_schema_qualified_and_hyphenated_tables() {
assert_eq!(pg_ident("curated.delivery-site"), r#""curated"."delivery-site""#);
assert_eq!(pg_ident("shipment"), r#""shipment""#);
assert_eq!(pg_ident("curated.shipment"), r#""curated"."shipment""#);
assert_eq!(pg_ident(r#"a"b"#), r#""a""b""#);
}
#[test]
fn pg_bare_takes_last_segment_only() {
assert_eq!(pg_bare("curated.sites-in-region"), r#""sites-in-region""#);
assert_eq!(pg_bare("plain"), r#""plain""#);
assert_eq!(pg_bare(r#"s.a"b"#), r#""a""b""#);
}
#[test]
fn mysql_backticks_schema_qualified_tables() {
assert_eq!(mysql_ident("billing.invoice"), "`billing`.`invoice`");
assert_eq!(mysql_ident("invoice"), "`invoice`");
assert_eq!(mysql_ident("we`ird"), "`we``ird`");
}
#[test]
fn mysql_col_never_splits_on_dots() {
assert_eq!(mysql_col("amount.total"), "`amount.total`");
assert_eq!(mysql_col("riskBand"), "`riskBand`");
assert_eq!(mysql_col("we`ird"), "`we``ird`");
}
}