| commit | 070c05afe8c9d9a5b390577fb704fbe4cf7aeec8 | [log] [tgz] |
|---|---|---|
| author | 夜雨声烦 <xxi13552467509@163.com> | Tue May 13 20:33:50 2025 +0800 |
| committer | 夜雨声烦 <xxi13552467509@163.com> | Tue May 13 20:33:50 2025 +0800 |
| tree | c9ce89b617054e0c1095446efae539e790645356 | |
| parent | f995a44e9e2877c6370c0a80804a5dfea7ce8976 [diff] [blame] | |
| parent | e73ff92d7fae2d77ab4dd1eef03ea098ae4a6cc1 [diff] [blame] |
post_rating Change-Id: Ia1a6fb3f87b793a6307046e36951c1fb36b213c8
diff --git a/src/main/java/com/example/g8backend/mapper/PostMapper.java b/src/main/java/com/example/g8backend/mapper/PostMapper.java index baebb17..ff13000 100644 --- a/src/main/java/com/example/g8backend/mapper/PostMapper.java +++ b/src/main/java/com/example/g8backend/mapper/PostMapper.java
@@ -64,4 +64,11 @@ "</script>" }) int batchUpdateHotScore(@Param("posts") List<Post> posts); + + @Update("UPDATE posts SET average_rating = #{averageRating}, rating_count = #{ratingCount} WHERE post_id = #{postId}") + void updateRatingStats( + @Param("postId") Long postId, + @Param("averageRating") Double averageRating, + @Param("ratingCount") Integer ratingCount + ); } \ No newline at end of file