diff options
Diffstat (limited to 'sql/make_report')
| -rwxr-xr-x | sql/make_report | 23 |
1 files changed, 20 insertions, 3 deletions
diff --git a/sql/make_report b/sql/make_report index f09b40b..81db04b 100755 --- a/sql/make_report +++ b/sql/make_report @@ -28,6 +28,7 @@ parser.add_argument('--end_date',required=True) parser.add_argument('--db_name',required=True) parser.add_argument('--db_user',required=True) parser.add_argument('--db_pass',required=True) +parser.add_argument('--activity',required=False) args = parser.parse_args() @@ -46,7 +47,7 @@ log.addHandler(ch) logging.getLogger('sugar_stats_consolidation.db').addHandler(ch) def activity_most_used(re, start, end): - activity = re.most_activity_used(start, end); + activity = re.rep_most_activity_used(start, end); log.debug("**************************************************************************************************************") log.debug(" Most Activity used ") log.debug('NAME: %s', activity[0]) @@ -58,7 +59,7 @@ def frequency_usage(re, start, end): ts_end = long (datetime.strptime(end, "%Y-%m-%d").strftime("%s")) ts_start = long (datetime.strptime(start, "%Y-%m-%d").strftime("%s")) - fres = re.frequency_usage(start, end); + fres = re.rep_frequency_usage(start, end); f_x_day = (fres / ((ts_end - ts_start)/(60*60*24)))/60 f_total = (fres / 60) log.debug("**************************************************************************************************************") @@ -68,19 +69,35 @@ def frequency_usage(re, start, end): log.debug('TOTAL: %.2f min', (f_total)) log.debug("**************************************************************************************************************") +def activity_time (re, start, end, activity): + ts_end = long (datetime.strptime(end, "%Y-%m-%d").strftime("%s")) + ts_start = long (datetime.strptime(start, "%Y-%m-%d").strftime("%s")) + + time = re.rep_activity_time (start, end, activity); + log.debug("**************************************************************************************************************") + log.debug(" Activity Time ") + log.debug('NAME: %s', activity) + log.debug('INTERVAL: %s-> %s', start, end) + log.debug('UPTIME: %s secs', time[0]) + log.debug('FOCUS %s secs', time[1]) + log.debug("**************************************************************************************************************") + def main(): re = DB_Stats (args.db_name, args.db_user, args.db_pass) re.connect() - if args.query == 'activity_most_used': + if args.query == 'activity_time': + activity_time(re, args.start_date, args.end_date, args.activity) + elif args.query == 'activity_most_used': activity_most_used(re, args.start_date, args.end_date); elif args.query == 'frequency_usage': frequency_usage(re, args.start_date, args.end_date) elif args.query == 'all': activity_most_used(re, args.start_date, args.end_date); frequency_usage(re, args.start_date, args.end_date) + activity_time(re, args.start_date, args.end_date, args.activity) else: log.error("Query option unkwon: %s", args.query) |