后台任务中 alarm.py、monitor.py 中。
sql = (
"select job.status,submit.benchmark_id,benchmark.name,count(*) from job,submit,benchmark where "
"job.created_at>'{}' and job.submit_id=submit.id and submit.benchmark_id=benchmark.id group by "
"submit.benchmark_id,benchmark.name,job.status".format(start_date)
)
sql = (
"select benchmark.id,benchmark.name,count(*) from submit,benchmark "
"where submit.benchmark_id=benchmark.id "
"and submit.created_at>'{}' group by benchmark.id,benchmark.name".format(start_date)
)
sql = (
"select benchmark.id,benchmark.name,count(*) from submit,submit_result,benchmark where "
"submit.id=submit_result.submit_id and submit.benchmark_id=benchmark.id "
" and submit_result.result LIKE '{"
+ "}' and submit.created_at>"
+ "'{}' group by benchmark.id,benchmark.name".format(start_date)
)
sql = (
"select benchmark.id,benchmark.name,count(*) from submit,submit_result,benchmark where "
"submit.id=submit_result.submit_id and submit.benchmark_id=benchmark.id "
"and submit_result.result NOT LIKE "
"'{" + "}' and submit.created_at>" + "'{}' group by benchmark.id,benchmark.name".format(start_date)
)
sql = (
"select TO_SECONDS(job.created_at)-TO_SECONDS(submit.created_at) from job,submit where "
"job.submit_id=submit.id and job.created_at>date_sub(STR_TO_DATE( "
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s'),interval 1 hour) and job.created_at<STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s') "
)
sql = (
"select TO_SECONDS(submit_at)-TO_SECONDS(created_at) from job where submit_at>date_sub(STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s'),interval 1 hour) and submit_at<STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s') "
)
sql = (
"select TO_SECONDS(running_at)-TO_SECONDS(submit_at) from job where running_at>date_sub(STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s'),interval 1 hour) and running_at<STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s') and submit_at is not null "
)
sql = (
"select TO_SECONDS(job.running_at)-TO_SECONDS(submit.created_at) from job,submit where "
"job.submit_id=submit.id and job.running_at>date_sub(STR_TO_DATE( "
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s'),interval 1 hour) and job.running_at<STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s')"
)
sql = (
"select TO_SECONDS(finish_at)-TO_SECONDS(running_at) from job where finish_at>date_sub(STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s'),interval 1 hour) and finish_at<STR_TO_DATE("
"DATE_FORMAT(NOW(), '%Y-%m-%d %H:00:00'), '%Y-%m-%d %H:%i:%s') and running_at is not null "
)