diff options
-rwxr-xr-x[-rw-r--r--] | .gitignore | 3 | ||||
-rw-r--r-- | sql/report.py | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/.gitignore b/.gitignore index 3df4d76..bc4698c 100644..100755 --- a/.gitignore +++ b/.gitignore @@ -1,3 +1,6 @@ build/ logs/ rrds/ +stats_consolidation/*.pyc +stats_consolidation/build/* +build/ 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))") |