diff options
| author | Miguel Gonzalez <migonzalvar@activitycentral.com> | 2013-07-12 18:50:37 (GMT) |
|---|---|---|
| committer | Miguel Gonzalez <migonzalvar@activitycentral.com> | 2013-07-12 18:55:00 (GMT) |
| commit | 2dfb3645829b4aa0bfdbed0ada9eaabf2a94ff8f (patch) | |
| tree | c5c984991ff1670d8280ecbc60bfbcbd45b0198e | |
| parent | 898f283bb2a545560e932aafde76fefb81a56c8e (diff) | |
Fix syntax errorrefs/merge-requests/1
| -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))") |