用python生成ogg的mapcol参数

源表和目标表结构不一致，源表列比目标表多。
1 需要配对的列名称：

LIST_ID

STATUS

REAL_NAME

REASON

PERSON_TYPE

AGENT_ID

CUSTOMER_ID

SOURCE_TYPE

DELETED

2 将列写入一个txt文件，比如a.txt：
LIST_ID
STATUS
REAL_NAME
REASON
PERSON_TYPE
AGENT_ID
CUSTOMER_ID
SOURCE_TYPE
DELETED


3 使用python读取该文件，生成配对参数：

点击(此处)折叠或打开

1. with open("a.txt","r") as f:
2.     a=f.readlines()
3.     b=[]
4.     for i in a:
5.         i=i.replace("\n","")
6.         print(i, "=", i, ",")
8. for i in b:
9.    print(i,"=",i,",")

4 输出结果： LIST_ID = LIST_ID ,
STATUS = STATUS ,
REAL_NAME = REAL_NAME ,
REASON = REASON ,
PERSON_TYPE = PERSON_TYPE ,
AGENT_ID = AGENT_ID ,
CUSTOMER_ID = CUSTOMER_ID ,
SOURCE_TYPE = SOURCE_TYPE ,
DELETED = DELETED ,

5 写入参数文件。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26735168/viewspace-2132413/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26735168/viewspace-2132413/