nodedb-sql 0.0.0-beta.5

SQL parser, planner, and optimizer for NodeDB
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

//! SQL identifier normalization.

/// Normalize a SQL identifier: lowercase unquoted, preserve quoted.
pub fn normalize_ident(ident: &sqlparser::ast::Ident) -> String {
    if ident.quote_style.is_some() {
        ident.value.clone()
    } else {
        ident.value.to_lowercase()
    }
}

/// Normalize a compound object name (e.g., `schema.table`) to its last part.
pub fn normalize_object_name(name: &sqlparser::ast::ObjectName) -> String {
    name.0
        .last()
        .map(|part| match part {
            sqlparser::ast::ObjectNamePart::Identifier(ident) => normalize_ident(ident),
            _ => String::new(),
        })
        .unwrap_or_default()
}

/// Extract table name and optional alias from a table factor.
pub fn table_name_from_factor(
    factor: &sqlparser::ast::TableFactor,
) -> Option<(String, Option<String>)> {
    match factor {
        sqlparser::ast::TableFactor::Table { name, alias, .. } => {
            let table = normalize_object_name(name);
            let alias_name = alias.as_ref().map(|a| normalize_ident(&a.name));
            Some((table, alias_name))
        }
        _ => None,
    }
}