def pstats_view(request):
# we have to be logged in for this one
if not request.user:
return HTTPFound(location=request.route_url('home'))
# get our users records
rs = request.user.records
(avg_sleep_duration, ojs, start_stats, tts, end_stats, avg_sleep_quality, sleep_duration_byday, sleep_quality_byday) = sleep_time_stats(rs)
return {'title' : 'personal stats',
'avg_sleep_duration' : avg_sleep_duration,
'avg_sleep_quality' : avg_sleep_quality,
's1_data' : ojs,
's1_stats' : start_stats,
's2_data' : tts,
's2_stats' : end_stats,
'sd_byday' : sleep_duration_byday,
'sq_byday' : sleep_quality_byday,
'user_hash' : ulhash(request.user)}
def vstats_view(request):
if 'username' not in request.matchdict or 'hash' not in request.matchdict:
return HTTPFound(location=request.route_url('home'))
# verify the username exists
urs = request.DBSession.query(User).filter(User.username == request.matchdict['username']).all()
# user does not exist
if len(urs) != 1:
return HTTPFound(location=request.route_url('home'))
# otherwise we have the user record, now verify the hash
user = urs[0]
if request.matchdict['hash'] != ulhash(user):
return HTTPFound(location=request.route_url('home'))
# get the sleep stats
(avg_sleep_duration, ojs, start_stats, tts, end_stats, avg_sleep_quality, sleep_duration_byday, sleep_quality_byday) = sleep_time_stats(user.records)
return {'title' : user.username + '\'s personal stats',
'avg_sleep_duration' : avg_sleep_duration,
'avg_sleep_quality' : avg_sleep_quality,
's1_data' : ojs,
's1_stats' : start_stats,
's2_data' : tts,
's2_stats' : end_stats,
'sd_byday' : sleep_duration_byday,
'sq_byday' : sleep_quality_byday,}
def stats_view(request):
# get ALL the records
rs = request.DBSession.query(Sleep).all()
(avg_sleep_duration, ojs, start_stats, tts, end_stats, avg_sleep_quality, sleep_duration_byday, sleep_quality_byday) = sleep_time_stats(rs)
return {'title' : 'global stats',
'avg_sleep_duration' : avg_sleep_duration,
'avg_sleep_quality' : avg_sleep_quality,
's1_data' : ojs,
's1_stats' : start_stats,
's2_data' : tts,
's2_stats' : end_stats,
'sd_byday' : sleep_duration_byday,
'sq_byday' : sleep_quality_byday}