pub struct Insert<A>where
A: ActiveModelTrait,{ /* private fields */ }
Expand description
Performs INSERT operations on a ActiveModel
Implementations
sourceimpl<A> Insert<A>where
A: ActiveModelTrait,
impl<A> Insert<A>where
A: ActiveModelTrait,
sourcepub fn exec<'a, C>(
self,
db: &'a C
) -> impl Future<Output = Result<InsertResult<A>, DbErr>> + '_where
C: ConnectionTrait,
A: 'a,
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
sourcepub 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,
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)
sourceimpl<A> Insert<A>where
A: ActiveModelTrait,
impl<A> Insert<A>where
A: ActiveModelTrait,
sourcepub fn one<M>(m: M) -> Insert<A>where
M: IntoActiveModel<A>,
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')"#,
);
sourcepub fn many<M, I>(models: I) -> Selfwhere
M: IntoActiveModel<A>,
I: IntoIterator<Item = M>,
pub fn many<M, I>(models: I) -> Selfwhere
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')"#,
);
sourcepub fn add<M>(self, m: M) -> Selfwhere
M: IntoActiveModel<A>,
pub fn add<M>(self, m: M) -> Selfwhere
M: IntoActiveModel<A>,
Add a Model to Self
sourcepub fn add_many<M, I>(self, models: I) -> Selfwhere
M: IntoActiveModel<A>,
I: IntoIterator<Item = M>,
pub fn add_many<M, I>(self, models: I) -> Selfwhere
M: IntoActiveModel<A>,
I: IntoIterator<Item = M>,
Add many Models to Self
sourcepub fn on_conflict(self, on_conflict: OnConflict) -> Self
pub fn on_conflict(self, on_conflict: OnConflict) -> Self
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""#,
);
Trait Implementations
sourceimpl<A: Debug> Debug for Insert<A>where
A: ActiveModelTrait,
impl<A: Debug> Debug for Insert<A>where
A: ActiveModelTrait,
sourceimpl<A> Default for Insert<A>where
A: ActiveModelTrait,
impl<A> Default for Insert<A>where
A: ActiveModelTrait,
sourceimpl<A> QueryTrait for Insert<A>where
A: ActiveModelTrait,
impl<A> QueryTrait for Insert<A>where
A: ActiveModelTrait,
type QueryStatement = InsertStatement
type QueryStatement = InsertStatement
Constrain the QueryStatement to QueryStatementBuilder trait
sourcefn query(&mut self) -> &mut InsertStatement
fn query(&mut self) -> &mut InsertStatement
Get a mutable ref to the query builder
sourcefn as_query(&self) -> &InsertStatement
fn as_query(&self) -> &InsertStatement
Get an immutable ref to the query builder
sourcefn into_query(self) -> InsertStatement
fn into_query(self) -> InsertStatement
Take ownership of the query builder
Auto Trait Implementations
impl<A> !RefUnwindSafe for Insert<A>
impl<A> Send for Insert<A>where
A: Send,
impl<A> Sync for Insert<A>where
A: Sync,
impl<A> Unpin for Insert<A>where
A: Unpin,
impl<A> !UnwindSafe for Insert<A>
Blanket Implementations
sourceimpl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
const: unstable · sourcefn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more