# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1644683780 -3600
# Node ID 3be1d79ad3a31868cf86dbcd0a54ddd459255543
# Parent  5152b4db40cce0bdcd54b1841ffc2355af52fa5e
Log export: Limit log lines loading to 'sr' imports.

diff -r 5152b4db40cc -r 3be1d79ad3a3 pkg/controllers/importqueue.go
--- a/pkg/controllers/importqueue.go	Sat Feb 12 09:54:33 2022 +0100
+++ b/pkg/controllers/importqueue.go	Sat Feb 12 17:36:20 2022 +0100
@@ -60,6 +60,7 @@
 FROM import.imports
 WHERE
 `
+	// XXX: Consider not only supporting 'sr' for log message parsing.
 	selectExportSQL = `
 SELECT
   imports.id AS id,
@@ -74,7 +75,9 @@
   EXISTS(SELECT 1 FROM import.import_logs
     WHERE kind = 'warn'::log_type and import_id = id) AS has_warnings,
   data,
-  ARRAY(SELECT msg FROM import.import_logs WHERE import_id = id) AS msgs
+  CASE WHEN kind = 'sr' THEN ARRAY(SELECT msg FROM import.import_logs WHERE import_id = id)
+  ELSE NULL
+  END AS msgs
 FROM import.imports
 WHERE
 `