api.spaceplanner.app

Spaceplanner API
git clone git://jacobedwards.org/api.spaceplanner.app
Log | Files | Refs

2024-10-22T16:58:39.sql (1137B)

      1 BEGIN;
      2 
      3 CREATE FUNCTION spaceplanner.modified_floorplan()
      4         RETURNS trigger AS $modified_floorplan$
      5         BEGIN
      6 		IF (TG_OP = 'DELETE') THEN
      7 			UPDATE spaceplanner.floorplans
      8 				SET updated = now() 
      9 				WHERE id = OLD.floorplan;
     10 		ELSE
     11 			UPDATE spaceplanner.floorplans
     12 				SET updated = now() 
     13 				WHERE id = OLD.floorplan;
     14 		END IF;
     15                 RETURN NEW;
     16         END;
     17         $modified_floorplan$ LANGUAGE plpgsql;
     18 
     19 CREATE TRIGGER updated_points
     20         AFTER INSERT OR UPDATE OR DELETE ON spaceplanner.floorplan_points
     21 	FOR EACH ROW
     22 	EXECUTE FUNCTION spaceplanner.modified_floorplan();
     23 
     24 CREATE TRIGGER updated_pointmaps
     25         AFTER INSERT OR UPDATE OR DELETE ON spaceplanner.floorplan_pointmaps
     26 	FOR EACH ROW
     27 	EXECUTE FUNCTION spaceplanner.modified_floorplan();
     28 
     29 CREATE TRIGGER updated_furniture
     30         AFTER INSERT OR UPDATE OR DELETE ON spaceplanner.furniture
     31 	FOR EACH ROW
     32 	EXECUTE FUNCTION spaceplanner.modified_floorplan();
     33 
     34 CREATE TRIGGER updated_furniture_maps
     35         AFTER INSERT OR UPDATE OR DELETE ON spaceplanner.furniture_maps
     36 	FOR EACH ROW
     37 	EXECUTE FUNCTION spaceplanner.modified_floorplan();
     38 
     39 COMMIT;