• windows 定时调度datax json任务


    比较忙,好久没有写东西了。今天没啥事刚好有个小需求

    需求:后端部分数据从大数据平台抽取到数仓(以web分的8个模块几十张表吧)

    1.之前直接用txt写的python datax.py  XXX.json 发现效率贼特码低,能跑个十几二十分钟,转而用python直接写个多线程,为了方便直接吧各个模块的json放在各个模块了,反正表比较少,也懒得用线程池了。

    直接8个线程同时起飞。

    代码如下(非原代码)start.py

    import os
    import threading
    
    credit = os.listdir(r'E:dataxjobcredit')
    manage = os.listdir(r'E:dataxjobmanage')
    zcgl = os.listdir(r'E:dataxjobzcgl')
    huresources = os.listdir(r'E:dataxjobhuresources')
    retail = os.listdir(r'E:dataxjob
    etail')
    industclient = os.listdir(r'E:dataxjobindustclient')
    institution = os.listdir(r'E:dataxjobinstitution')
    investment = os.listdir(r'E:dataxjobinvestment')
    
    def credit1():
        for i in credit:
            os.system(r"python  E:dataxindatax.py E:dataxjobcredit\" + i)
    def manage1():
        for i in manage:
            os.system(r"python  E:dataxindatax.py E:dataxjobmanage\" + i)
    def zcgl1():
        for i in zcgl:
            os.system(r"python   E:dataxindatax.py E:dataxjobzcgl\" + i)
    def huresources1():
        for i in huresources:
            os.system(r"python   E:dataxindatax.py E:dataxjobhuresources\" + i)
    def retail1():
        for i in retail:
            os.system(r"python   E:dataxindatax.py E:dataxjob
    etail\" + i)
    def industclient1():
        for i in industclient:
            os.system(r"python   E:dataxindatax.py E:dataxjobindustclient\" + i)
    def institution1():
        for i in institution:
            os.system(r"python   E:dataxindatax.py E:dataxjobinstitution\" + i)
    def investment1():
        for i in investment:
            os.system(r"python  E:dataxindatax.py E:dataxjobinvestment\" + i)
    def main():
        t1 = threading.Thread(target=credit1)
        t2 = threading.Thread(target=manage1)
        t3 = threading.Thread(target=zcgl1)
        t4 = threading.Thread(target=huresources1)
        t5 = threading.Thread(target=retail1)
        t6 = threading.Thread(target=industclient1)
        t7 = threading.Thread(target=institution1)
        t8 = threading.Thread(target=investment1)
    #
        t1.start()
        t2.start()
        t3.start()
        t4.start()
        t5.start()
        t6.start()
        t7.start()
        t8.start()
    #
    if __name__ == '__main__':
        main()

    之后写了个bat

    内容python start.py  

    2.windows 中有个任务执行计划

     over

  • 相关阅读:
    参数_门店
    实现百分比和百分比的累加以及A、B、C类别的标识
    参数范围的选择
    栏目数据合并表达式
    父子维度转化为组
    从参数中获得特定字符串
    多参与多轴
    数据库链接字符串大集合
    闰年2月29天
    sum函数按照类别的值进行取值
  • 原文地址:https://www.cnblogs.com/zsf-note/p/15429462.html
Copyright © 2020-2023  润新知