Changes between Version 7 and Version 8 of DatabaseProgramming

Timestamp:

04/30/26 14:47:37 (2 days ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -108 +108 @@
 DECLARE v_eid BIGINT; v_hid BIGINT;
 BEGIN
-    IF NOT fn_check_resource_availability('VENUE', p_ven_id, p_time, p_dur) THEN RAISE EXCEPTION 'Venue is already booked for this time'; END IF;
-    INSERT INTO "Event" (name, min_age) VALUES (p_name, p_age) RETURNING event_id INTO v_eid;
-    INSERT INTO "Event_Happening" (event_id, venue_id, event_time, duration) VALUES (v_eid, p_ven_id, p_time, p_dur) RETURNING event_happening_id INTO v_hid;
-    INSERT INTO "Event_Happening_Performer" (event_happening_id, performer_id) VALUES (v_hid, p_perf_id);
+    IF NOT fn_check_resource_availability('VENUE', p_ven_id, p_time, p_dur) THEN 
+        RAISE EXCEPTION 'Venue is already booked for this time'; 
+    END IF;
+
+    INSERT INTO "Event" (name, description, min_age) 
+    VALUES (p_name, 'No description provided', p_age) 
+    RETURNING event_id INTO v_eid;
+
+    INSERT INTO "Event_Happening" (event_id, venue_id, event_time, duration) 
+    VALUES (v_eid, p_ven_id, p_time, p_dur) 
+    RETURNING event_happening_id INTO v_hid;
+
+    INSERT INTO "Event_Happening_Performer" (event_happening_id, performer_id) 
+    VALUES (v_hid, p_perf_id);
 END; $$ LANGUAGE plpgsql;