Changes between Version 1 and Version 2 of функции,процедури,тригери

Timestamp:

05/26/26 15:52:44 (13 hours ago)

Author:

231233

Comment:

--

функции,процедури,тригери

@@ -342 +342 @@
 END;
 $$ LANGUAGE plpgsql;
-CREATE EXTENSION IF NOT EXISTS postgis;
-
-
-
--- Тест процедура 1 — генерирај тикети
-CALL generate_tickets_for_screening(55105026, 350.00);
-
-ALTER TABLE TICKET ALTER COLUMN user_id DROP NOT NULL;
-ALTER TABLE TICKET ALTER COLUMN reservation_id DROP NOT NULL;
-
-SELECT column_name, is_nullable
-FROM information_schema.columns
-WHERE table_name = 'ticket'
-AND column_name IN ('user_id', 'reservation_id');
-
-CALL generate_tickets_for_screening(55105026, 350.00);
-
--- Земи слободен тикет од новата проекција
-SELECT ticket_id FROM TICKET
-WHERE screening_id = 55105026
-AND user_id IS NULL
-LIMIT 1;
-
--- Земи вистински user_id
-SELECT user_id FROM "USER" LIMIT 1;
-
--- Земи вистински reservation_id со статус PENDING
-SELECT reservation_id FROM RESERVATION
-WHERE status = 'PENDING'
-LIMIT 1;
-
--- Земи вистински product_id
-SELECT product_id FROM PRODUCT LIMIT 3;
-
-CALL purchase_ticket_with_products(12818005, 'admin01', 4000005, ARRAY[1, 2, 3]);
-CALL add_movie_review('admin01', 195, 8, 'Одличен филм, препорачувам!');
-
--- Земи филм за кој admin01 има тикет но нема review
-SELECT DISTINCT s.movie_id
-FROM TICKET t
-JOIN SCREENING s ON s.screening_id = t.screening_id
-WHERE t.user_id = 'admin01'
-AND s.movie_id NOT IN (SELECT movie_id FROM REVIEW WHERE user_id = 'admin01')
-LIMIT 1;
-
-SELECT DISTINCT s.movie_id
-FROM TICKET t
-JOIN SCREENING s ON s.screening_id = t.screening_id
-WHERE t.user_id = 'admin01'
-AND s.movie_id NOT IN (SELECT movie_id FROM REVIEW WHERE user_id = 'admin01')
-LIMIT 1;
-
-SELECT DISTINCT s.movie_id
-FROM TICKET t
-JOIN SCREENING s ON s.screening_id = t.screening_id
-WHERE t.user_id = 'admin01'
-AND s.movie_id NOT IN (SELECT movie_id FROM REVIEW WHERE user_id = 'admin01')
-LIMIT 1;
-SELECT user_id FROM "USER" WHERE user_id != 'admin01' LIMIT 1;
-
-SELECT DISTINCT s.movie_id
-FROM TICKET t
-JOIN SCREENING s ON s.screening_id = t.screening_id
-WHERE t.user_id = 'admin02'
-AND s.movie_id NOT IN (SELECT movie_id FROM REVIEW WHERE user_id = 'admin02')
-LIMIT 1;
-CALL add_movie_review('admin02', 195, 7, 'Многу добар филм!');
+
+CREATE OR REPLACE TRIGGER trg_complete_past_reservations
+AFTER INSERT ON SCREENING
+FOR EACH ROW
+EXECUTE FUNCTION complete_past_reservations();