Mercurial > gemma

diff pkg/imports/wg.go @ 4028:5fed2f5bc104 historization_ng

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
End validity of gauge if it gets deleted during import.
author Sascha Wilde <wilde@intevation.de>
date Wed, 17 Jul 2019 17:52:04 +0200
parents 29ef6d41e4af
children 4332b9e26e2f
line wrap: on
line diff
--- a/pkg/imports/wg.go	Wed Jul 17 17:17:05 2019 +0200
+++ b/pkg/imports/wg.go	Wed Jul 17 17:52:04 2019 +0200
@@ -66,7 +66,7 @@
 
 const (
 	eraseObsoleteGaugesSQL = `
-UPDATE waterway.gauges SET erased = true
+UPDATE waterway.gauges SET erased = true, validity = validity - '[now,)'
 WHERE NOT erased
   AND (location).country_code = ANY($1)
   AND isrs_astext(location) <> ALL($2)