Struct quaint::ast::Insert

pub struct Insert<'a> { /* fields omitted */ }

A builder for an INSERT statement.

Methods

impl<'a> Insert<'a>

pub fn single_into<T>(table: T) -> SingleRowInsert<'a> where
    T: Into<Table<'a>>, 

Creates a new single row INSERT statement for the given table.

let query = Insert::single_into("users");
let (sql, _) = Sqlite::build(query);

assert_eq!("INSERT INTO `users` DEFAULT VALUES", sql);

pub fn multi_into<T, K, I>(table: T, columns: I) -> MultiRowInsert<'a> where
    T: Into<Table<'a>>,
    K: Into<Column<'a>>,
    I: IntoIterator<Item = K>, 

Creates a new multi row INSERT statement for the given table.

pub fn on_conflict(self, on_conflict: OnConflict) -> Self

Sets the conflict resolution strategy.

pub fn returning<K, I>(self, columns: I) -> Self where
    K: Into<Column<'a>>,
    I: IntoIterator<Item = K>, 

Sets the returned columns.

let query = Insert::single_into("users");
let insert = Insert::from(query).returning(vec!["id"]);
let (sql, _) = Postgres::build(insert);

assert_eq!("INSERT INTO \"users\" DEFAULT VALUES RETURNING \"id\"", sql);

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> From<Insert<'a>> for Query<'a>

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

Performs the conversion.

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

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

Performs the conversion.

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

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

Performs the conversion.

impl<'a> PartialEq<Insert<'a>> for Insert<'a>

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

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

fn ne(&self, other: &Insert<'a>) -> bool

This method tests for !=.

impl<'a> StructuralPartialEq for Insert<'a>