Mercurial > gemma

diff pkg/imports/fa.go @ 3645:02951a62e8c6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
'Historicise' bottlenecks on import
author Tom Gottfried <tom@intevation.de>
date Wed, 12 Jun 2019 17:11:15 +0200
parents 4acbee65275d
children db87f34805fb
line wrap: on
line diff
--- a/pkg/imports/fa.go	Wed Jun 12 17:10:49 2019 +0200
+++ b/pkg/imports/fa.go	Wed Jun 12 17:11:15 2019 +0200
@@ -47,7 +47,7 @@
 
 const (
 	listBottlenecksSQL = `
-SELECT
+SELECT DISTINCT
   bottleneck_id
 FROM waterway.bottlenecks
 WHERE responsible_country = users.current_user_country()
@@ -79,7 +79,8 @@
   source_organization
 ) VALUES (
   $1,
-  (SELECT id FROM waterway.bottlenecks WHERE bottleneck_id = $2),
+  (SELECT id FROM waterway.bottlenecks
+     WHERE NOT erased AND bottleneck_id = $2),
   $3,
   $4,
   $5,