uqa-sql 0.5.0

PostgreSQL-compatible SQL compiler built on libpg_query
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

//! Language identities shared by routine metadata and catalog dependencies.

pub const INTERNAL_LANGUAGE: u32 = 12;
pub const C_LANGUAGE: u32 = 13;
pub const SQL_LANGUAGE: u32 = 14;
pub const PLPGSQL_LANGUAGE: u32 = 13_647;

pub const fn language_name(oid: u32) -> Option<&'static str> {
    match oid {
        INTERNAL_LANGUAGE => Some("internal"),
        C_LANGUAGE => Some("c"),
        SQL_LANGUAGE => Some("sql"),
        PLPGSQL_LANGUAGE => Some("plpgsql"),
        _ => None,
    }
}

pub fn language_oid(name: &str) -> Option<u32> {
    [
        INTERNAL_LANGUAGE,
        C_LANGUAGE,
        SQL_LANGUAGE,
        PLPGSQL_LANGUAGE,
    ]
    .into_iter()
    .find(|&oid| language_name(oid).is_some_and(|known| known.eq_ignore_ascii_case(name)))
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn bootstrap_language_names_preserve_postgresql_identities() {
        for (oid, name) in [
            (12, "internal"),
            (13, "c"),
            (14, "sql"),
            (13_647, "plpgsql"),
        ] {
            assert_eq!(language_name(oid), Some(name));
            assert_eq!(language_oid(name), Some(oid));
            assert_eq!(language_oid(&name.to_ascii_uppercase()), Some(oid));
        }
        assert_eq!(language_name(0), None);
        assert_eq!(language_oid("missing"), None);
    }
}