python自动获取邮件数据_Python-从邮件中提取内容并插入数据库

importosfrom email importmessage_from_fileimportreimporthashlibimportjsonimportpymssqldefparseEmail(file):

with open(file) as f:

name=f.name

msg=message_from_file(f)

target_text=msg.get_payload()[0].get_payload()#Timestamp: 2020-07-30 00:00:00 (UTC)

#Koality_AutoDQ4_OnePipeline_OfficeForms

timestamp = re.findall("Timestamp: (\d{4}-\d{1,2}-\d{1,2})",target_text)[0]

dataset= re.findall("Dataset: .+_.+_.+_(.+_*\w+)

unique_dataset_name= re.findall("Dataset: (.+_.+_.+_.+)

metrics= re.findall("Metrics[:=]\n*(.+\n*.+)\n*<=*\n*h", target_text)[0]

metrics= metrics.replace('\n', '').replace('=','').replace(':', '')#Koality_AutoDQ4_OA-OXO_Teams_DoD, whose dataset is Teams_DoD instaed of DoD