MySQL insert on conflict do nothing #2244
Conversation
src/query/insert.rs
Outdated
| pub fn from_insert(mut insert: Insert<A>) -> Self { | ||
| let primary_keys = <A::Entity as EntityTrait>::PrimaryKey::iter(); | ||
| insert.query.on_conflict( | ||
| OnConflict::columns(primary_keys.clone()) | ||
| .do_nothing_on(primary_keys) | ||
| .to_owned(), | ||
| ); | ||
|
|
There was a problem hiding this comment.
I don't think this code belongs here. on_empty_do_nothing does not mean on_conflict_do_nothing. on_empty_do_nothing simply allows us to insert empty array.
we can create a method for on_conflict_do_nothing that specifically means on PK conflict
🎉 Released In 1.0.0-rc.6 🎉Thank you everyone for the contribution! |
🎉 Released In 1.0.0 🎉Thank you everyone for the contribution! |
PR Info
New Features
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html