nodedb-sql 0.0.6

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

//! Parse CREATE/DROP/ALTER/DESCRIBE/SHOW SEQUENCE.

use super::helpers::extract_name_after_if_exists;
use crate::ddl_ast::statement::NodedbStatement;

pub(super) fn try_parse(upper: &str, parts: &[&str], trimmed: &str) -> Option<NodedbStatement> {
    if upper.starts_with("CREATE SEQUENCE ") {
        let if_not_exists = upper.contains("IF NOT EXISTS");
        let name = extract_name_after_if_exists(parts, "SEQUENCE")?;
        return Some(NodedbStatement::CreateSequence {
            name,
            if_not_exists,
            raw_sql: trimmed.to_string(),
        });
    }
    if upper.starts_with("DROP SEQUENCE ") {
        let if_exists = upper.contains("IF EXISTS");
        let name = extract_name_after_if_exists(parts, "SEQUENCE")?;
        return Some(NodedbStatement::DropSequence { name, if_exists });
    }
    if upper.starts_with("ALTER SEQUENCE ") {
        return Some(NodedbStatement::AlterSequence {
            raw_sql: trimmed.to_string(),
        });
    }
    if upper.starts_with("DESCRIBE SEQUENCE ") {
        let name = parts.get(2)?.to_string();
        return Some(NodedbStatement::DescribeSequence { name });
    }
    if upper == "SHOW SEQUENCES" || upper.starts_with("SHOW SEQUENCES") {
        return Some(NodedbStatement::ShowSequences);
    }
    None
}