Changes between Version 6 and Version 7 of DatabaseCreation

Timestamp:

05/22/26 15:29:58 (4 days ago)

Author:

231055

Comment:

--

DatabaseCreation

@@ -1236 +1236 @@
             END LOOP;
 
+        -- ===========================================================
+        --  FLOW 5: ACCEPTED / IN_PROGRESS rides
+        --  Poraki: 1→2→4
+        --  Voznjata e vo tek, nema kraj i plakjanje uste
+        -- ===========================================================
+        FOR b IN 1..batches LOOP
+                INSERT INTO Notifications (message_id, sent_time, user_id, ride_id, status_id)
+                SELECT * FROM (
+
+                                  -- Poraka 1: Baranjeto isprateno → request_time
+                                  SELECT mid_1, r.request_time, r.user_id, r.ride_id, sid_notif_sent
+                                  FROM Rides r
+                                  WHERE r.ride_id BETWEEN (b-1)*batch_size+1 AND b*batch_size
+                                    AND r.status_id IN (rid_accepted, rid_in_progress)
+
+                                  UNION ALL
+
+                                  -- Poraka 2: Vozacot prifati → pickup_time
+                                  SELECT mid_2, r.pickup_time, r.user_id, r.ride_id, sid_notif_sent
+                                  FROM Rides r
+                                  WHERE r.ride_id BETWEEN (b-1)*batch_size+1 AND b*batch_size
+                                    AND r.status_id IN (rid_accepted, rid_in_progress)
+
+                                  UNION ALL
+
+                                  -- Poraka 4: Vozacot pristigna → start_time
+                                  SELECT mid_4, r.start_time, r.user_id, r.ride_id, sid_notif_sent
+                                  FROM Rides r
+                                  WHERE r.ride_id BETWEEN (b-1)*batch_size+1 AND b*batch_size
+                                    AND r.status_id IN (rid_accepted, rid_in_progress)
+
+                              ) flows;
+
+                RAISE NOTICE '[ACCEPTED/IN_PROGRESS] Batch % / %', b, batches;
+            END LOOP;
+
+        -- ===========================================================
+        --  FLOW 6: REQUESTED rides
+        --  Poraka: samo 1
+        --  Barano no vozac uste ne odgovoril
+        -- ===========================================================
+        FOR b IN 1..batches LOOP
+                INSERT INTO Notifications (message_id, sent_time, user_id, ride_id, status_id)
+
+                -- Poraka 1: Baranjeto isprateno → request_time
+                SELECT mid_1, r.request_time, r.user_id, r.ride_id, sid_notif_sent
+                FROM Rides r
+                WHERE r.ride_id BETWEEN (b-1)*batch_size+1 AND b*batch_size
+                  AND r.status_id = rid_requested;
+
+                RAISE NOTICE '[REQUESTED] Batch % / %', b, batches;
+            END LOOP;
         RAISE NOTICE '*** GOTOVO: SITE NOTIFICATIONS SE GENERIRANI ***';
     END $$;