Changes between Initial Version and Version 1 of Testing and Validation

Timestamp:

05/12/26 01:39:25 (2 weeks ago)

Author:

193284

Comment:

--

Testing and Validation

@@ +1 @@
+= Testing and Validation =
+
+== Description ==
+
+This section contains SQL scenarios used for testing trigger behavior and advanced database validation.
+
+== 1. Venue Booking Conflict Test ==
+
+{{{
+INSERT INTO venue_booking(
+    "date",
+    start_time,
+    end_time,
+    status,
+    price,
+    venue_id,
+    wedding_id
+)
+VALUES (
+    '2026-06-20',
+    '18:00',
+    '22:00',
+    'confirmed',
+    5000,
+    1,
+    1
+);
+}}}
+
+Expected Result:
+The trigger prevents overlapping bookings.
+
+== 2. RSVP Validation Test ==
+
+{{{
+INSERT INTO attendance(
+    status,
+    table_number,
+    role,
+    guest_id,
+    event_id
+)
+VALUES (
+    'attending',
+    3,
+    'Guest',
+    1,
+    1
+);
+}}}
+
+Expected Result:
+Guests who declined RSVP cannot be marked as attending.