Struct grafbase_sql_ast::ast::MultiRowInsert

pub struct MultiRowInsert<'a> { /* private fields */ }

A builder for an INSERT statement for multiple rows.

Implementations

impl<'a> MultiRowInsert<'a>

pub fn values<V>(&mut self, values: V)

where V: Into<Row<'a>>,

Adds multiple new rows to be inserted.

let mut query = Insert::multi_into("users", vec!["foo"]);

query.values(vec![1]);
query.values(vec![2]);

let (sql, params) = renderer::Postgres::build(query);

assert_eq!(r#"INSERT INTO "users" ("foo") VALUES ($1), ($2)"#, sql);

assert_eq!(
    vec![
        Value::from(1),
        Value::from(2),
    ], params);

pub fn extend(&mut self, other: SingleRowInsert<'a>) -> Result<()>

Extend the insert statement with a single row insert.

Both inserts must be to the same table and must include the same columns.

pub fn build(self) -> Insert<'a>

Convert into a common Insert statement.

Trait Implementations

impl<'a> Clone for MultiRowInsert<'a>

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

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for MultiRowInsert<'a>

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

Formats the value using the given formatter.

impl<'a> From<MultiRowInsert<'a>> for Insert<'a>

fn from(insert: MultiRowInsert<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<MultiRowInsert<'a>> for Query<'a>

fn from(insert: MultiRowInsert<'a>) -> Query<'a>

Converts to this type from the input type.

impl<'a> PartialEq for MultiRowInsert<'a>

fn eq(&self, other: &MultiRowInsert<'a>) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl<'a> StructuralPartialEq for MultiRowInsert<'a>