Changeset 765e166

Timestamp:

02/20/26 17:36:58 (5 months ago)

Author:

Filip Gavrilovski <filipgavrilovski28@…>

Branches:

main

Children:

947fcaa

Parents:

ed8f998

Message:

change event model to be consistent with database v3; fix song repository bug

Location:

finkwave/src/main/java/com/ukim/finki/develop/finkwave

Files:

• model/Event.java (modified) (1 diff)
• repository/SongRepository.java (modified) (1 diff)

finkwave/src/main/java/com/ukim/finki/develop/finkwave/model/Event.java

@@ -36 +36 @@
     @ManyToOne(fetch = FetchType.LAZY)
     @OnDelete(action = OnDeleteAction.CASCADE)
-    @JoinColumn(name = "creator_artist_id")
-    private Artist creatorArtist;
-
-    @ManyToOne(fetch = FetchType.LAZY)
-    @OnDelete(action = OnDeleteAction.CASCADE)
-    @JoinColumn(name = "creator_admin_id")
-    private Admin creatorAdmin;
-
+    @JoinColumn(name = "creator_id")
+    private User creatorUser;
 }

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

@@ -80 +80 @@
 
     @Query("""
-        SELECT NEW com.ukim.finki.develop.finkwave.model.dto.SongDto(
-            s.id,
-            s.musicalEntities.title,
-            s.musicalEntities.genre,
-            'SONG',
-            s.musicalEntities.releasedBy.nonAdminUser.user.fullName,
-            s.musicalEntities.releasedBy.nonAdminUser.user.username,
-            s.musicalEntities.cover,
-            (EXISTS (SELECT 1 FROM Like l WHERE l.musicalEntity.id = s.id AND l.listener.id = :currentUserId)),
-            s.album.musicalEntities.title,
-            s.album.musicalEntities.id,
-            s.link
-        )
-        FROM Song s
-        WHERE s.musicalEntities.title ILIKE '%' || :searchTerm || '%'
-    """)
+    SELECT NEW com.ukim.finki.develop.finkwave.model.dto.SongDto(
+        s.id,
+        me.title,
+        me.genre,
+        'SONG',
+        u.fullName,
+        u.username,
+        me.cover,
+        (EXISTS (
+            SELECT 1 FROM Like l
+            WHERE l.musicalEntity.id = s.id
+              AND l.listener.id = :currentUserId
+        )),
+        albumMe.title,
+        a.id,
+        s.link
+    )
+    FROM Song s
+    JOIN s.musicalEntities me
+    JOIN me.releasedBy rb
+    JOIN rb.nonAdminUser nau
+    JOIN nau.user u
+    LEFT JOIN s.album a
+    LEFT JOIN a.musicalEntities albumMe
+    WHERE me.title ILIKE CONCAT('%', :searchTerm, '%')
+""")
     List<SongDto> searchSongs(@Param("currentUserId")Long currentUserId, @Param("searchTerm") String searchTerm);