Struct InsertManyBuilder 

pub struct InsertManyBuilder<'a, M: Model> { /* private fields */ }

Bulk INSERT query builder.

Example

let heroes = vec![hero1, hero2, hero3];
let ids = insert_many!(heroes)
    .execute(cx, &conn).await?;

Implementations

impl<'a, M: Model> InsertManyBuilder<'a, M>

pub fn new(models: &'a [M]) -> Self

Create a new bulk INSERT builder for the given model instances.

pub fn returning(self) -> Self

Add RETURNING * clause to return the inserted rows.

pub fn on_conflict_do_nothing(self) -> Self

Handle conflicts by doing nothing.

pub fn on_conflict_do_update(self, columns: &[&str]) -> Self

Handle conflicts by updating specified columns.

pub fn build(&self) -> (String, Vec<Value>)

Build the bulk INSERT SQL and parameters with default dialect.

pub fn build_with_dialect(&self, dialect: Dialect) -> (String, Vec<Value>)

Build the bulk INSERT SQL and parameters with specific dialect.

pub async fn execute<C: Connection>( self, cx: &Cx, conn: &C, ) -> Outcome<u64, Error>

Execute the bulk INSERT and return rows affected.

pub async fn execute_returning<C: Connection>( self, cx: &Cx, conn: &C, ) -> Outcome<Vec<Row>, Error>

Execute the bulk INSERT with RETURNING and get the inserted rows.

Trait Implementations

impl<'a, M: Debug + Model> Debug for InsertManyBuilder<'a, M>

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

Formats the value using the given formatter.