Struct diesel::upsert::IncompleteOnConflict
source · pub struct IncompleteOnConflict<Stmt, Target> { /* private fields */ }
Expand description
A partially constructed ON CONFLICT
clause.
Implementations§
source§impl<T: QuerySource, U, Op, Ret, Target> IncompleteOnConflict<InsertStatement<T, U, Op, Ret>, Target>
impl<T: QuerySource, U, Op, Ret, Target> IncompleteOnConflict<InsertStatement<T, U, Op, Ret>, Target>
sourcepub fn do_nothing(
self,
) -> InsertStatement<T, OnConflictValues<U, Target, DoNothing>, Op, Ret>
pub fn do_nothing( self, ) -> InsertStatement<T, OnConflictValues<U, Target, DoNothing>, Op, Ret>
Creates a query with ON CONFLICT (target) DO NOTHING
If you want to do nothing when any constraint conflicts, use
on_conflict_do_nothing
instead. See on_conflict
for usage
examples.
source§impl<Stmt, Target> IncompleteOnConflict<Stmt, Target>
impl<Stmt, Target> IncompleteOnConflict<Stmt, Target>
sourcepub fn do_update(self) -> IncompleteDoUpdate<Stmt, Target>
pub fn do_update(self) -> IncompleteDoUpdate<Stmt, Target>
Used to create a query in the form ON CONFLICT (...) DO UPDATE ...
Call .set
on the result of this function with the changes you want to
apply. The argument to set
can be anything that implements AsChangeset
(e.g. anything you could pass to set
on a normal update statement).
Note: When inserting more than one row at a time, this query can still fail if the rows being inserted conflict with each other.
§Examples
§Set specific value on conflict
let user = User { id: 1, name: "Pascal" };
let user2 = User { id: 1, name: "Sean" };
assert_eq!(Ok(1), diesel::insert_into(users).values(&user).execute(conn));
let insert_count = diesel::insert_into(users)
.values(&user2)
.on_conflict(id)
.do_update()
.set(name.eq("I DONT KNOW ANYMORE"))
.execute(conn);
assert_eq!(Ok(1), insert_count);
let users_in_db = users.load(conn);
assert_eq!(Ok(vec![(1, "I DONT KNOW ANYMORE".to_string())]), users_in_db);
§Set AsChangeset
struct on conflict
let user = User { id: 1, name: "Pascal" };
let user2 = User { id: 1, name: "Sean" };
assert_eq!(Ok(1), diesel::insert_into(users).values(&user).execute(conn));
let insert_count = diesel::insert_into(users)
.values(&user2)
.on_conflict(id)
.do_update()
.set(&user2)
.execute(conn);
assert_eq!(Ok(1), insert_count);
let users_in_db = users.load(conn);
assert_eq!(Ok(vec![(1, "Sean".to_string())]), users_in_db);
§Use excluded
to get the rejected value
use diesel::upsert::excluded;
let user = User { id: 1, name: "Pascal" };
let user2 = User { id: 1, name: "Sean" };
let user3 = User { id: 2, name: "Tess" };
assert_eq!(Ok(1), diesel::insert_into(users).values(&user).execute(conn));
#[cfg(feature = "postgres")]
let insert_count = diesel::insert_into(users)
.values(&vec![user2, user3])
.on_conflict(id)
.do_update()
.set(name.eq(excluded(name)))
.execute(conn);
assert_eq!(Ok(2), insert_count);
let users_in_db = users.load(conn);
assert_eq!(Ok(vec![(1, "Sean".to_string()), (2, "Tess".to_string())]), users_in_db);
Trait Implementations§
source§impl<Stmt: Clone, Target: Clone> Clone for IncompleteOnConflict<Stmt, Target>
impl<Stmt: Clone, Target: Clone> Clone for IncompleteOnConflict<Stmt, Target>
source§fn clone(&self) -> IncompleteOnConflict<Stmt, Target>
fn clone(&self) -> IncompleteOnConflict<Stmt, Target>
Returns a copy of the value. Read more
1.0.0 · source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
Performs copy-assignment from
source
. Read moresource§impl<Stmt, T, P> DecoratableTarget<P> for IncompleteOnConflict<Stmt, T>
impl<Stmt, T, P> DecoratableTarget<P> for IncompleteOnConflict<Stmt, T>
§type FilterOutput = IncompleteOnConflict<Stmt, <T as DecoratableTarget<P>>::FilterOutput>
type FilterOutput = IncompleteOnConflict<Stmt, <T as DecoratableTarget<P>>::FilterOutput>
Output type of filter_target operation
source§fn filter_target(self, predicate: P) -> Self::FilterOutput
fn filter_target(self, predicate: P) -> Self::FilterOutput
equivalent to filter of FilterDsl but aimed at conflict targets
impl<Stmt: Copy, Target: Copy> Copy for IncompleteOnConflict<Stmt, Target>
Auto Trait Implementations§
impl<Stmt, Target> Freeze for IncompleteOnConflict<Stmt, Target>
impl<Stmt, Target> RefUnwindSafe for IncompleteOnConflict<Stmt, Target>where
Stmt: RefUnwindSafe,
Target: RefUnwindSafe,
impl<Stmt, Target> Send for IncompleteOnConflict<Stmt, Target>
impl<Stmt, Target> Sync for IncompleteOnConflict<Stmt, Target>
impl<Stmt, Target> Unpin for IncompleteOnConflict<Stmt, Target>
impl<Stmt, Target> UnwindSafe for IncompleteOnConflict<Stmt, Target>where
Stmt: UnwindSafe,
Target: UnwindSafe,
Blanket Implementations§
source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
source§impl<T> CloneToUninit for Twhere
T: Copy,
impl<T> CloneToUninit for Twhere
T: Copy,
source§unsafe fn clone_to_uninit(&self, dst: *mut T)
unsafe fn clone_to_uninit(&self, dst: *mut T)
🔬This is a nightly-only experimental API. (
clone_to_uninit
)source§impl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
source§default unsafe fn clone_to_uninit(&self, dst: *mut T)
default unsafe fn clone_to_uninit(&self, dst: *mut T)
🔬This is a nightly-only experimental API. (
clone_to_uninit
)