Mercurial > gemma

comparison schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 4992:ac846e085553

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
4991:6a48e5c6fe2f 4992:ac846e085553
1 INSERT INTO sys_admin.published_services (
2 schema, name, style
3 ) VALUES
4 ('waterway', 'fairway_marks_bcnlat_ienc', (
5 SELECT style FROM sys_admin.published_services
6 WHERE schema = 'waterway' AND name = 'fairway_marks_bcnlat')),
7 ('waterway', 'fairway_marks_boylat_ienc', (
8 SELECT style FROM sys_admin.published_services
9 WHERE schema = 'waterway' AND name = 'fairway_marks_boylat')),
10 ('waterway', 'fairway_marks_daymar_ienc', (
11 SELECT style FROM sys_admin.published_services
12 WHERE schema = 'waterway' AND name = 'fairway_marks_daymar'));
13
14 INSERT INTO sys_admin.grouped_layers VALUES
15 ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0),
16 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2),
17 ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5);
18
19 WITH upd AS (
20 UPDATE sys_admin.grouped_layers
21 SET name = name || '_hydro'
22 WHERE schema = 'waterway' AND name IN(
23 'fairway_marks_bcnlat',
24 'fairway_marks_boylat',
25 'fairway_marks_daymar'))
26 UPDATE sys_admin.published_services
27 SET name = name || '_hydro'
28 WHERE schema = 'waterway' AND name IN(
29 'fairway_marks_bcnlat',
30 'fairway_marks_boylat',
31 'fairway_marks_daymar');