Changes between Version 7 and Version 8 of Trigger Functions
- Timestamp:
- 05/18/26 23:29:29 (8 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Trigger Functions
v7 v8 15 15 === SQL Code === 16 16 17 {{{ 18 #!sql 17 19 CREATE OR REPLACE FUNCTION check_venue_booking_overlap() 18 20 RETURNS TRIGGER AS $$ … … 29 31 AND vb.booking_id <> COALESCE(NEW.booking_id, -1) 30 32 AND ( 31 32 33 ((NEW."date" + NEW.start_time) >= (vb."date" + vb.start_time) 33 34 AND (NEW."date" + NEW.start_time) < (vb."date" + vb.end_time)) … … 62 63 FOR EACH ROW 63 64 EXECUTE FUNCTION check_venue_booking_overlap(); 65 }}} 64 66 65 67 == 2. Photographer Booking Conflict Prevention == … … 71 73 === SQL Code === 72 74 75 {{{ 76 #!sql 73 77 CREATE OR REPLACE FUNCTION check_photographer_booking_overlap() 74 78 RETURNS TRIGGER AS $$ … … 85 89 AND pb.booking_id <> COALESCE(NEW.booking_id, -1) 86 90 AND ( 87 88 91 ((NEW."date" + NEW.start_time) >= (pb."date" + pb.start_time) 89 92 AND (NEW."date" + NEW.start_time) < (pb."date" + pb.end_time)) … … 118 121 FOR EACH ROW 119 122 EXECUTE FUNCTION check_photographer_booking_overlap(); 123 }}} 120 124 121 125 == 3. Band Booking Conflict Prevention == … … 127 131 === SQL Code === 128 132 133 {{{ 134 #!sql 129 135 CREATE OR REPLACE FUNCTION check_band_booking_overlap() 130 136 RETURNS TRIGGER AS $$ … … 141 147 AND bb.booking_id <> COALESCE(NEW.booking_id, -1) 142 148 AND ( 143 144 149 ((NEW."date" + NEW.start_time) >= (bb."date" + bb.start_time) 145 150 AND (NEW."date" + NEW.start_time) < (bb."date" + bb.end_time)) … … 174 179 FOR EACH ROW 175 180 EXECUTE FUNCTION check_band_booking_overlap(); 176 181 }}} 177 182 178 183 == 4. Attendance Consistency Validation ==
