comparison pkg/imports/sr.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 6a67cd819e93
children b868cb653c4d
comparison
equal deleted inserted replaced
1994:a7c4005b723f 1995:59055c8301df
104 104
105 const ( 105 const (
106 srStageDoneSQL = ` 106 srStageDoneSQL = `
107 UPDATE waterway.sounding_results SET staging_done = true 107 UPDATE waterway.sounding_results SET staging_done = true
108 WHERE id = ( 108 WHERE id = (
109 SELECT key from waterway.track_imports 109 SELECT key from import.track_imports
110 WHERE import_id = $1 AND 110 WHERE import_id = $1 AND
111 relation = 'waterway.sounding_results'::regclass)` 111 relation = 'waterway.sounding_results'::regclass)`
112 112
113 insertPointsSQL = ` 113 insertPointsSQL = `
114 INSERT INTO waterway.sounding_results ( 114 INSERT INTO waterway.sounding_results (