Mercurial > gemma
view schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5560:f2204f91d286
Join the log lines of imports to the log exports to recover data from them.
Used in SR export to extract information that where in the meta json
but now are only found in the log.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 09 Feb 2022 18:34:40 +0100 |
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');