Struct sql_parse::Delete

pub struct Delete<'a> {
    pub delete_span: Span,
    pub flags: Vec<DeleteFlag>,
    pub from_span: Span,
    pub tables: Vec<Vec<Identifier<'a>>>,
    pub using: Vec<TableReference<'a>>,
    pub where_: Option<(Expression<'a>, Span)>,
}

Represent a delete statement

let sql = "DELETE FROM t1 WHERE c1 IN (SELECT b.c1 FROM t1 b WHERE b.c2=0);";

let mut stmts = parse_statements(sql, &mut issues, &options);

let delete: Delete = match stmts.pop() {
    Some(Statement::Delete(d)) => d,
    _ => panic!("We should get a delete statement")
};

assert!(delete.tables[0][0].as_str() == "t1");
println!("{:#?}", delete.where_);

let sql = "DELETE `t1` FROM `t1` LEFT JOIN `t2` ON `t1`.`t2_id`=`t2`.`id` WHERE `t2`.`key`='my_key';";

let mut stmts = parse_statements(sql, &mut issues, &options);

Fields

delete_span: Span

Span of “DELETE”

flags: Vec<DeleteFlag>

Flags following “DELETE”

from_span: Span

Span of “FROM”

tables: Vec<Vec<Identifier<'a>>>

Tables to do deletes on

using: Vec<TableReference<'a>>

Table to use in where clause in multi table delete

where_: Option<(Expression<'a>, Span)>

Where expression and Span of “WHERE” if specified

Trait Implementations

impl<'a> Clone for Delete<'a>

fn clone(&self) -> Delete<'a>

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl<'a> Debug for Delete<'a>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'a> Spanned for Delete<'a>

fn span(&self) -> Span

Compute byte span of an ast fragment

fn join_span(&self, other: &impl OptSpanned) -> Span

Compute the minimal span containing both self and other