From 2dfb3645829b4aa0bfdbed0ada9eaabf2a94ff8f Mon Sep 17 00:00:00 2001 From: Miguel Gonzalez Date: Fri, 12 Jul 2013 18:50:37 +0000 Subject: Fix syntax error --- diff --git a/sql/report.py b/sql/report.py index f9a600d..6af6797 100644 --- a/sql/report.py +++ b/sql/report.py @@ -24,7 +24,7 @@ class Report: STAT={} STAT ['Get_resource_name'] = ("SELECT name FROM `Resources`") - STAT ['Get_suma_uptime'] = ( "SELECT SUM (`data`) FROM Usages (WHERE `resource_name` = %s" AND data_type = 'active') + STAT ['Get_suma_uptime'] = ( "SELECT SUM (`data`) FROM Usages (WHERE `resource_name` = %s AND data_type = 'active')") STAT ['Get_frequency_usage'] = ("SELECT SUM(`data`) FROM Usages ((WHERE `resource_name` = `system`) AND (start_date > start) AND (start_date < end))") -- cgit v0.9.1