Changes between Version 6 and Version 7 of DatabaseProgramming

Timestamp:

04/30/26 14:40:50 (2 days ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -225 +225 @@
 
 }}}
+
+== Тестирање на `trg_buy_age`, `func_age_gate`, `proc_execute_purchase`
+
+{{{
+
+-- get the user_id of a user who is under 18
+SELECT user_id FROM "User" WHERE date_of_birth > '2010-01-01' LIMIT 1;  -- 1081
+
+-- get the event_id of an event whose min_age is 18
+SELECT event_id FROM "Event" WHERE min_age = 18 LIMIT 1;    -- 5
+
+-- try to make the user under 18 buy a ticket for a happening of the event whose min entrance age is 18
+CALL proc_execute_purchase(1081, 5, 'QR-FAIL');
+
+}}}