我想在我的python脚本中添加一个进度条.我正在运行以下代码行.我正在读取一个0.195 MB的文件‘MRSTY.RRF’.我想知道已经处理了多少文件.
insert_sty = "insert into MRSTY (CUI,TUI,STN,STY,ATUI,CVF) values (:0,:1,:2,:3,:4,:5)"
records=[]
with open("../umls_files/umls-2023AA-metathesaurus-full/2023AA/META/MRSTY.RRF" , 'r') as f:
for line in f:
line = line.strip()
records.append(line.split("|"))
for sublist in records: #remove '' at the end of every element
if sublist:
sublist.pop()
for i in records:
try:
cur.execute(insert_sty,i)
print ("record inserted")
except Exception as e:
print (i)
print("Error: ",str(e))
conn.commit()
我怎样才能做到这一点呢?