shell批量生成格式化json文件

vim table_js.sh
#!/bin/bash
j=0
for i in `cat table_name.txt`
do
	cat >> seq_ta1 <<EOF
            "$i":{
                "TableName": "$i",
                "NewTableName": "bare name",
		"filterType": "black"
            },
EOF
	let j+=1
done
	sum=`echo $j*5+8 |bc`
	sed  '8r seq_ta1' js_muban > dts_json
        sed  -i ''$sum' s/,//'  dts_json

json 模板文件

{
    {
        "DBName": "待迁移的库名",
        "NewDBName": "待迁移的库在目标实例中映射的库名",
        "SchemaName": "待迁移的Schema名",
        "NewSchemaName": "待迁移的Schema在目标实例中映射的Schema名",
        "AllTable": false,
        "Table": {
        }
    }
}

将需要json格式的表名填入table_name.txt文件中

生成方式：

chmod +x table_js.sh && sh table_js.sh