liquid_feedback_core
changeset 537:aa261389c993
Stubs for unit/area/policy event triggers
author | jbe |
---|---|
date | Mon Jun 26 16:20:36 2017 +0200 (2017-06-26) |
parents | 750b0be5acb6 |
children | 1bc3dfe5823e |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Mon Jun 26 15:54:26 2017 +0200 1.2 +++ b/core.sql Mon Jun 26 16:20:36 2017 +0200 1.3 @@ -1782,6 +1782,51 @@ 1.4 COMMENT ON TRIGGER "write_member_history" ON "member" IS 'When changing certain fields of a member, create a history entry in "member_history" table'; 1.5 1.6 1.7 +CREATE FUNCTION "write_event_unit_trigger"() 1.8 + RETURNS TRIGGER 1.9 + LANGUAGE 'plpgsql' VOLATILE AS $$ 1.10 + BEGIN 1.11 + RETURN NULL; 1.12 + END; 1.13 + $$; 1.14 + 1.15 +CREATE TRIGGER "write_event_unit" AFTER INSERT OR UPDATE ON "unit" 1.16 + FOR EACH ROW EXECUTE PROCEDURE "write_event_unit_trigger"(); 1.17 + 1.18 +COMMENT ON FUNCTION "write_event_unit_trigger"() IS 'Implementation of trigger "write_event_unit" on table "unit"'; 1.19 +COMMENT ON TRIGGER "write_event_unit" ON "unit" IS 'Create entry in "event" table on new or changed/disabled units'; 1.20 + 1.21 + 1.22 +CREATE FUNCTION "write_event_area_trigger"() 1.23 + RETURNS TRIGGER 1.24 + LANGUAGE 'plpgsql' VOLATILE AS $$ 1.25 + BEGIN 1.26 + RETURN NULL; 1.27 + END; 1.28 + $$; 1.29 + 1.30 +CREATE TRIGGER "write_event_area" AFTER INSERT OR UPDATE ON "area" 1.31 + FOR EACH ROW EXECUTE PROCEDURE "write_event_area_trigger"(); 1.32 + 1.33 +COMMENT ON FUNCTION "write_event_area_trigger"() IS 'Implementation of trigger "write_event_area" on table "area"'; 1.34 +COMMENT ON TRIGGER "write_event_area" ON "area" IS 'Create entry in "event" table on new or changed/disabled areas'; 1.35 + 1.36 + 1.37 +CREATE FUNCTION "write_event_policy_trigger"() 1.38 + RETURNS TRIGGER 1.39 + LANGUAGE 'plpgsql' VOLATILE AS $$ 1.40 + BEGIN 1.41 + RETURN NULL; 1.42 + END; 1.43 + $$; 1.44 + 1.45 +CREATE TRIGGER "write_event_policy" AFTER INSERT OR UPDATE ON "policy" 1.46 + FOR EACH ROW EXECUTE PROCEDURE "write_event_policy_trigger"(); 1.47 + 1.48 +COMMENT ON FUNCTION "write_event_policy_trigger"() IS 'Implementation of trigger "write_event_policy" on table "policy"'; 1.49 +COMMENT ON TRIGGER "write_event_policy" ON "policy" IS 'Create entry in "event" table on new or changed/disabled policies'; 1.50 + 1.51 + 1.52 CREATE FUNCTION "write_event_issue_state_changed_trigger"() 1.53 RETURNS TRIGGER 1.54 LANGUAGE 'plpgsql' VOLATILE AS $$
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Mon Jun 26 15:54:26 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Mon Jun 26 16:20:36 2017 +0200 2.3 @@ -941,6 +941,51 @@ 2.4 COMMENT ON INDEX "event_processed_singleton_idx" IS 'This index ensures that "event_processed" only contains one row maximum.'; 2.5 2.6 2.7 +CREATE FUNCTION "write_event_unit_trigger"() 2.8 + RETURNS TRIGGER 2.9 + LANGUAGE 'plpgsql' VOLATILE AS $$ 2.10 + BEGIN 2.11 + RETURN NULL; 2.12 + END; 2.13 + $$; 2.14 + 2.15 +CREATE TRIGGER "write_event_unit" AFTER INSERT OR UPDATE ON "unit" 2.16 + FOR EACH ROW EXECUTE PROCEDURE "write_event_unit_trigger"(); 2.17 + 2.18 +COMMENT ON FUNCTION "write_event_unit_trigger"() IS 'Implementation of trigger "write_event_unit" on table "unit"'; 2.19 +COMMENT ON TRIGGER "write_event_unit" ON "unit" IS 'Create entry in "event" table on new or changed/disabled units'; 2.20 + 2.21 + 2.22 +CREATE FUNCTION "write_event_area_trigger"() 2.23 + RETURNS TRIGGER 2.24 + LANGUAGE 'plpgsql' VOLATILE AS $$ 2.25 + BEGIN 2.26 + RETURN NULL; 2.27 + END; 2.28 + $$; 2.29 + 2.30 +CREATE TRIGGER "write_event_area" AFTER INSERT OR UPDATE ON "area" 2.31 + FOR EACH ROW EXECUTE PROCEDURE "write_event_area_trigger"(); 2.32 + 2.33 +COMMENT ON FUNCTION "write_event_area_trigger"() IS 'Implementation of trigger "write_event_area" on table "area"'; 2.34 +COMMENT ON TRIGGER "write_event_area" ON "area" IS 'Create entry in "event" table on new or changed/disabled areas'; 2.35 + 2.36 + 2.37 +CREATE FUNCTION "write_event_policy_trigger"() 2.38 + RETURNS TRIGGER 2.39 + LANGUAGE 'plpgsql' VOLATILE AS $$ 2.40 + BEGIN 2.41 + RETURN NULL; 2.42 + END; 2.43 + $$; 2.44 + 2.45 +CREATE TRIGGER "write_event_policy" AFTER INSERT OR UPDATE ON "policy" 2.46 + FOR EACH ROW EXECUTE PROCEDURE "write_event_policy_trigger"(); 2.47 + 2.48 +COMMENT ON FUNCTION "write_event_policy_trigger"() IS 'Implementation of trigger "write_event_policy" on table "policy"'; 2.49 +COMMENT ON TRIGGER "write_event_policy" ON "policy" IS 'Create entry in "event" table on new or changed/disabled policies'; 2.50 + 2.51 + 2.52 CREATE OR REPLACE FUNCTION "write_event_issue_state_changed_trigger"() 2.53 RETURNS TRIGGER 2.54 LANGUAGE 'plpgsql' VOLATILE AS $$