Mercurial > gemma
diff schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 4992:ac846e085553
Distinguish between HYDRO and IENC features in layer names
This will enable correct display of pretty names in the client.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 06 Mar 2020 18:28:42 +0100 |
| parents | |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1410/01.distinct_hydro_ienc_layers.sql Fri Mar 06 18:28:42 2020 +0100 @@ -0,0 +1,31 @@ +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');