hive2excel.py 文件源码

def send_email(subject, content, excel_path, receivers_array):
    contype = 'application/octet-stream'
    maintype, subtype = contype.split('/', 1)
    server = smtplib.SMTP_SSL(host=configUtil.get("email.host"),port=configUtil.get("email.port"))
    server.login(configUtil.get("email.username"), configUtil.get("email.password"))
    main_msg = MIMEMultipart()
    text_msg = MIMEText(content, 'plain', "utf-8")
    # email text
    main_msg.attach(text_msg)
    #  email attach
    print "excel path:" + str(excel_path)
    data = open(excel_path, 'rb')
    attach = MIMEText(data.read(), 'base64', 'gb2312')
    basename = os.path.basename(excel_path)
    attach["Content-Type"] = 'application/octet-stream'
    attach.add_header('Content-Disposition', 'attachment', filename=basename.encode("gb2312"))
    main_msg.attach(attach)
    main_msg["Accept-Language"] = "zh-CN"
    main_msg["Accept-Charset"] = "utf-8"
    main_msg['From'] = configUtil.get("email.username")
    main_msg['To'] = ",".join(receivers_array)
    main_msg['Subject'] = subject
    full_text = main_msg.as_string()
    server.sendmail(configUtil.get("email.username"), receivers_array, full_text)
    server.quit()