Struct BatchInsert 

pub struct BatchInsert<'a, T> { /* private fields */ }

A batch insert builder for inserting multiple entities efficiently.

This generates a single INSERT statement with multiple value tuples, which is more efficient than executing individual INSERT statements.

Example

use rdbi::{BatchInsert, Pool};

let users = vec![
    User { id: 0, username: "alice".into(), email: "alice@example.com".into() },
    User { id: 0, username: "bob".into(), email: "bob@example.com".into() },
];

let result = BatchInsert::new("users", &users)
    .execute(&pool)
    .await?;

println!("Inserted {} rows", result.rows_affected);

Implementations

impl<'a, T: ToParams> BatchInsert<'a, T>

pub fn new(table: &'a str, entities: &'a [T]) -> Self

Create a new batch insert for the given table and entities.

pub async fn execute<P: Pool>(self, pool: &P) -> Result<ExecuteResult>

Execute the batch insert.

Returns the number of rows affected and the last insert ID (which is the ID of the first inserted row for batch inserts).