Function parse_drop_database

nodedb-sql/src/ddl_ast/parse/database/drop_db.rs:8–49

(parts: &[&str])

use crate::error::SqlError;

pub(super) fn parse_drop_database(parts: &[&str]) -> Result<NodedbStatement, SqlError> {
    // FORCE is accepted as a synonym for CASCADE: both set `cascade = true`.
    // Any token after the name that is not CASCADE/FORCE is a parse error —
    // silently ignoring trailing garbage masks typos in user SQL.
    let mut idx = 2usize;
    let if_exists = if parts.get(idx).map(|w| w.to_uppercase()).as_deref() == Some("IF")
        && parts.get(idx + 1).map(|w| w.to_uppercase()).as_deref() == Some("EXISTS")
    {
        idx += 2;
        true
    } else {
        false
    };

    let name = parts
        .get(idx)
        .copied()
        .ok_or_else(|| SqlError::Parse {
            detail: "DROP DATABASE requires a name".into(),
        })?
        .to_string();
    let name = name.trim_matches('"').to_string();
    idx += 1;

    let mut cascade = false;
    for w in &parts[idx..] {
        match w.to_uppercase().as_str() {
            "CASCADE" | "FORCE" => cascade = true,
            other => {
                return Err(SqlError::Parse {
                    detail: format!("DROP DATABASE: unexpected token '{other}'"),
                });
            }
        }
    }

    Ok(NodedbStatement::Database(DatabaseStmt::DropDatabase {
        name,
        if_exists,
        cascade,
    }))
}

#[cfg(test)]
mod tests {