Changeset 03a8d87

Timestamp:

02/08/26 19:57:20 (5 months ago)

Author:

Filip Gavrilovski <filipgavrilovski28@…>

Branches:

main

Children:

890e036

Parents:

a5406e1

Message:

fix another song repository bug (recently listened)

File:

• finkwave/src/main/java/com/ukim/finki/develop/finkwave/repository/SongRepository.java (modified) (1 diff)

finkwave/src/main/java/com/ukim/finki/develop/finkwave/repository/SongRepository.java

@@ -99 +99 @@
 
     @Query(value = """
-        SELECT DISTINCT on (l.song_id)
-            l.song_id,
-            me.title,
-            u.full_name,
-            u.username,
-            s.link,
-            me.cover
-        FROM LISTENS l
-        JOIN MUSICAL_ENTITIES me on me.id = l.song_id
-        JOIN USERS u on u.user_id = me.released_by
-        JOIN SONGS s on s.id = me.id
-        WHERE l.listener_id = :userId
-        ORDER BY l.song_id, l.timestamp DESC
-        LIMIT 5
+        SELECT
+            t.song_id,
+            t.title,
+            t.full_name,
+            t.username,
+            t.link,
+            t.cover
+        FROM (
+                 SELECT DISTINCT ON (l.song_id)
+                     l.song_id,
+                     me.title,
+                     u.full_name,
+                     u.username,
+                     me.cover,
+                     s.link,
+                     l.timestamp
+                 FROM listens l
+                     JOIN musical_entities me ON me.id = l.song_id
+                     JOIN songs s on s.id = l.song_id
+                     JOIN users u ON u.user_id = me.released_by
+                     WHERE l.listener_id = 2
+                 ORDER BY l.song_id, l.timestamp DESC
+             ) t
+        ORDER BY t.timestamp DESC
+        LIMIT 5;
     """, nativeQuery = true)
     List<BasicSongDto> getRecentlyListened(@Param("userId")Long userId);