Struct scooby::postgres::statements::InsertInto

pub struct InsertInto<V: Values> { /* private fields */ }

INSERT INTO statement with a VALUES clause, and possibly additional clauses.

Finalize and turn into String by calling to_string.

See insert_into docs for more details and examples.

Implementations

impl<V: Values> InsertInto<V>

pub fn returning( self, expressions: impl IntoIteratorOfSameType<OutputExpression> ) -> Self

Add one or more RETURNING expressions.

use scooby::postgres::insert_into;

let sql = insert_into("Dummy")
    .default_values()
    .returning("id")
    .returning(("width", "height"))
    .to_string();

assert_eq!(sql, "INSERT INTO Dummy DEFAULT VALUES RETURNING id, width, height");

pub fn on_conflict(self) -> OnConflictClauseBuilder<V>

Add an ON CONFLICT clause to this statement.

Returns a OnConflictClauseBuilder structure which requires you to specify an action to do when a conflict happens using follow up methods.

use scooby::postgres::insert_into;

let sql = insert_into("Dummy")
    .values(["a"])
    .on_conflict()
    .do_nothing()
    .to_string();

assert_eq!(sql, "INSERT INTO Dummy VALUES (a) ON CONFLICT DO NOTHING");

impl<const N: usize> InsertInto<WithColumns<N>>

pub fn values<T: IntoNonZeroArray<Expression, N>>( self, new_values: impl IntoIterator<Item = T> ) -> Self

Add one or more sets of values.

use scooby::postgres::insert_into;

let sql = insert_into("Dummy")
    .columns(("col1", "col2"))
    .values([("$1", "$2")])
    .values([("$3", "$4"), ("$5", "$6")])
    .to_string();

assert_eq!(sql, "INSERT INTO Dummy (col1, col2) VALUES ($1, $2), ($3, $4), ($5, $6)");

impl<const N: usize> InsertInto<WithoutColumns<N>>

pub fn values<T: IntoNonZeroArray<Expression, N>>( self, new_values: impl IntoIterator<Item = T> ) -> Self

Add one or more sets of values.

use scooby::postgres::insert_into;

let sql = insert_into("Dummy")
    .values([("$1", "$2")])
    .values([("$3", "$4"), ("$5", "$6")])
    .to_string();

assert_eq!(sql, "INSERT INTO Dummy VALUES ($1, $2), ($3, $4), ($5, $6)");

Trait Implementations

impl<V: Clone + Values> Clone for InsertInto<V>

fn clone(&self) -> InsertInto<V>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<V: Debug + Values> Debug for InsertInto<V>

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

Formats the value using the given formatter.

impl<V: Values> Display for InsertInto<V>

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

Formats the value using the given formatter.