Changes between Version 6 and Version 7 of Testing and Validation

Timestamp:

05/19/26 00:23:59 (8 days ago)

Author:

193284

Comment:

--

Testing and Validation

@@ -168 +168 @@
 Returns FALSE if the band already has a conflicting booking.
 
-== 6. Wedding Financial Summary View Test ==
+== 6. Photographer Overlap Validation Test ==
+
+=== SQL Code ===
+
+{{{
+#!sql
+SELECT is_photographer_available(
+    1,
+    '2026-06-20',
+    '19:00',
+    '21:00'
+);
+}}}
+
+=== Expected Result ===
+
+Returns FALSE because the requested interval overlaps with an existing photographer booking.
+
+== 7. Band Overlap Validation Test ==
+
+=== SQL Code ===
+
+{{{
+#!sql
+SELECT is_band_available(
+    1,
+    '2026-06-20',
+    '17:00',
+    '23:00'
+);
+}}}
+
+=== Expected Result ===
+
+Returns FALSE because the requested interval overlaps with an existing band booking.
+
+== 8. Wedding Financial Summary View Test ==
 
 === SQL Code ===
@@ -182 +218 @@
 Displays wedding budget information, total booking expenses, and remaining budget calculations.
 
-== 7. RSVP Overview View Test ==
+== 9. RSVP Overview View Test ==
 
 === SQL Code ===
@@ -196 +232 @@
 Displays grouped RSVP statistics for guests and events.
 
-== 8. Vendor Booking Overview View Test ==
+== 10. Vendor Booking Overview View Test ==
 
 === SQL Code ===
@@ -210 +246 @@
 Displays venue, photographer, and band booking information for weddings.
 
-== 9. Upcoming Weddings View Test ==
+== 11. Upcoming Weddings View Test ==
 
 === SQL Code ===
@@ -224 +260 @@
 Displays weddings scheduled for future dates only.
 
-== 10. RSVP Summary Procedure Test ==
+== 12. RSVP Summary Procedure Test ==
 
 === SQL Code ===
@@ -237 +273 @@
 Displays NOTICE messages containing accepted, declined, and pending RSVP counts for the selected event.
 
-== 11. Constraint Validation Test ==
+== 13. Constraint Validation Test ==
 
 === SQL Code ===