Mercurial > gemma
view schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5650:cb3c4ba0f052 DQR adjustments
Merged default branch
author | Sascha Wilde <wilde@sha-bang.de> |
---|---|
date | Thu, 29 Jun 2023 13:18:54 +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');