Changes between Version 23 and Version 24 of DatabaseProgramming

Timestamp:

06/14/26 15:05:22 (38 hours ago)

Author:

231028

Comment:

--

DatabaseProgramming

@@ -188 +188 @@
 as $$
     begin
+        if not exists(
+            select 1
+            from Ride r
+            join Request req on r.request_id=req.id
+            where r.id=id_ride and req.customer_user_id=id_customer
+        )
+        then
+            raise exception 'Customer can not give a rating on a ride they do not have.';
+        end if;
         insert into review (rating, comment, ride_id, customer_user_id)
         values (write_rating.rating,write_rating.comment,id_ride,id_customer);
@@ -203 +212 @@
 as $$
     begin
+        if not exists(
+            select 1
+            from Ride r
+            join Request req on r.request_id=req.id
+            where r.id=id_ride and req.customer_user_id=id_user
+        )
+        then
+            raise exception 'User can not write a chat for a ride they do not have.';
+        end if;
         insert into chatmessage(message, user_id_from, ride_id)
         values (new_message,id_user,id_ride);
@@ -218 +236 @@
 as $$
     begin
+        if not exists(
+            select 1
+            from Ride r
+            join Request req on r.request_id=req.id
+            where r.id=id_ride and req.customer_user_id=user_id
+        )
+        then
+            raise exception 'Customer can not write a report on a ride they do not have.';
+        end if;
         insert into report(ride_id, customer_user_id, message, title, latitude, longitude, reason)
         values (id_ride,user_id,new_message,new_title,temp_latitude,temp_long,new_reason);