Mercurial > gemma
view schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5384:18969a4d31b6 extented-report
Added a table to store SQL update scripts for aggregated data.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 01 Jul 2021 21:56:50 +0200 |
parents | ac846e085553 |
children |
line wrap: on
line source
INSERT INTO sys_admin.published_services ( schema, name, style ) VALUES ('waterway', 'fairway_marks_bcnlat_ienc', ( SELECT style FROM sys_admin.published_services WHERE schema = 'waterway' AND name = 'fairway_marks_bcnlat')), ('waterway', 'fairway_marks_boylat_ienc', ( SELECT style FROM sys_admin.published_services WHERE schema = 'waterway' AND name = 'fairway_marks_boylat')), ('waterway', 'fairway_marks_daymar_ienc', ( SELECT style FROM sys_admin.published_services WHERE schema = 'waterway' AND name = 'fairway_marks_daymar')); INSERT INTO sys_admin.grouped_layers VALUES ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0), ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2), ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5); WITH upd AS ( UPDATE sys_admin.grouped_layers SET name = name || '_hydro' WHERE schema = 'waterway' AND name IN( 'fairway_marks_bcnlat', 'fairway_marks_boylat', 'fairway_marks_daymar')) UPDATE sys_admin.published_services SET name = name || '_hydro' WHERE schema = 'waterway' AND name IN( 'fairway_marks_bcnlat', 'fairway_marks_boylat', 'fairway_marks_daymar');