Struct sea_orm::query::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>> + '_ where
    C: ConnectionTrait,
    A: 'a, 

Execute an insert operation

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

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

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) -> Self 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(vec![
        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) -> Self where
    M: IntoActiveModel<A>, 

Add a Model to Self

pub fn add_many<M, I>(self, models: I) -> Self where
    M: IntoActiveModel<A>,
    I: IntoIterator<Item = M>, 

Add many Models to Self

Trait Implementations

impl<A: Debug> Debug for Insert<A> where
    A: ActiveModelTrait, 

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

Formats the value using the given formatter.

impl<A> Default for Insert<A> where
    A: ActiveModelTrait, 

fn default() -> Self

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: DbBackend) -> Statement

Build the query as Statement