pub struct IncompleteOnConflict<Stmt, Target> { /* private fields */ }
Expand description
A partially constructed ON CONFLICT
clause.
Implementations
sourceimpl<T, U, Op, Ret, Target> IncompleteOnConflict<InsertStatement<T, U, Op, Ret>, Target>
impl<T, 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.
sourceimpl<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::pg::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));
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
sourceimpl<Stmt: Clone, Target: Clone> Clone for IncompleteOnConflict<Stmt, Target>
impl<Stmt: Clone, Target: Clone> Clone for IncompleteOnConflict<Stmt, Target>
sourcefn clone(&self) -> IncompleteOnConflict<Stmt, Target>
fn clone(&self) -> IncompleteOnConflict<Stmt, Target>
Returns a copy of the value. Read more
1.0.0 · sourcefn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
Performs copy-assignment from source
. Read more
sourceimpl<Stmt: Debug, Target: Debug> Debug for IncompleteOnConflict<Stmt, Target>
impl<Stmt: Debug, Target: Debug> Debug for IncompleteOnConflict<Stmt, Target>
impl<Stmt: Copy, Target: Copy> Copy for IncompleteOnConflict<Stmt, Target>
Auto Trait Implementations
impl<Stmt, Target> RefUnwindSafe for IncompleteOnConflict<Stmt, Target> where
Stmt: RefUnwindSafe,
Target: RefUnwindSafe,
impl<Stmt, Target> Send for IncompleteOnConflict<Stmt, Target> where
Stmt: Send,
Target: Send,
impl<Stmt, Target> Sync for IncompleteOnConflict<Stmt, Target> where
Stmt: Sync,
Target: Sync,
impl<Stmt, Target> Unpin for IncompleteOnConflict<Stmt, Target> where
Stmt: Unpin,
Target: Unpin,
impl<Stmt, Target> UnwindSafe for IncompleteOnConflict<Stmt, Target> where
Stmt: UnwindSafe,
Target: UnwindSafe,
Blanket Implementations
sourceimpl<T> BorrowMut<T> for T where
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
const: unstable · sourcepub fn borrow_mut(&mut self) -> &mut T
pub fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
sourceimpl<T> IntoSql for T
impl<T> IntoSql for T
sourceimpl<T> ToOwned for T where
T: Clone,
impl<T> ToOwned for T where
T: Clone,
type Owned = T
type Owned = T
The resulting type after obtaining ownership.
sourcepub fn to_owned(&self) -> T
pub fn to_owned(&self) -> T
Creates owned data from borrowed data, usually by cloning. Read more
sourcepub fn clone_into(&self, target: &mut T)
pub fn clone_into(&self, target: &mut T)
toowned_clone_into
)Uses borrowed data to replace owned data, usually by cloning. Read more