Skip to main content

uqa_sql/catalog/
languages.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Language identities shared by routine metadata and catalog dependencies.
8
9pub const INTERNAL_LANGUAGE: u32 = 12;
10pub const C_LANGUAGE: u32 = 13;
11pub const SQL_LANGUAGE: u32 = 14;
12pub const PLPGSQL_LANGUAGE: u32 = 13_647;
13pub const PLPGSQL_EXTENSION: u32 = 13_643;
14pub const PLPGSQL_CALL_HANDLER: u32 = 13_644;
15pub const PLPGSQL_INLINE_HANDLER: u32 = 13_645;
16pub const PLPGSQL_VALIDATOR: u32 = 13_646;
17
18pub const fn language_name(oid: u32) -> Option<&'static str> {
19    match oid {
20        INTERNAL_LANGUAGE => Some("internal"),
21        C_LANGUAGE => Some("c"),
22        SQL_LANGUAGE => Some("sql"),
23        PLPGSQL_LANGUAGE => Some("plpgsql"),
24        _ => None,
25    }
26}
27
28pub fn language_oid(name: &str) -> Option<u32> {
29    [
30        INTERNAL_LANGUAGE,
31        C_LANGUAGE,
32        SQL_LANGUAGE,
33        PLPGSQL_LANGUAGE,
34    ]
35    .into_iter()
36    .find(|&oid| language_name(oid).is_some_and(|known| known.eq_ignore_ascii_case(name)))
37}
38
39#[cfg(test)]
40mod tests {
41    use super::*;
42
43    #[test]
44    fn bootstrap_language_names_preserve_postgresql_identities() {
45        for (oid, name) in [
46            (12, "internal"),
47            (13, "c"),
48            (14, "sql"),
49            (13_647, "plpgsql"),
50        ] {
51            assert_eq!(language_name(oid), Some(name));
52            assert_eq!(language_oid(name), Some(oid));
53            assert_eq!(language_oid(&name.to_ascii_uppercase()), Some(oid));
54        }
55        assert_eq!(language_name(0), None);
56        assert_eq!(language_oid("missing"), None);
57    }
58}