Changes between Version 8 and Version 9 of DatabaseProgramming


Ignore:
Timestamp:
04/30/26 14:52:40 (2 days ago)
Author:
231027
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseProgramming

    v8 v9  
    250250
    251251}}}
     252
     253== Тестирање на `fn_check_resource_availability`, `proc_create_full_event`
     254
     255{{{
     256
     257-- reset system counter
     258SELECT setval(pg_get_serial_sequence('"Event"', 'event_id'), COALESCE(MAX(event_id), 1)) FROM "Event";
     259
     260-- -- create an event happening from 20:00 to 22:00 in the venue with venue_id 1
     261CALL proc_create_full_event('Test Concert 1', 12, 1, 1, '2026-05-20 20:00:00', 120);
     262
     263-- -- create another event happening from 21:00 to 23:00 in the same venue
     264CALL proc_create_full_event('Test Concert 2', 12, 1, 2, '2026-05-20 21:00:00', 120);
     265
     266}}}