Struct Insert

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

Performs INSERT operations on a ActiveModel

Implementations

impl<A> Insert<A>

where A: ActiveModelTrait,

pub fn exec<'a, C>( self, db: &'a C, ) -> impl Future<Output = Result<InsertResult<A>, DbErr>> + 'a

where C: ConnectionTrait, A: 'a,

Execute an insert operation

pub fn exec_without_returning<'a, C>( self, db: &'a C, ) -> impl Future<Output = Result<u64, DbErr>> + 'a

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

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

pub fn exec_with_returning<'a, C>( self, db: &'a C, ) -> impl Future<Output = Result<<<A as ActiveModelTrait>::Entity as EntityTrait>::Model, DbErr>> + 'a

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

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

• To get back all inserted models, use [exec_with_returning_many].
• To get back all inserted primary keys, use [exec_with_returning_keys].

pub fn exec_with_returning_keys<'a, C>( self, db: &'a C, ) -> impl Future<Output = Result<Vec<<<<A as ActiveModelTrait>::Entity as EntityTrait>::PrimaryKey as PrimaryKeyTrait>::ValueType>, DbErr>> + 'a

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

Execute an insert operation and return primary keys of inserted models

Panics

Panics if the database backend does not support INSERT RETURNING.

pub fn exec_with_returning_many<'a, C>( self, db: &'a C, ) -> impl Future<Output = Result<Vec<<<A as ActiveModelTrait>::Entity as EntityTrait>::Model>, DbErr>> + 'a

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

Execute an insert operation and return all inserted models

Panics

Panics if the database backend does not support INSERT RETURNING.

impl<A> Insert<A>

where A: ActiveModelTrait,

pub fn one<M>(m: M) -> Insert<A>

where M: IntoActiveModel<A>,

Insert one Model or ActiveModel

Model

use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};

assert_eq!(
    Insert::one(cake::Model {
        id: 1,
        name: "Apple Pie".to_owned(),
    })
    .build(DbBackend::Postgres)
    .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie')"#,
);

ActiveModel

use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};

assert_eq!(
    Insert::one(cake::ActiveModel {
        id: NotSet,
        name: Set("Apple Pie".to_owned()),
    })
    .build(DbBackend::Postgres)
    .to_string(),
    r#"INSERT INTO "cake" ("name") VALUES ('Apple Pie')"#,
);

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

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

Insert many Model or ActiveModel

use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};

assert_eq!(
    Insert::many([
        cake::Model {
            id: 1,
            name: "Apple Pie".to_owned(),
        },
        cake::Model {
            id: 2,
            name: "Orange Scone".to_owned(),
        }
    ])
    .build(DbBackend::Postgres)
    .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie'), (2, 'Orange Scone')"#,
);

pub fn add<M>(self, m: M) -> Insert<A>

where M: IntoActiveModel<A>,

Add a Model to Self

Panics

Panics if the rows have different column sets from what’ve previously been cached in the query statement

pub fn add_multi<M, I>(self, models: I) -> Insert<A>

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

👎Deprecated since 1.1.3: Please use [Insert::add_many] which does not panic

Add many Models to Self. This is the legacy implementation priori to 1.1.3.

Panics

Panics if the rows have different column sets

pub fn add_many<M, I>(self, models: I) -> Insert<A>

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

Add many Models to Self

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

On conflict

on conflict do nothing

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)
        .on_conflict(
            OnConflict::column(cake::Column::Name)
                .do_nothing()
                .to_owned()
        )
        .build(DbBackend::Postgres)
        .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO NOTHING"#,
);

on conflict do update

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)
        .on_conflict(
            OnConflict::column(cake::Column::Name)
                .update_column(cake::Column::Name)
                .to_owned()
        )
        .build(DbBackend::Postgres)
        .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO UPDATE SET "name" = "excluded"."name""#,
);

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

where A: ActiveModelTrait,

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

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

where A: ActiveModelTrait,

Alias to 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.

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()
        .build(DbBackend::MySql)
        .to_string(),
    r#"INSERT INTO `cake` (`id`, `name`) VALUES (2, 'Orange') ON DUPLICATE KEY UPDATE `id` = `id`"#,
);
assert_eq!(
    cake::Entity::insert(orange.clone())
        .on_conflict_do_nothing()
        .build(DbBackend::Postgres)
        .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("id") DO NOTHING"#,
);
assert_eq!(
    cake::Entity::insert(orange)
        .on_conflict_do_nothing()
        .build(DbBackend::Sqlite)
        .to_string(),
    r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("id") DO NOTHING"#,
);

Trait Implementations

impl<A> Debug for Insert<A>

where A: Debug + ActiveModelTrait,

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

Formats the value using the given formatter.

impl<A> Default for Insert<A>

where A: ActiveModelTrait,

fn default() -> Insert<A>

Returns the “default value” for a type.

impl<A> QueryTrait for Insert<A>

where A: ActiveModelTrait,

type QueryStatement = InsertStatement

Constrain the QueryStatement to QueryStatementBuilder 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: DatabaseBackend) -> 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(_)