helper.py 文件源码

python
阅读 37 收藏 0 点赞 0 评论 0

项目:insomnia-app 作者: k-wiz 项目源码 文件源码
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
评论列表
文章目录


问题


面经


文章

微信
公众号

扫码关注公众号