# HG changeset patch # User Sascha L. Teichmann # Date 1552580976 -3600 # Node ID b997e1fd1d3d41865072d30eefabbbb0c9702b3f # Parent 8f3facf902ddcf878d28d0785a5bcc731ff2c156 Fixed warning SQL prefix for selection. diff -r 8f3facf902dd -r b997e1fd1d3d pkg/controllers/importqueue.go --- a/pkg/controllers/importqueue.go Thu Mar 14 17:25:33 2019 +0100 +++ b/pkg/controllers/importqueue.go Thu Mar 14 17:29:36 2019 +0100 @@ -34,13 +34,12 @@ const ( warningSQLPrefix = ` -` - selectImportsSQL = ` WITH warned AS ( SELECT distinct(import_id) AS id FROM import.import_logs WHERE kind = 'warn'::log_type -) +)` + selectImportsSQL = warningSQLPrefix + ` SELECT imports.id AS id, state::varchar, @@ -53,6 +52,14 @@ FROM import.imports WHERE ` + selectBeforeSQL = warningSQLPrefix + ` +SELECT enqueued FROM import.imports +WHERE +` + selectAfterSQL = warningSQLPrefix + ` +SELECT enqueued FROM import.imports +WHERE +` selectImportSummaySQL = ` SELECT summary FROM import.imports WHERE id = $1` @@ -74,16 +81,6 @@ deleteImportSQL = ` DELETE FROM import.imports WHERE id = $1` - - selectBeforeSQL = ` -SELECT enqueued FROM import.imports -WHERE -` - - selectAfterSQL = ` -SELECT enqueued FROM import.imports -WHERE -` ) func toInt8Array(txt string) *pgtype.Int8Array {