Struct InsertBuilder 

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

INSERT query builder.

Example

// Simple insert
let id = insert!(hero).execute(cx, &conn).await?;

// Insert with RETURNING
let row = insert!(hero).returning().execute_returning(cx, &conn).await?;

// Insert with UPSERT
let id = insert!(hero)
    .on_conflict_do_nothing()
    .execute(cx, &conn).await?;

Implementations

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

pub fn new(model: &'a M) -> Self

Create a new INSERT builder for the given model instance.

pub fn returning(self) -> Self

Add RETURNING * clause to return the inserted row.

Use with execute_returning() to get the inserted row.

pub fn on_conflict_do_nothing(self) -> Self

Handle conflicts by doing nothing (PostgreSQL ON CONFLICT DO NOTHING).

This allows the insert to silently succeed even if it would violate a unique constraint.

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

Handle conflicts by updating specified columns (UPSERT).

If columns is empty, all non-primary-key columns are updated. The conflict target defaults to the primary key.

Example

// Update name and age on conflict
insert!(hero)
    .on_conflict_do_update(&["name", "age"])
    .execute(cx, &conn).await?;

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

Handle conflicts by updating columns with a specific conflict target.

Arguments

• target - The columns that form the unique constraint to match
• columns - The columns to update on conflict

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

Build the INSERT SQL and parameters with default dialect (Postgres).

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

Build the INSERT SQL and parameters with specific dialect.

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

Execute the INSERT and return the inserted ID.

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

Execute the INSERT with RETURNING and get the inserted row.

This automatically adds RETURNING * and returns the full row.

Trait Implementations

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

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

Formats the value using the given formatter.