Mercurial > gemma
changeset 4364:496bbf0f618c
Move definition of published services to default configuration
We rely on existance of these layers in some places, e.g. default
configuration, already in some places. Further, default configuration
setup is, in contrast to demo data, part of automatic database tests.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 09 Sep 2019 17:39:57 +0200 |
| parents | d6439e7c8b1c |
| children | e739a4806d7c 32d3e0cecf4f |
| files | schema/default_sysconfig.sql schema/demo-data/published_services.sql |
| diffstat | 2 files changed, 19 insertions(+), 27 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/default_sysconfig.sql Mon Sep 09 17:26:59 2019 +0200 +++ b/schema/default_sysconfig.sql Mon Sep 09 17:39:57 2019 +0200 @@ -12,6 +12,7 @@ -- * Sascha Wilde <wilde@intevation.de> -- * Bernhard Reiter <bernhard.reiter@intevation.de> -- * Fadi Abbund <fadi.abbud@intevation.de> +-- * Tom Gottfried <tom@intevation.de> BEGIN; @@ -20,6 +21,24 @@ -- -- +-- Tables and views published via GeoServer +-- +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'); + +-- -- Settings -- INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/');
--- a/schema/demo-data/published_services.sql Mon Sep 09 17:26:59 2019 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,27 +0,0 @@ --- This is Free Software under GNU Affero General Public License v >= 3.0 --- without warranty, see README.md and license for details. - --- SPDX-License-Identifier: AGPL-3.0-or-later --- License-Filename: LICENSES/AGPL-3.0.txt - --- Copyright (C) 2018 by via donau --- – Österreichische Wasserstraßen-Gesellschaft mbH --- Software engineering by Intevation GmbH - --- 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')