diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/report.py | 2 |
1 files changed, 1 insertions, 1 deletions
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))") |