1 回答

TA贡献2037条经验 获得超6个赞
您可以使用zip()从数据库和文件中获取数据,您必须在其中写入这些数据。
它可能是这样的
database = open("database", "r")
# read all to memory to use it many times in `for` loop
template = list(open("template", "r"))
outfile1 = open("junk1", "w")
outfile2 = open("junk2", "w")
outfile3 = open("junk3", "w")
for line, output in zip(database, [outfile1, outfile2, outfile3]):
part = line.split("|")
title = part[0] #replaces #1
firstname = part[1] #replaces #2
lastname = part[2] #replaces #3
address = part[3] #replaces #4
city = part[4] #replaces #5
state = part[5] #replaces #6
zipcode = part[6] #replaces #7
for string in template:
for r in (("|1|", title),("|2|", firstname),("|3|", lastname),("|4|", address),("|5|", city),("|6|", state),("|7|", zipcode)):
string = string.replace(*r)
output.write(string)
outfile1.close()
outfile2.close()
outfile3.close()
使用zip()第一个文件从数据库中获取第一行并使用第一个数据填充模板并保存在第一个文件中,然后使用第二个文件从数据库中获取第二行并使用第二个数据填充模板并保存在第二个文件中,等等。
添加回答
举报