diff options
author | Gustavo Duarte AC <gduarte@activitycentral.com> | 2013-02-19 20:37:42 (GMT) |
---|---|---|
committer | Gustavo Duarte AC <gduarte@activitycentral.com> | 2013-02-19 20:37:42 (GMT) |
commit | c7067de14c249cd92fd5d0c1efaf0d0342f4a5c4 (patch) | |
tree | a2ac88254307965931b063350aac61bc523b57c4 | |
parent | 9082f866c243cb5dc6af9cdff8f2b2b201697f50 (diff) |
Fixes:
Add check on rep_frequency_usage
-rwxr-xr-x | sql/rep_frequency_usage_by_school.sh | 2 | ||||
-rw-r--r-- | sugar_stats_consolidation/db.py | 12 |
2 files changed, 8 insertions, 6 deletions
diff --git a/sql/rep_frequency_usage_by_school.sh b/sql/rep_frequency_usage_by_school.sh index 58555e7..5de8fa0 100755 --- a/sql/rep_frequency_usage_by_school.sh +++ b/sql/rep_frequency_usage_by_school.sh @@ -4,7 +4,7 @@ DB_USER=root DB_PASS=gustavo QUERY=frequency_usage -SCHOOL=Ceibal +SCHOOL=Ceibalito START_DATE=2013-02-10 END_DATE=2013-02-14 diff --git a/sugar_stats_consolidation/db.py b/sugar_stats_consolidation/db.py index 5edaaa8..b8cd8b2 100644 --- a/sugar_stats_consolidation/db.py +++ b/sugar_stats_consolidation/db.py @@ -369,7 +369,7 @@ class DB_Stats: def rep_frequency_usage (self, start, end, school=None): cursor1 = self.cnx.cursor() cursor2 = self.cnx.cursor() - res = 0 + time = 0 try: ts_start = self.date_to_ts(start) ts_end = self.date_to_ts(end) @@ -382,13 +382,15 @@ class DB_Stats: for user_hash in user_hashes: cursor2.execute("SELECT SUM(data) FROM Usages WHERE (resource_name = 'system') AND (start_date > %s) AND (start_date < %s) AND (data_type = 'uptime') AND (user_hash = %s)", (ts_start, ts_end, user_hash[0])) - res = float (cursor2.fetchone()[0]) + res - return res + res = cursor2.fetchone() + if res != None and res[0] != None: + time = float (res[0]) + time else: log.debug('Frequency usage') cursor2.execute("SELECT SUM(data) FROM Usages WHERE (resource_name = 'system') AND (start_date > %s) AND (start_date < %s) AND (data_type = 'uptime')", (ts_start, ts_end)) - res = cursor2.fetchone() - return res[0] + time = cursor2.fetchone()[0] + + return time except mysql.connector.Error as err: |