Mercurial > gemma

changeset 4610:1b928c0a0894 geoserver_sql_views

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapt demo data to new database model Also add an ON CONFLICT clause to allow resetting entries in a partly populated table.
author Tom Gottfried <tom@intevation.de>
date Thu, 05 Sep 2019 17:41:43 +0200
parents 1bf26d18b4d7
children b5aa1eb83bb0
files schema/demo-data/published_services.sql
diffstat 1 files changed, 15 insertions(+), 14 deletions(-) [+]
line wrap: on
line diff
--- a/schema/demo-data/published_services.sql	Thu Sep 05 17:27:34 2019 +0200
+++ b/schema/demo-data/published_services.sql	Thu Sep 05 17:41:43 2019 +0200
@@ -11,17 +11,18 @@
 -- Author(s):
 --  * Tom Gottfried <tom@intevation.de>
 
-INSERT INTO sys_admin.published_services (name) VALUES
-    ('waterway.sections_geoserver'),
-    ('waterway.stretches_geoserver'),
-    ('waterway.fairway_dimensions'),
-    ('waterway.gauges_geoserver'),
-    ('waterway.distance_marks_ashore_geoserver'),
-    ('waterway.distance_marks_geoserver'),
-    ('waterway.sounding_results_contour_lines_geoserver'),
-    ('waterway.bottlenecks_geoserver'),
-    ('waterway.bottleneck_overview'),
-    ('waterway.waterway_axis'),
-    ('waterway.waterway_area'),
-    ('waterway.waterway_profiles'),
-    ('waterway.sounding_differences')
+INSERT INTO sys_admin.published_services (schema, name, view_def) VALUES
+    ('waterway', 'sections_geoserver', NULL),
+    ('waterway', 'stretches_geoserver', NULL),
+    ('waterway', 'fairway_dimensions', NULL),
+    ('waterway', 'gauges_geoserver', NULL),
+    ('waterway', 'distance_marks_ashore_geoserver', NULL),
+    ('waterway', 'distance_marks_geoserver', NULL),
+    ('waterway', 'sounding_results_contour_lines_geoserver', NULL),
+    ('waterway', 'bottlenecks_geoserver', NULL),
+    ('waterway', 'bottleneck_overview', NULL),
+    ('waterway', 'waterway_axis', NULL),
+    ('waterway', 'waterway_area', NULL),
+    ('waterway', 'waterway_profiles', NULL),
+    ('waterway', 'sounding_differences', NULL)
+ON CONFLICT DO NOTHING