def calculate_median_sleep(user_id, start_date, end_date):
"""Calculates user's all-time median hours of sleep per night."""
minutes_asleep_tups = db.session.query(Entry.minutes_asleep).filter\
(Entry.user_id == user_id, Entry.date >= start_date,\
Entry.date <= end_date).order_by('minutes_asleep').all()
minutes_asleep_lst = []
for item in minutes_asleep_tups:
minutes_asleep_lst.append(item[0])
median_sleep = median(minutes_asleep_lst) / 60
return median_sleep
评论列表
文章目录