energy-data-trans/test_run_local.py

# -*- coding: utf-8 -*-
# @Time    : 2024/6/11
# @Author  : 魏志亮
import datetime
import os
import sys
import traceback

from utils.conf.read_conf import yaml_conf, read_conf


def get_exec_data(batch_no=None, read_type=None, run_count=1):
    if batch_no and read_type:
        data = get_data_by_batch_no_and_type(batch_no, read_type)
        if data is None:
            raise ValueError(f"未找到批次号:{batch_no},类型:{read_type}")

    else:
        data = get_batch_exec_data(run_count)
        if data is None:
            trans_print("当前有任务在执行")
            sys.exit(0)
        elif len(data.keys()) == 0:
            trans_print("当前无任务")
            sys.exit(0)

    return data


def run(data: dict = dict(), save_db=False, step=0, end=4):
    exec_process = None
    if data['transfer_type'] in ['second', 'minute']:
        exec_process = MinSecTrans(data=data, save_db=save_db, step=step, end=end)

    if data['transfer_type'] in ['fault', 'warn']:
        exec_process = FaultWarnTrans(data=data, save_db=save_db, step=step, end=end)

    if exec_process is None:
        raise Exception("No exec process")
    exec_process.run()


if __name__ == '__main__':
    env = 'dev'
    if len(sys.argv) >= 2:
        env = sys.argv[1]

    conf_path = os.path.abspath(f"./conf/etl_config_{env}.yaml")
    os.environ['ETL_CONF'] = conf_path
    yaml_config = yaml_conf(conf_path)
    os.environ['env'] = env
    run_count = int(read_conf(yaml_config, "run_batch_count", 1))

    from utils.log.trans_log import trans_print
    from service.plt_service import get_batch_exec_data, get_data_by_batch_no_and_type
    from etl.wind_power.fault_warn.FaultWarnTrans import FaultWarnTrans
    from etl.wind_power.min_sec.MinSecTrans import MinSecTrans

    begin = datetime.datetime.now()
    data = dict()

    data['batch_code'] = 'xinhuashuidian'
    data['batch_name'] = '新华水电故障'
    data['transfer_type'] = 'fault'
    data['transfer_addr'] = r'D:\data\新华水电\收资数据\故障告警\汇能机组数据-故障'
    data['field_code'] = 'xinhuashuidian'
    data['field_name'] = '新华水电'
    try:
        run(data=data, save_db=False, step=0, end=3)
    except Exception as e:
        trans_print(traceback.format_exc())

    trans_print("执行结束,总耗时:", datetime.datetime.now() - begin)