Mercurial > gemma
changeset 5306:6b0274693b48 zpg-exception
Extended view for GeoServer to contain zpg_exception.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 21 May 2021 10:17:32 +0200 |
parents | 1a565f8a935a |
children | 4ba3fda13c50 |
files | schema/default_sysconfig.sql schema/updates/1441/01.extend_sounding_result_view.sql schema/version.sql |
diffstat | 3 files changed, 22 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/default_sysconfig.sql Wed May 19 17:26:02 2021 +0200 +++ b/schema/default_sysconfig.sql Fri May 21 10:17:32 2021 +0200 @@ -213,7 +213,8 @@ to_char(date_info, 'YYYY-MM-DD') AS date_info, height, areas, - surtyp + surtyp, + zpg_execption FROM waterway.sounding_results_iso_areas ia JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id $$),
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1441/01.extend_sounding_result_view.sql Fri May 21 10:17:32 2021 +0200 @@ -0,0 +1,19 @@ +-- Could have used an UPDATE for this but this way its more C&P from +-- default_sysconfig.sql + +DELETE FROM sys_admin.published_services + 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_execption + FROM waterway.sounding_results_iso_areas ia + JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id + $$);