Mercurial > gemma

comparison pkg/controllers/importqueue.go @ 5563:3be1d79ad3a3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Log export: Limit log lines loading to 'sr' imports.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sat, 12 Feb 2022 17:36:20 +0100
parents 5152b4db40cc
children aaa9e658cabd
comparison
equal deleted inserted replaced
5562:5152b4db40cc 5563:3be1d79ad3a3
58 EXISTS(SELECT 1 FROM import.import_logs 58 EXISTS(SELECT 1 FROM import.import_logs
59 WHERE kind = 'warn'::log_type and import_id = imports.id) AS has_warnings 59 WHERE kind = 'warn'::log_type and import_id = imports.id) AS has_warnings
60 FROM import.imports 60 FROM import.imports
61 WHERE 61 WHERE
62 ` 62 `
63 // XXX: Consider not only supporting 'sr' for log message parsing.
63 selectExportSQL = ` 64 selectExportSQL = `
64 SELECT 65 SELECT
65 imports.id AS id, 66 imports.id AS id,
66 state::varchar, 67 state::varchar,
67 enqueued, 68 enqueued,
72 WHERE lu.username = import.imports.username) AS country, 73 WHERE lu.username = import.imports.username) AS country,
73 signer, 74 signer,
74 EXISTS(SELECT 1 FROM import.import_logs 75 EXISTS(SELECT 1 FROM import.import_logs
75 WHERE kind = 'warn'::log_type and import_id = id) AS has_warnings, 76 WHERE kind = 'warn'::log_type and import_id = id) AS has_warnings,
76 data, 77 data,
77 ARRAY(SELECT msg FROM import.import_logs WHERE import_id = id) AS msgs 78 CASE WHEN kind = 'sr' THEN ARRAY(SELECT msg FROM import.import_logs WHERE import_id = id)
79 ELSE NULL
80 END AS msgs
78 FROM import.imports 81 FROM import.imports
79 WHERE 82 WHERE
80 ` 83 `
81 selectEnqueuedSQL = ` 84 selectEnqueuedSQL = `
82 SELECT enqueued FROM import.imports 85 SELECT enqueued FROM import.imports