Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

3.6 KB
Raw Blame
use super::*;
use sqlparser::dialect::OracleDialect;
use sqlparser::tokenizer::{Token, Tokenizer, Word};

#[derive(Clone, PartialEq)]
pub struct NativeJobSchedulerReferenceTarget {
    pub kind: NativeJobReferenceKind,
    pub reference: NativeJobObjectReference,
}

/// Normalize one reference without treating dots or commas inside quoted names as separators.
/// Ordinary action bodies are not references. NULL means an explicit detach, with no new target.
pub fn native_job_scheduler_reference_target(
    attribute: &str,
    value: &Value,
    job_owner: &str,
    job_type: &str,
) -> Result<Option<NativeJobSchedulerReferenceTarget>, &'static str> {
    let default_kind = match attribute.to_ascii_uppercase().as_str() {
        "PROGRAM_NAME" => NativeJobReferenceKind::Program,
        "SCHEDULE_NAME" => NativeJobReferenceKind::Schedule,
        "CREDENTIAL_NAME" | "CONNECT_CREDENTIAL_NAME" => NativeJobReferenceKind::Credential,
        "DESTINATION_NAME" => NativeJobReferenceKind::Destination,
        "JOB_ACTION" if job_type.eq_ignore_ascii_case("CHAIN") => NativeJobReferenceKind::Chain,
        _ => return Ok(None),
    };
    if value.is_null() {
        return Ok(None);
    }
    let invalid = "native_job_reference_input_invalid";
    let (kind, reference) = match value {
        Value::Object(object) => {
            let reference: NativeJobObjectReference = serde_json::from_value(value.clone()).map_err(|_| invalid)?;
            let kind = object
                .get("kind")
                .map(|kind| serde_json::from_value(kind.clone()).map_err(|_| invalid))
                .transpose()?
                .unwrap_or(default_kind);
            (kind, reference)
        }
        Value::String(name) => (default_kind, legacy_reference(name, job_owner)?),
        _ => return Err(invalid),
    };
    let compatible = kind == default_kind
        || matches!(
            (default_kind, kind),
            (NativeJobReferenceKind::Schedule, NativeJobReferenceKind::Window | NativeJobReferenceKind::WindowGroup)
                | (NativeJobReferenceKind::Destination, NativeJobReferenceKind::DestinationGroup)
        );
    if !compatible || [&reference.owner, &reference.name].iter().any(|value| value.is_empty() || value.contains('\0')) {
        return Err(invalid);
    }
    Ok(Some(NativeJobSchedulerReferenceTarget { kind, reference }))
}

fn legacy_reference(value: &str, job_owner: &str) -> Result<NativeJobObjectReference, &'static str> {
    let invalid = "native_job_reference_input_invalid";
    if value.contains('\0') {
        return Err(invalid);
    }
    let tokens = Tokenizer::new(&OracleDialect {}, value).tokenize().map_err(|_| invalid)?;
    // Skip spacing, not comments: a native object-name value is not a SQL statement.
    let tokens: Vec<_> = tokens
        .into_iter()
        .filter(|token| {
            !matches!(
                token,
                Token::Whitespace(
                    sqlparser::tokenizer::Whitespace::Space
                        | sqlparser::tokenizer::Whitespace::Newline
                        | sqlparser::tokenizer::Whitespace::Tab
                )
            )
        })
        .collect();
    let identifier = |word: &Word| match word.quote_style {
        Some('"') => Ok(word.value.clone()),
        None => Ok(word.value.to_uppercase()),
        _ => Err(invalid),
    };
    match tokens.as_slice() {
        [Token::Word(name)] => Ok(NativeJobObjectReference { owner: job_owner.into(), name: identifier(name)? }),
        [Token::Word(owner), Token::Period, Token::Word(name)] => {
            Ok(NativeJobObjectReference { owner: identifier(owner)?, name: identifier(name)? })
        }
        _ => Err(invalid),
    }
}