Struct UpsertBuilder 

pub struct UpsertBuilder<T> { /* private fields */ }

Builder for UPSERT (INSERT … ON CONFLICT DO UPDATE) queries. Implements Modifiable. Call .select() for RETURNING clause.

Implementations

impl<T> UpsertBuilder<T>

pub fn on_conflict(self, columns: &[&str]) -> UpsertBuilder<T>

Set the conflict columns for ON CONFLICT.

pub fn on_conflict_constraint(self, constraint: &str) -> UpsertBuilder<T>

Set a constraint name for ON CONFLICT ON CONSTRAINT.

pub fn ignore_duplicates(self) -> UpsertBuilder<T>

Use ON CONFLICT DO NOTHING instead of DO UPDATE.

When set, duplicate rows are silently ignored instead of updated.

pub fn schema(self, schema: &str) -> UpsertBuilder<T>

Override the schema for this query.

Generates "schema"."table" instead of the default schema.

pub fn select(self) -> UpsertBuilder<T>

Add RETURNING * clause.

pub fn select_columns(self, columns: &str) -> UpsertBuilder<T>

Add RETURNING with specific columns.

impl<T> UpsertBuilder<T>

where T: DeserializeOwned + Send,

pub async fn execute(self) -> SupabaseResponse<T>

Execute the UPSERT query.

Trait Implementations

impl<T> Modifiable for UpsertBuilder<T>

fn parts_mut(&mut self) -> &mut SqlParts

Get a mutable reference to the SQL parts.

fn order(self, column: &str, direction: OrderDirection) -> Self

Order by a column.

fn order_with_nulls( self, column: &str, direction: OrderDirection, nulls: NullsPosition, ) -> Self

Order by a column with explicit nulls positioning.

fn limit(self, count: i64) -> Self

Limit the number of rows returned.

fn range(self, from: i64, to: i64) -> Self

Set the range of rows to return (offset..offset+limit).

fn single(self) -> Self

Expect exactly one row. Returns error if 0 or >1 rows.

fn maybe_single(self) -> Self

Expect zero or one row. Returns error if >1 rows.

fn count(self) -> Self

Request an exact row count.

fn count_option(self, option: CountOption) -> Self

Request a row count with a specific counting strategy.