def calculate_avg_sleep(user_id, start_date, end_date):
"""Calculates user's average hours of sleep per night from start_date
to end_date."""
avg_sleep = db.session.query(func.avg(Entry.minutes_asleep)).filter(Entry.user_id\
== user_id, Entry.date >= start_date, Entry.date <= end_date)
avg_sleep = int(avg_sleep[0][0])/60.0
return avg_sleep
评论列表
文章目录