Merge branch 'main' into move_views_to_diesel

[lemmy.git] / lemmy_db / src / source / comment.rs

diff --git a/lemmy_db/src/source/comment.rs b/lemmy_db/src/source/comment.rs
index 239762599a010e4156c773660aab68ffb4dc860e..380bdb3d157db6b1a259cc81dcf8416549c3cfa3 100644 (file)
--- a/lemmy_db/src/source/comment.rs
+++ b/lemmy_db/src/source/comment.rs
@@ -228,6 +228,9 @@ impl Likeable<CommentLikeForm> for CommentLike {
     use crate::schema::comment_like::dsl::*;
     insert_into(comment_like)
       .values(comment_like_form)
+      .on_conflict((comment_id, user_id))
+      .do_update()
+      .set(comment_like_form)
       .get_result::<Self>(conn)
   }
   fn remove(conn: &PgConnection, user_id: i32, comment_id: i32) -> Result<usize, Error> {
@@ -263,6 +266,9 @@ impl Saveable<CommentSavedForm> for CommentSaved {
     use crate::schema::comment_saved::dsl::*;
     insert_into(comment_saved)
       .values(comment_saved_form)
+      .on_conflict((comment_id, user_id))
+      .do_update()
+      .set(comment_saved_form)
       .get_result::<Self>(conn)
   }
   fn unsave(conn: &PgConnection, comment_saved_form: &CommentSavedForm) -> Result<usize, Error> {