[Mapbender-commits] r9781 - trunk/mapbender/http/classes

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-09-27 04:59:07 -0700 (Wed, 27 Sep 2017)
New Revision: 9781

Modified:
   trunk/mapbender/http/classes/class_wfsToDb.php
Log:
Bugfix - delete capabilities based featuretype metadata relations when updating wfs.

Modified: trunk/mapbender/http/classes/class_wfsToDb.php
===================================================================
--- trunk/mapbender/http/classes/class_wfsToDb.php	2017-09-27 11:40:28 UTC (rev 9780)
+++ trunk/mapbender/http/classes/class_wfsToDb.php	2017-09-27 11:59:07 UTC (rev 9781)
@@ -300,7 +300,15 @@
 				db_rollback();
 			}
 		}
-		
+
+		// delete all metadata relations which come capabilities
+		$sql = "DELETE FROM ows_relation_metadata WHERE fkey_featuretype_id IN " ;
+		$sql .= "(SELECT featuretype_id FROM wfs_featuretype WHERE fkey_wfs_id = $1)";
+		$sql .= " AND ows_relation_metadata.relation_type = 'capabilities'";
+		$v = array($aWfs->id);
+		$t = array("i");
+		$res = db_prep_query($sql,$v,$t);
+
 		// delete and refill WFS operations
 		$sql = "DELETE FROM wfs_operation WHERE fkey_wfs_id = $1 ";
 		$v = array($aWfs->id);