aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_room_update_room_count
Parameters
Name
Type
Mode
Definition
DECLARE updating_roomtype_id int; BEGIN IF (TG_OP = 'UPDATE') AND (OLD.roomtype_id = NEW.roomtype_id) THEN RETURN NULL; END IF; IF TG_OP IN ('UPDATE','INSERT') THEN UPDATE room_type SET total_rooms = (SELECT count(r.id) FROM room r WHERE r.roomtype_id = NEW.roomtype_id) WHERE id = NEW.roomtype_id; END IF; IF TG_OP IN ('UPDATE','DELETE') THEN UPDATE room_type SET total_rooms = (SELECT count(r.id) FROM room r WHERE r.roomtype_id = OLD.roomtype_id) WHERE id = OLD.roomtype_id; END IF; RETURN NULL; END