datax-admin/app/routers/jm_job_log.py

from typing import List, Optional
from fastapi import APIRouter

from fastapi import Depends, Query
from sqlalchemy.orm import Session
from app import page_help, schemas

import app.crud as crud
from app.utils.send_util import get_job_run_status
from constants.constants import RUN_STATUS
from utils.sx_time import sxtimeit
from utils.sx_web import web_try
from fastapi_pagination import Page, add_pagination, paginate, Params

from app import get_db, get_page



router = APIRouter(
    prefix="/jpt/jm_job_log",
    tags=["jm_job_log-定时任务日志管理"],
)


@router.get("/")
@web_try()
@sxtimeit
def get_job_logs(job_id: int = None, params: Params=Depends(get_page), db: Session = Depends(get_db)):
    jm_job_list = []
    if job_id is not None:
        jm_job_list = [crud.get_jm_job_info(db, job_id)]
    else:
        jm_job_list = crud.get_jm_job_infos(db)
    id_to_job = {job.id:job for job in jm_job_list}
    relations = crud.get_af_ids(db,id_to_job.keys(), 'job')
    af_to_datax = {relation.af_id:relation.se_id for relation in relations}
    af_job_runs = crud.get_airflow_runs_by_af_job_ids(db, af_to_datax.keys())
    af_job_runs.sort(key=lambda x: x.start_time, reverse=True)
    total = len(af_job_runs)
    af_job_runs = af_job_runs[(params['page'] - 1) * params['size']:params['page'] * params['size']]
    res = []
    for af_job_run in af_job_runs:
        tasks = list(af_job_run.details['tasks'].values()) if len(list(af_job_run.details['tasks'].values()))>0 else []
        if len(tasks) > 0:
            task = tasks[-1]
            task.pop('log',None)
            job_id = af_to_datax[int(af_job_run.job_id)]
            execute_result = None
            if af_job_run.status <= 1:
                run_status = get_job_run_status(af_job_run.id)
                execute_result = run_status['data']['status']
            log = {
                "id": af_job_run.id,
                "job_id": job_id,
                "job_name": id_to_job[job_id].name,
                "job_type": id_to_job[job_id].type,
                "job_tag": id_to_job[job_id].tag,
                "af_job_id": int(af_job_run.job_id),
                "run_id": af_job_run.af_run_id,
                "trigger_time": af_job_run.start_time,
                "trigger_result": 1,
                "execute_time": task['start_time'] if task else 0,
                "execute_result": execute_result if execute_result else af_job_run.status,
                "end_time": task['end_time'] if task else 0,
            }
            res.append(log)
    return page_help(res,params['page'],params['size'],total)

@router.get("/logs")
@web_try()
@sxtimeit
def get_job_log_once(run_id: str, db: Session = Depends(get_db)):
    af_job_run = crud.get_airflow_run_once(db, run_id)
    tasks = list(af_job_run.details['tasks'].values()) if len(list(af_job_run.details['tasks'].values()))>0 else []
    res = []
    for task in tasks:
        log = {
            "id": af_job_run.id,
            "af_job_id": int(af_job_run.job_id),
            "run_id": af_job_run.af_run_id,
            "trigger_time": af_job_run.start_time,
            "trigger_result": 1,
            "execute_time": task['start_time'] if task else 0,
            "execute_result": af_job_run.status,
            "end_time": task['end_time'] if task else 0,
            "log": task['log'] if task else None
        }
        res.append(log)
    res.sort(key=lambda x: x['trigger_time'], reverse=True)
    return res

@router.get("/logs_status/{ids}")
@web_try()
@sxtimeit
def get_job_log_status(ids: str):
    run_ids = ids.split(',')
    id_to_status = {}
    for run_id in run_ids:
        res = get_job_run_status(run_id)
        id_to_status.update({run_id:res['data']['status']})
    return id_to_status