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()