diff 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
line wrap: on
line diff
--- a/pkg/controllers/importqueue.go	Mon Feb 11 11:47:16 2019 +0100
+++ b/pkg/controllers/importqueue.go	Mon Feb 11 13:04:36 2019 +0100
@@ -39,7 +39,12 @@
   kind,
   username,
   signer,
-  summary
+  summary,
+  EXISTS (
+    SELECT true FROM import.import_logs
+      WHERE kind = 'warn'::log_type AND
+            import_id = import.imports.id
+  ) AS has_warnings
 FROM import.imports
 `
 
@@ -213,6 +218,7 @@
 			&it.User,
 			&signer,
 			&summary,
+			&it.Warnings,
 		); err != nil {
 			return
 		}