Mercurial > gemma

changeset 3223:9e087a495f41

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed SQL statements. Got broken when migrated to new filter builder.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 09 May 2019 15:42:21 +0200
parents 83e8e1ea0aff
children bfde4f8dd323
files pkg/controllers/gauges.go pkg/controllers/printtemplates.go
diffstat 2 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/gauges.go	Thu May 09 15:14:12 2019 +0200
+++ b/pkg/controllers/gauges.go	Thu May 09 15:42:21 2019 +0200
@@ -642,7 +642,7 @@
 			buildFilterTerm(
 				`date_issue = (
                  SELECT max(date_issue) FROM waterway.gauge_measurements
-                 WHERE fk_gauge_id = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int)`,
+                 WHERE fk_gauge_id = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int))`,
 				isrs.CountryCode,
 				isrs.LoCode,
 				isrs.FairwaySection,
--- a/pkg/controllers/printtemplates.go	Thu May 09 15:14:12 2019 +0200
+++ b/pkg/controllers/printtemplates.go	Thu May 09 15:42:21 2019 +0200
@@ -37,6 +37,7 @@
   date_info,
   country
 FROM users.templates
+WHERE
 `
 
 	hasPrintTemplateSQL = `