[Mapbender-commits] r9405 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2016-02-23 00:55:19 -0800 (Tue, 23 Feb 2016)
New Revision: 9405

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Add trigger to wms and wfs table to document metadata changes

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-02-22 15:06:48 UTC (rev 9404)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-02-23 08:55:19 UTC (rev 9405)
@@ -828,3 +828,66 @@
 ALTER TABLE search_dataset_view
   OWNER TO postgres;
 
+--add trigger for wms and wfs table to document changes!
+-- Function: update_wms_timestamp_column()
+
+-- DROP FUNCTION update_wms_timestamp_column();
+
+CREATE OR REPLACE FUNCTION update_wms_timestamp_column()
+  RETURNS trigger AS
+$BODY$
+BEGIN
+   NEW.wms_timestamp = EXTRACT(EPOCH FROM NOW())::INTEGER; 
+   RETURN NEW;
+END;
+$BODY$
+  LANGUAGE plpgsql VOLATILE
+  COST 100;
+ALTER FUNCTION update_wms_timestamp_column()
+  OWNER TO postgres;
+
+
+--ALTER DATABASE mapbender_trunk SET search_path = 'mapbender', 'public';
+
+-- Trigger: update_wms_timestamp on wms
+
+DROP TRIGGER IF EXISTS update_wms_timestamp ON wms;
+
+CREATE TRIGGER update_wms_timestamp
+  BEFORE UPDATE
+  ON wms
+  FOR EACH ROW
+  EXECUTE PROCEDURE update_wms_timestamp_column();
+
+-- Function: update_wfs_timestamp_column()
+
+-- DROP FUNCTION update_wfs_timestamp_column();
+
+CREATE OR REPLACE FUNCTION update_wfs_timestamp_column()
+  RETURNS trigger AS
+$BODY$
+BEGIN
+   NEW.wfs_timestamp = EXTRACT(EPOCH FROM NOW())::INTEGER; 
+   RETURN NEW;
+END;
+$BODY$
+  LANGUAGE plpgsql VOLATILE
+  COST 100;
+ALTER FUNCTION update_wfs_timestamp_column()
+  OWNER TO postgres;
+
+
+--ALTER DATABASE mapbender_trunk SET search_path = 'mapbender', 'public';
+
+-- Trigger: update_wfs_timestamp on wfs
+
+DROP TRIGGER IF EXISTS update_wfs_timestamp ON wfs;
+
+CREATE TRIGGER update_wfs_timestamp
+  BEFORE UPDATE
+  ON wfs
+  FOR EACH ROW
+  EXECUTE PROCEDURE update_wfs_timestamp_column();
+
+
+