Changes between Version 4 and Version 5 of DatabaseProgramming-AdvDb

Timestamp:

06/07/26 15:28:15 (9 days ago)

Author:

231175

Comment:

--

DatabaseProgramming-AdvDb

@@ -19 +19 @@
         e_id bigint;
     begin
-        -- Validate rating first, before any DB work
-        if new_rating < 1 or new_rating > 5 then
-            raise exception 'Rating must be between 1 and 5, got %', new_rating
-                using errcode = 'CHECK_VIOLATION';
-        end if;
-
 
         select e.id into e_id
@@ -38 +32 @@
                 using errcode = 'NO_DATA_FOUND';
         end if;
-
-        -- Validate there's no review for that enrollment
-        if exists(select 1 from review rv where rv.enrollment_id = e_id) then
-            raise exception 'Review already submitted for enrollment %', e_id
-                using errcode = 'UNIQUE_VIOLATION';
-        end if;
-
 
         insert into review (rating, comment, date, enrollment_id)