Changes between Version 31 and Version 32 of DatabaseProgramming

Timestamp:

07/01/26 15:38:41 (4 days ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -85 +85 @@
     v_qr_code   TEXT;
     v_order_id  BIGINT;
-    v_active    BOOLEAN;
-BEGIN
-    SELECT is_active INTO v_active FROM "User" WHERE user_id = p_user_id;
-    IF v_active IS NOT TRUE THEN
-        RAISE EXCEPTION 'Access Denied: User is inactive.';
-    END IF;
-
+BEGIN
     v_price := get_current_price(p_ticket_id);
     v_qr_code := 'QR-' || p_ticket_id || '-' || p_user_id || '-' || EXTRACT(EPOCH FROM NOW());
@@ -163 +157 @@
 DECLARE
     v_happening_id BIGINT;
-    v_active       BOOLEAN;
-BEGIN
-    IF NOT EXISTS (SELECT 1 FROM "Admin" WHERE user_id = p_admin_id) THEN
-        RAISE EXCEPTION 'Access Denied: Not an admin.';
-    END IF;
-
-    SELECT is_active INTO v_active FROM "Event" WHERE event_id = p_event_id;
-    IF v_active IS NOT TRUE THEN
-        RAISE EXCEPTION 'Cannot schedule for an inactive event.';
-    END IF;
-
+BEGIN
     INSERT INTO "Event_Happening" (event_id, event_time, venue_id, duration_minutes, organizers)
     VALUES (p_event_id, p_time, p_venue_id, p_duration_minutes, 'System Generated')
@@ -233 +217 @@
 AS $$
 DECLARE
-    v_active    BOOLEAN;
     v_user_age  INT;
     v_min_age   INT;
@@ -239 +222 @@
 BEGIN
     SELECT user_id INTO v_user_id FROM "Ticket_Order" WHERE order_id = NEW.order_id;
-    SELECT is_active INTO v_active FROM "User" WHERE user_id = v_user_id;
-
-    IF v_active IS NOT TRUE THEN
-        RAISE EXCEPTION 'User is inactive.';
-    END IF;
 
     SELECT DATE_PART('year', AGE(date_of_birth))