py+datax自动生成job，自动bat方式批处理运行job

最新推荐文章于 2024-11-12 23:15:59 发布

回到未来望过去

最新推荐文章于 2024-11-12 23:15:59 发布

阅读量1.2k

点赞数 26

分类专栏： oceanbase python 文章标签： python datax oceanbase oracle

本文链接：https://blog.csdn.net/viviliving/article/details/142815996

版权

1、批处理传入表结构所在的oracle库用户名、表名，连接串

echo 调用参数:.py connusername connuserpass dbconn username tablename oboracle
python pyorajobarg.py xmgl xmgl 10.***:1521/test EINP_TREATMENT AC60 oboracle

运行后即可生成job.json文件，和自动调用datax运行job的bat批处理文件

{
  "job": {
    "setting": {
      "speed": {
        "channel": $speedchannel,
        "byte": $speedbyte
      },
      "errorLimit": {
        "record": $errrecord,
        "percentage": $errpercentage
      }
    },
    "content": [
      {
        "reader": {
          "name": "oceanbasev10reader",
          "parameter": {
            "username": "$susername",
            "password": "$spass",
            "column": [
            
                
                    "BAZ001",

                 
                    "BAZ002",

                 
                    "AAZ821",

                 
                    "AAZ257",

                 
                    "AAZ172",

                 
                    "AAZ099",

                 
                    "AAC001",

                 
                    "AJC039",

                 
                    "AAE127",

                 
                    "AAC242",

                 
                    "AAC260",

                 
                    "AAC015",

                 
                    "ACA111",

                 
                    "ACA112",

                 
                    "ACA113",

                 
                    "AAB118",

                 
                    "AAC187",

                 
                    "AAE001",

                 
                    "AJC024",

                 
                    "AJC120",

                 
                    "AAZ159",

                 
                    "AAE100",

                 
                    "AAE011",

                 
                    "AAE036",

                 
                    "AAB034",

                 
                    "BZE011",

                 
                    "BZE036",

                 
                    "BZE034",

                 
                    "AAA027",

                 
                    "AAE013",

                 
                    "BZE300",

                 
                    "AJC121",

                 
                    "AJC122",

                 
                    "AJC123",

                 
                    "AJC049"
                 
              
            ],

最低0.47元/天解锁文章