Changeset 40095

Timestamp:

Jul 12, 2017, 3:33:15 PM (9 years ago)

Author:

eugene

Message:

nebulous time series should not quit if minY = 0

File:

• trunk/ippMonitor/czartool/czartool/CzarDb.pm (modified) (2 diffs)

trunk/ippMonitor/czartool/czartool/CzarDb.pm

@@ -1070 +1070 @@
 SQL
 
+# test to print out the sql
+#     print "SQL: ", (<<CODE);
+#     SELECT
+#         MAX(available), MIN(available), MAX(usable), MIN(usable),
+#         DATE_FORMAT(MAX(timestamp),'$self->{_dateFormat}'),
+#         DATE_FORMAT(MIN(timestamp),'$self->{_dateFormat}'),
+#         TIME_TO_SEC(TIMEDIFF(max(timestamp ), min(timestamp)))
+#             FROM cluster_space
+#             WHERE timestamp >= '$fromTime' AND timestamp <= '$toTime';
+# CODE
+
     if (!$query->execute) {return undef;}
 
@@ -1076 +1087 @@
     ${$minY} = ($minAvailable > $minUsable ? $minAvailable : $minUsable);
 
-    if (!${$maxY} || !${$minY} || !${$maxX} || !${$minX} || !${$timeDiff}) {return 0;}
+#   if (!${$maxY} || !${$minY} || !${$maxX} || !${$minX} || !${$timeDiff}) {return 0;}
+    if (!${$maxY} || !${$maxX} || !${$minX} || !${$timeDiff}) {return 0;}
 
     $query = $self->{_db}->prepare(<<SQL);