comparison pkg/scheduler/boot.go @ 2055:6594903a14e8 unify_imports

Scheduler: Fixed SQL statement once again.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 28 Jan 2019 14:01:56 +0100
parents b03e487117df
children 6691bf76af1c
comparison
equal deleted inserted replaced
2054:b03e487117df 2055:6594903a14e8
27 27
28 selectImportConfSQL = ` 28 selectImportConfSQL = `
29 SELECT c.id, username, a.v 29 SELECT c.id, username, a.v
30 FROM import.import_configuration c 30 FROM import.import_configuration c
31 JOIN import.import_configuration_attributes a 31 JOIN import.import_configuration_attributes a
32 ON c.id = a.import.import_configuration_id 32 ON c.id = a.import_configuration_id
33 WHERE c.id IN ( 33 WHERE c.id IN (
34 SELECT import_configuration_id 34 SELECT import_configuration_id
35 FROM import.import_configuration_attributes 35 FROM import.import_configuration_attributes
36 WHERE k = 'cron')` 36 WHERE k = 'cron')`
37 37