uqa-sql 0.5.2

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

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

//! Preserve absent and explicitly empty server strings across protobuf's scalar-string representation.

use crate::{ast::CreateForeignServer, SQLError};
use pg_query::protobuf::Token;

/// The parser has already validated the grammar. Token positions distinguish omitted TYPE/VERSION from empty literals without interpreting comments, quoted identifiers or string contents as keywords.
pub(super) fn retain_string_presence(
    sql: &str,
    statement: &mut CreateForeignServer,
) -> Result<(), SQLError> {
    let scanned = crate::parser::scan(sql)?;
    let tokens = scanned
        .tokens
        .iter()
        .map(|token| token.token())
        .filter(|token| !matches!(token, Token::SqlComment | Token::CComment))
        .collect::<Vec<_>>();
    // CREATE SERVER [IF NOT EXISTS] name [TYPE string] [VERSION string|NULL].
    let mut position = after_token(&tokens, if statement.if_not_exists { 5 } else { 2 });
    if tokens.get(position) == Some(&Token::TypeP) {
        statement.server_type.get_or_insert_with(String::new);
        position = after_token(&tokens, position + 1);
    }
    if tokens.get(position) == Some(&Token::VersionP)
        && tokens.get(position + 1) != Some(&Token::NullP)
    {
        statement.version.get_or_insert_with(String::new);
    }
    Ok(())
}

/// Unicode identifiers and string literals may carry an explicit UESCAPE string after the token itself.
fn after_token(tokens: &[Token], position: usize) -> usize {
    let next = position + 1;
    if tokens.get(next) == Some(&Token::Uescape) {
        next + 2
    } else {
        next
    }
}