datax安装及批量生成json任务文件，以sqlservrreader和mysqlwriter为例_datax的json文件自动生成

}
],
“setting”: {
“speed”: {
“channel”: “5”
}
}
}
}

def get_config():
import configparser
file = ‘prod\datax.ini’
con = configparser.ConfigParser()
con.read(file, encoding=‘utf-8-sig’)
sections = con.sections()

获取特定section

items_sqlserver = con.items(‘sqlserver’) # 返回结果为元组
config_sqlserver = dict(items_sqlserver)

items_mysql = con.items(‘mysql’) # 返回结果为元组
config_mysql = dict(items_mysql)

key 只能是小写

return {‘config_sqlserver’:config_sqlserver,‘config_mysql’:config_mysql}

if name == ‘main’:
config = get_config()

sqlserver reader

datax_json[‘job’][‘content’][0][‘reader’][‘parameter’][‘connection’][0][‘jdbcUrl’].append(config[‘config_sqlserver’][‘url’])
datax_json[‘job’][‘content’][0][‘reader’][‘parameter’][‘connection’][0][‘table’].append(config[‘config_sqlserver’][‘table’])
datax_json[‘job’][‘content’][0][‘reader’][‘parameter’][‘password’] = config[‘config_sqlserver’][‘password’]
datax_json[‘job’][‘content’][0][‘reader’][‘parameter’][‘username’] = config[‘config_sqlserver’][‘username’]
datax_json[‘job’][‘content’][0][‘reader’][‘parameter’][‘where’] = config[‘config_sqlserver’][‘where’]
datax_json[‘job’][‘content’][0][‘reader’][‘parameter’][‘column’] = list(config[‘config_sqlserver’][‘column’].split(‘,’))

mysql writer

datax_json[‘job’][‘content’][0][‘writer’][‘parameter’][‘connection’][0][‘jdbcUrl’] = config[‘config_mysql’][‘url’]
datax_json[‘job’][‘content’][0][‘writer’][‘parameter’][‘connection’][0][‘table’].append(config[‘config_mysql’][‘table’])
datax_json[‘job’][‘content’][0][‘writer’][‘parameter’][‘password’] =