Struct Insert

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

A builder for an INSERT statement.

Implementations

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

Converts to this type from the input type.

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

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

Converts to this type from the input type.

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

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

Tests for self and other values to be equal, and is used by ==.

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

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

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