From 8d9aa9bf3310f1e4dc49fd3f04e13c1f06c3dbce Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 20 Nov 2019 10:57:36 +0100 Subject: [PATCH] formatting: avoid long lines --- utils/update.php | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) diff --git a/utils/update.php b/utils/update.php index 735f4638..4317367a 100644 --- a/utils/update.php +++ b/utils/update.php @@ -327,8 +327,13 @@ if ($aResult['recompute-importance']) { $oDB->connect(); $sSQL = 'ALTER TABLE placex DISABLE TRIGGER ALL;'; - $sSQL .= 'UPDATE placex SET (wikipedia, importance) = (SELECT wikipedia, importance FROM compute_importance(extratags, country_code, osm_type, osm_id));'; - $sSQL .= 'UPDATE placex s SET wikipedia = d.wikipedia, importance = d.importance FROM placex d WHERE s.place_id = d.linked_place_id and d.wikipedia is not null and (s.wikipedia is null or s.importance < d.importance);'; + $sSQL .= 'UPDATE placex SET (wikipedia, importance) ='; + $sSQL .= ' (SELECT wikipedia, importance'; + $sSQL .= ' FROM compute_importance(extratags, country_code, osm_type, osm_id));'; + $sSQL .= 'UPDATE placex s SET wikipedia = d.wikipedia, importance = d.importance'; + $sSQL .= ' FROM placex d'; + $sSQL .= ' WHERE s.place_id = d.linked_place_id and d.wikipedia is not null'; + $sSQL .= ' and (s.wikipedia is null or s.importance < d.importance);'; $sSQL .= 'ALTER TABLE placex ENABLE TRIGGER ALL;'; $oDB->exec($sSQL); } -- 2.39.5