comparison pkg/controllers/importqueue.go @ 2179:20d9b71f4125

Import queue listing: Add another column 'warnings' (bool) to listing output which indicates if an import has warnings or not.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 11 Feb 2019 13:04:36 +0100
parents 59055c8301df
children 3a242e6aa56d
comparison
equal deleted inserted replaced
2178:17bf4c05caa4 2179:20d9b71f4125
37 state::varchar, 37 state::varchar,
38 enqueued, 38 enqueued,
39 kind, 39 kind,
40 username, 40 username,
41 signer, 41 signer,
42 summary 42 summary,
43 EXISTS (
44 SELECT true FROM import.import_logs
45 WHERE kind = 'warn'::log_type AND
46 import_id = import.imports.id
47 ) AS has_warnings
43 FROM import.imports 48 FROM import.imports
44 ` 49 `
45 50
46 selectHasImportSQL = ` 51 selectHasImportSQL = `
47 SELECT true FROM import.imports WHERE id = $1` 52 SELECT true FROM import.imports WHERE id = $1`
211 &it.Enqueued, 216 &it.Enqueued,
212 &it.Kind, 217 &it.Kind,
213 &it.User, 218 &it.User,
214 &signer, 219 &signer,
215 &summary, 220 &summary,
221 &it.Warnings,
216 ); err != nil { 222 ); err != nil {
217 return 223 return
218 } 224 }
219 if signer.Valid { 225 if signer.Valid {
220 it.Signer = signer.String 226 it.Signer = signer.String