# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1622645700 -7200
# Node ID 72d3b8321ed0b37d417739989abd12fe9fc98c91
# Parent  660147046ddda63cffef1635d637a3bbc7375bd2
Fixed broken migration which erased the style of the modified GeoServer view.

diff -r 660147046ddd -r 72d3b8321ed0 schema/updates/1441/01.extend_sounding_result_view.sql
--- a/schema/updates/1441/01.extend_sounding_result_view.sql	Tue Jun 01 09:33:03 2021 +0200
+++ b/schema/updates/1441/01.extend_sounding_result_view.sql	Wed Jun 02 16:55:00 2021 +0200
@@ -1,19 +1,11 @@
--- Could have used an UPDATE for this but this way its more C&P from
--- default_sysconfig.sql
-
-DELETE FROM sys_admin.published_services
+UPDATE sys_admin.published_services SET view_def = $$
+    SELECT bottleneck_id,
+        to_char(date_info, 'YYYY-MM-DD') AS date_info,
+        height,
+        areas,
+        surtyp,
+        zpg_exception
+    FROM waterway.sounding_results_iso_areas ia
+        JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
+$$
   WHERE schema = 'waterway' AND name = 'sounding_results_areas_geoserver';
-
-INSERT INTO sys_admin.published_services (
-    schema, name, srid, key_column, view_def
-) VALUES
-    ('waterway', 'sounding_results_areas_geoserver', 4326, NULL, $$
-        SELECT bottleneck_id,
-            to_char(date_info, 'YYYY-MM-DD') AS date_info,
-            height,
-            areas,
-            surtyp,
-            zpg_exception
-        FROM waterway.sounding_results_iso_areas ia
-            JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
-    $$);