diff pkg/imports/st.go @ 1995:59055c8301df

Move import queue to its own database namespace Authorisation of the import queue has to be handled differently from the waterway-related data in the waterway schema. This is easier to handle, if both are in their own schema/namespace.
author Tom Gottfried <tom@intevation.de>
date Thu, 24 Jan 2019 12:56:31 +0100
parents f9f1babe52ae
children b868cb653c4d
line wrap: on
line diff
--- a/pkg/imports/st.go	Thu Jan 24 12:50:17 2019 +0100
+++ b/pkg/imports/st.go	Thu Jan 24 12:56:31 2019 +0100
@@ -67,7 +67,7 @@
   SELECT name
   FROM waterway.stretches WHERE
   id = (
-    SELECT key from waterway.track_imports
+    SELECT key from import.track_imports
     WHERE import_id = $1 AND
       relation = 'waterway.stretches'::regclass)
   AND NOT staging_done
@@ -76,7 +76,7 @@
 	stStageDoneSQL = `
 UPDATE waterway.stretches SET staging_done = true
 WHERE id IN (
-  SELECT key from waterway.track_imports
+  SELECT key from import.track_imports
   WHERE import_id = $1 AND
         relation = 'waterway.stretches'::regclass)`