Struct scooby::postgres::statements::BareInsertInto

pub struct BareInsertInto { /* private fields */ }

Bare INSERT INTO statement without a valid VALUES clause specified

You will want to make use of three methods to convert this into a usable statement:

• default_values to add a DEFAULT VALUES clause
• values to add VALUES (...) clause with unspecified columns
• columns to start building a (...) VALUES (...) clause with specific columns

Implementations

impl BareInsertInto

pub fn default_values(self) -> InsertInto<DefaultValues>

Add a DEFAULT VALUES clause to this statement

use scooby::postgres::insert_into;

let sql = insert_into("Dummy").default_values().to_string();

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

pub fn values<T: IntoNonZeroArray<Expression, N>, const N: usize>( self, values: impl IntoIterator<Item = T> ) -> InsertInto<WithoutColumns<N>>

Add a VALUES (...) clause with unspecified columns to this statement

use scooby::postgres::insert_into;

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

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

pub fn columns<const N: usize>( self, columns: impl IntoNonZeroArray<Column, N> ) -> InsertIntoColumnsBuilder<N>

Begin building a (...) VALUES (...) clause for this statement.

Expects a non-zero list of columns: an array, a tuple, or a single value.

Returns an InsertIntoColumnsBuilder structure which requires you to specify at least one set of values.

use scooby::postgres::insert_into;

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

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

Trait Implementations

impl Debug for BareInsertInto

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

Formats the value using the given formatter.