Struct TryInsert 

pub struct TryInsert<A>
where
    A: ActiveModelTrait,
{ /* private fields */ }

Wrapper of Insert / InsertMany, treats “no row inserted/id returned” as a normal outcome.

Its exec* methods return crate::TryInsertResult. Mapping empty input to crate::TryInsertResult::Empty (no SQL executed) and DbErr::RecordNotInserted to crate::TryInsertResult::Conflicted.

Useful for idempotent inserts such as ON CONFLICT ... DO NOTHING (Postgres / SQLite) or the MySQL polyfill (ON DUPLICATE KEY UPDATE pk = pk).

Implementations

impl<A> TryInsert<A>

where A: ActiveModelTrait,

pub async fn exec<C>( self, db: &C, ) -> Result<TryInsertResult<InsertResult<A>>, DbErr>

where C: ConnectionTrait,

Execute an insert operation

pub async fn exec_without_returning<C>( self, db: &C, ) -> Result<TryInsertResult<u64>, DbErr>

where C: ConnectionTrait,

Execute an insert operation without returning (don’t use RETURNING syntax) Number of rows affected is returned

pub async fn exec_with_returning<C>( self, db: &C, ) -> Result<TryInsertResult<<A::Entity as EntityTrait>::Model>, DbErr>

where <A::Entity as EntityTrait>::Model: IntoActiveModel<A>, C: ConnectionTrait,

Execute an insert operation and return the inserted model (use RETURNING syntax if supported)

pub async fn exec_with_returning_keys<C>( self, db: &C, ) -> Result<TryInsertResult<Vec<<<<A as ActiveModelTrait>::Entity as EntityTrait>::PrimaryKey as PrimaryKeyTrait>::ValueType>>, DbErr>

where <A::Entity as EntityTrait>::Model: IntoActiveModel<A>, C: ConnectionTrait,

Execute an insert operation and return primary keys of inserted models

pub async fn exec_with_returning_many<C>( self, db: &C, ) -> Result<TryInsertResult<Vec<<A::Entity as EntityTrait>::Model>>, DbErr>

where <A::Entity as EntityTrait>::Model: IntoActiveModel<A>, C: ConnectionTrait,

Execute an insert operation and return all inserted models

impl<A> TryInsert<A>

where A: ActiveModelTrait,

pub fn one<M>(m: M) -> Self

where M: IntoActiveModel<A>,

Try insert one item

pub fn many<M, I>(models: I) -> Self

where M: IntoActiveModel<A>, I: IntoIterator<Item = M>,

Try insert many items

pub fn on_conflict(self, on_conflict: OnConflict) -> Insert<A>

Set ON CONFLICT logic

pub fn on_conflict_do_nothing(self) -> Self

Set ON CONFLICT on primary key do nothing, but with MySQL specific polyfill.

pub fn on_conflict_do_nothing_on<I>(self, columns: I) -> Self

where I: IntoIterator<Item = <A::Entity as EntityTrait>::Column>,

Set ON CONFLICT do nothing, but with MySQL specific polyfill.

Trait Implementations

impl<A> Debug for TryInsert<A>

where A: ActiveModelTrait + Debug,

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

Formats the value using the given formatter.

impl<A> QueryTrait for TryInsert<A>

where A: ActiveModelTrait,

type QueryStatement = InsertStatement

Constrain the QueryStatement to StatementBuilder trait

fn query(&mut self) -> &mut InsertStatement

Get a mutable ref to the query builder

fn as_query(&self) -> &InsertStatement

Get an immutable ref to the query builder

fn into_query(self) -> InsertStatement

Take ownership of the query builder

fn build(&self, db_backend: DbBackend) -> Statement

Build the query as Statement

fn apply_if<T, F>(self, val: Option<T>, if_some: F) -> Self

where Self: Sized, F: FnOnce(Self, T) -> Self,

Apply an operation on the QueryTrait::QueryStatement if the given Option<T> is Some(_)