Struct sql_parse::Insert

pub struct Insert<'a> {
    pub insert_span: Span,
    pub flags: Vec<InsertFlag>,
    pub into_span: Option<Span>,
    pub table: Vec<Identifier<'a>>,
    pub columns: Vec<Identifier<'a>>,
    pub values: Option<(Span, Vec<Vec<Expression<'a>>>)>,
    pub select: Option<Select<'a>>,
}

Representation of Insert Statement

let sql1 = "INSERT INTO person (first_name, last_name) VALUES ('John', 'Doe')";
let stmt1 = parse_statement(sql1, &mut issues, &options);
let sql2 = "INSERT INTO contractor SELECT * FROM person WHERE status = 'c'";
let stmt2 = parse_statement(sql1, &mut issues, &options);

let i: Insert = match stmt1 {
    Some(Statement::Insert(i)) => i,
    _ => panic!("We should get an insert statement")
};

assert!(i.table[0].as_str() == "person");
println!("{:#?}", i.values.unwrap())

Fields

insert_span: Span

Span of “INSERT”

flags: Vec<InsertFlag>

Flags specified after “INSERT”

into_span: Option<Span>

Span of “INTO” if specified

table: Vec<Identifier<'a>>

Table to insert into

columns: Vec<Identifier<'a>>

List of columns to set

values: Option<(Span, Vec<Vec<Expression<'a>>>)>

Span of values “VALUES” and list of tuples to insert if specified

select: Option<Select<'a>>

Select statement to insert if specified

Trait Implementations

impl<'a> Clone for Insert<'a>

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

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for Insert<'a>

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

Formats the value using the given formatter.

impl<'a> Spanned for Insert<'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