def get_log_list(cls,
page=1,
size=20,
status=None,
project=None,
spider=None,
schedule_job_id=None):
"""调度日志列表"""
query = ScheduleHistoryModel.select()
if project:
query = query.where(ScheduleHistoryModel.project == project)
if spider:
query = query.where(ScheduleHistoryModel.spider == spider)
if schedule_job_id:
query = query.where(
ScheduleHistoryModel.schedule_job_id == schedule_job_id)
if status == 'success':
query = query.where(ScheduleHistoryModel.spider_job_id != '')
elif status == 'error':
query = query.where(ScheduleHistoryModel.spider_job_id == '')
rows = query.order_by(
ScheduleHistoryModel.create_time.desc()).paginate(page,
size).dicts()
return rows
def get_log_total_count(cls, project=None, spider=None, schedule_job_id=None):
"""计算日志总条数"""
query = ScheduleHistoryModel.select()
if project:
query = query.where(ScheduleHistoryModel.project == project)
if spider:
query = query.where(ScheduleHistoryModel.spider == spider)
if schedule_job_id:
query = query.where(ScheduleHistoryModel.schedule_job_id == schedule_job_id)
return query.count()
def get_log_success_count(cls, project=None, spider=None, schedule_job_id=None):
"""计算成功日志条数"""
query = ScheduleHistoryModel.select()
if project:
query = query.where(ScheduleHistoryModel.project == project)
if spider:
query = query.where(ScheduleHistoryModel.spider == spider)
if schedule_job_id:
query = query.where(ScheduleHistoryModel.schedule_job_id == schedule_job_id)
query = query.where(ScheduleHistoryModel.spider_job_id != '')
return query.count()