Changes between Version 20 and Version 21 of AdvancedApplicationDevelopment

Timestamp:

09/30/25 09:24:44 (2 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -290 +290 @@
 }}}
 
+5. Селектира дестинации по score, користејќи ја функцијата destination_score(id_destination) и потоа ги сортира дестинациите од највисок score кон најнизок. Со LIMIT 5 се избираат само топ 5 дестинации со највисок score.  
+{{{
+CREATE OR REPLACE PROCEDURE recommend_top_destinations(p_user INT)
+LANGUAGE plpgsql AS $$
+DECLARE
+    dest RECORD;
+BEGIN
+    FOR dest IN
+        SELECT id_destination
+        FROM destination
+        ORDER BY destination_score(id_destination) DESC
+        LIMIT 5
+    LOOP
+        INSERT INTO destination_user(id_user, id_destination, recommendation_date)
+        VALUES (p_user, dest.id_destination, NOW());
+    END LOOP;
+END;
+$$;
+
+}}}
+
 
 === Релациска алгебра