sql-parse 0.24.0

Parser for sql
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

use alloc::vec::Vec;

use crate::{
    keywords::Keyword,
    lexer::Token,
    parser::{ParseError, Parser},
    qualified_name::parse_qualified_name,
    QualifiedName, Span, Spanned,
};

#[derive(Debug, Clone)]
pub struct TableToTable<'a> {
    pub table: QualifiedName<'a>,
    /// Span of "TO"
    pub to_span: Span,
    pub new_table: QualifiedName<'a>,
}

impl<'a> Spanned for TableToTable<'a> {
    fn span(&self) -> Span {
        self.table
            .join_span(&self.to_span)
            .join_span(&self.new_table)
    }
}

/// Represent a rename table statement
/// ```
/// # use sql_parse::{SQLDialect, SQLArguments, ParseOptions, parse_statements, RenameTable, Statement, Issues};
/// # let options = ParseOptions::new().dialect(SQLDialect::MariaDB);
/// #
/// let sql = "RENAME TABLE `t1` TO `t2`;";
/// let mut issues = Issues::new(sql);
/// let mut stmts = parse_statements(sql, &mut issues, &options);
///
/// # assert!(issues.is_ok(), "Issues: {}", issues);
/// #
/// let rename_table: RenameTable = match stmts.pop() {
///     Some(Statement::RenameTable(c)) => c,
///     _ => panic!("We should get a rename table statement")
/// };
///
/// assert!(rename_table.table_to_tables.get(0).unwrap().table.identifier.as_str() == "t1");
///
///

#[derive(Debug, Clone)]
pub struct RenameTable<'a> {
    /// Span of "RENAME"
    pub rename_span: Span,
    /// Span of "TABLE" if specified
    pub table_span: Option<Span>,
    pub table_to_tables: Vec<TableToTable<'a>>,
}

impl<'a> Spanned for RenameTable<'a> {
    fn span(&self) -> Span {
        self.rename_span
            .join_span(&self.table_span)
            .join_span(&self.table_to_tables)
    }
}

pub(crate) fn parse_rename_table<'a>(
    parser: &mut Parser<'a, '_>,
) -> Result<RenameTable<'a>, ParseError> {
    let rename_span = parser.consume_keyword(Keyword::RENAME)?;
    let table_span = parser.skip_keyword(Keyword::TABLE);
    let mut table_to_tables = Vec::new();
    loop {
        let table = parse_qualified_name(parser)?;
        let to_span = parser.consume_keyword(Keyword::TO)?;
        let new_table = parse_qualified_name(parser)?;
        table_to_tables.push(TableToTable {
            table,
            to_span,
            new_table,
        });
        if parser.skip_token(Token::Comma).is_none() {
            break;
        }
    }
    Ok(RenameTable {
        rename_span,
        table_span,
        table_to_tables,
    })
}