用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 textdef create_data(text,model):    string = ""    for t in text:        string += model.format(t)+"\n"    return stringread_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]))