changeset 3133:7b4092b6b51a

Fairway availability depth: Fixed SQL statement.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 30 Apr 2019 15:11:47 +0200
parents f34277674926
children e52ba854bfe8
files pkg/controllers/bottlenecks.go
diffstat 1 files changed, 3 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/bottlenecks.go	Tue Apr 30 13:32:52 2019 +0200
+++ b/pkg/controllers/bottlenecks.go	Tue Apr 30 15:11:47 2019 +0200
@@ -84,7 +84,6 @@
 `
 	selectGaugeLDCSQL = `
 SELECT
-  grwl.depth_reference,
   grwl.value
 FROM waterway.gauges_reference_water_levels grwl JOIN
      waterway.bottlenecks bns
@@ -691,7 +690,7 @@
 		}
 		f := pfrom
 		pfrom = pfrom.AddDate(0, 1, 0)
-		label := fmt.Sprint("%02d-%d", f.Month(), f.Year())
+		label := fmt.Sprintf("%02d-%d", f.Month(), f.Year())
 		return f, f.AddDate(0, 1, 0).Add(-time.Nanosecond), label
 	}
 }
@@ -704,7 +703,7 @@
 		}
 		f := pfrom
 		pfrom = pfrom.AddDate(0, 3, 0)
-		label := fmt.Sprint("Q%d-%d", int(f.Month())/4+1, f.Year())
+		label := fmt.Sprintf("Q%d-%d", int(f.Month())/4+1, f.Year())
 		return f, f.AddDate(0, 3, 0).Add(-time.Nanosecond), label
 	}
 }
@@ -717,7 +716,7 @@
 		}
 		f := pfrom
 		pfrom = pfrom.AddDate(1, 0, 0)
-		label := fmt.Sprint("%d", f.Year())
+		label := fmt.Sprintf("%d", f.Year())
 		return f, f.AddDate(1, 0, 0).Add(-time.Nanosecond), label
 	}
 }