用python将txt数据表转为mysql插入语句

源码下载:
https://pan.baidu.com/s/1bpKnVK7

结果截图

程序源码:

def write_sql(filename,text):
    try:
        fh = open(filename, "w", encoding="utf8")
        fh.write(text)
    except EnvironmentError as err:
        print("ERROR", err)
    else:
        print("Saved skeleton", filename)
    finally:
        if fh is not None:
            fh.close()

def read_data(filename):
    text = []
    for line in open(filename,encoding="utf8"):
        line_text = line.strip().split("\t")
        text.append(line_text)
    return text

def create_data(text,model):
    string = ""
    for t in text:
        string += model.format(t)+"\n"
    return string

read_directory = "data/"
write_directory = "sql/"

read_file = ("status.txt","admin.txt","account.txt","personinfo.txt","transaction_type.txt","transaction_log.txt")
write_file = ("status.sql","admin.sql","account.sql","personinfo.sql","transaction_type.sql","transaction_log.sql")

model = ("insert into status values({0[0]},\"{0[1]}\");",
        "insert into admin values({0[0]},\"{0[1]}\",\"{0[2]}\");",
        "insert into account values({0[0]},\"{0[1]}\",\"{0[2]}\",{0[3]},{0[4]});",
        """insert into personinfo values({0[0]},{0[1]},"{0[2]}",{0[3]},"{0[4]}",{0[5]},"{0[6]}","{0[7]}");""",
        "insert into transaction_type values({0[0]},\"{0[1]}\");",
        "insert into transaction_log values({0[0]},{0[1]},{0[2]},{0[3]},\"{0[4]}\",{0[5]});")

lens = len(read_file)
for i in range(0,lens):
    write_sql(write_directory+write_file[i],create_data(read_data(read_directory+read_file[i]),model[i]))