Struct InsertMany 

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

Performs INSERT operations on many ActiveModels

Implementations

impl<A> InsertMany<A>

where A: ActiveModelTrait,

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

where C: ConnectionTrait,

Execute an insert operation

pub async fn exec_without_returning<C>(self, db: &C) -> Result<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<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

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

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

👎Deprecated since 2.0.0: Please use InsertMany::exec_with_returning

Alias to InsertMany::exec_with_returning.

pub async fn exec_with_returning_keys<C>( self, db: &C, ) -> Result<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

impl<A> InsertMany<A>

where A: ActiveModelTrait,

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

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

Insert many Model or ActiveModel

pub fn on_conflict(self, on_conflict: OnConflict) -> Self

Set ON CONFLICT logic

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

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

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

use sea_orm::{entity::*, query::*, sea_query::OnConflict, tests_cfg::cake, DbBackend};
let orange = cake::ActiveModel {
    id: ActiveValue::set(2),
    name: ActiveValue::set("Orange".to_owned()),
};
assert_eq!(
    cake::Entity::insert(orange.clone())
        .on_conflict_do_nothing_on([cake::Column::Name])
        .build(DbBackend::Postgres)
        .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO NOTHING"#,
);
assert_eq!(
    cake::Entity::insert(orange)
        .on_conflict_do_nothing_on([cake::Column::Name])
        .build(DbBackend::MySql)
        .to_string(),
    r#"INSERT INTO `cake` (`id`, `name`) VALUES (2, 'Orange') ON DUPLICATE KEY UPDATE `id` = `id`"#,
);

pub fn do_nothing(self) -> TryInsert<A>

where A: ActiveModelTrait,

👎Deprecated since 2.0.0: Please use TryInsert::many or on_conflict_do_nothing* methods that return TryInsert, or InsertMany::try_insert

Allow insert statement to return without error if nothing’s been inserted.

pub fn try_insert(self) -> TryInsert<A>

where A: ActiveModelTrait,

Convert self into a TryInsert. It is just a wrapper for converting DbErr::RecordNotInserted -> TryInsertResult::Conflicted.

pub fn on_empty_do_nothing(self) -> TryInsert<A>

where A: ActiveModelTrait,

👎Deprecated since 2.0.0: Empty input is already handled by InsertMany::exec (no SQL executed). For conflict handling, use InsertMany::on_conflict_do_nothing or InsertMany::on_conflict_do_nothing_on.

Alias to InsertMany::do_nothing.

pub fn on_conflict_do_nothing(self) -> TryInsert<A>

where A: ActiveModelTrait,

Set ON CONFLICT on primary key do nothing, but with MySQL specific polyfill. See also Insert::on_conflict_do_nothing.

Trait Implementations

impl<A> Debug for InsertMany<A>

where A: ActiveModelTrait + Debug,

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

Formats the value using the given formatter.

impl<A> QueryTrait for InsertMany<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(_)