def get_top5_projects_24_hours():
"""Return the top 5 projects more active in the last 24 hours."""
# Top 5 Most active projects in last 24 hours
sql = text('''SELECT project.id, project.name, project.short_name, project.info,
COUNT(task_run.project_id) AS n_answers FROM project, task_run
WHERE project.id=task_run.project_id
AND DATE(task_run.finish_time) > NOW() - INTERVAL '24 hour'
AND DATE(task_run.finish_time) <= NOW()
GROUP BY project.id
ORDER BY n_answers DESC LIMIT 5;''')
results = session.execute(sql, dict(limit=5))
top5_apps_24_hours = []
for row in results:
tmp = dict(id=row.id, name=row.name, short_name=row.short_name,
info=row.info, n_answers=row.n_answers)
top5_apps_24_hours.append(tmp)
return top5_apps_24_hours
评论列表
文章目录