首页 技术 正文
技术 2022年11月16日
0 收藏 663 点赞 3,702 浏览 2446 个字
这里没优化,只是对腾讯云下载慢日志,然后通过邮件发送出去#!/usr/bin/env python
# encoding: utf-8import json
import smtplib
import urllib2
from email.mime.text import MIMEText
from email.header import Header
from email.mime.multipart import MIMEMultipart
from QcloudApi.qcloudapi import QcloudApi
from datetime import timedelta, datetimeyesterday = datetime.today() + timedelta(-1)
yesterday_format = yesterday.strftime('%Y%m%d')log_test1_dir = '/data/logsbak/slowlog/test1/'
log_test2_dir = '/data/logsbak/slowlog/test2/'def download(url,filename):
url = url
f = urllib2.urlopen(url)
data = f.read()
with open(filename, "wb") as code:
code.write(data)def sendmail(sender,password,receivers,smtpServer,subject,content,file1,file2):
sender = sender
password = password
receivers = receivers
smtp_server = smtpServer
message = MIMEMultipart()
message['From'] = sender
message['To'] = ','.join(receivers)
message['Subject'] = subject
message.attach(MIMEText(content, 'plain', 'utf-8'))
file_test1 = log_test1_dir + file1
file_test2 = log_test2_dir + file2
att1 = MIMEText(open(file_test1, 'rb').read(), 'base64', 'utf-8')
att1["Content-Type"] = 'application/octet-stream'
att1["Content-Disposition"] = 'attachment; filename=%s' %file1
message.attach(att1)
att2 = MIMEText(open(file_test2, 'rb').read(), 'base64', 'utf-8')
att2["Content-Type"] = 'application/octet-stream'
att2["Content-Disposition"] = 'attachment; filename=%s' %file2
message.attach(att2)
server = smtplib.SMTP(smtp_server,25)
#server.set_debuglevel(1)
server.login(sender,password)
server.sendmail(sender,receivers,message.as_string())
server.quit()def qcloud_cdb_log(SecretId,SecretKey,Region):
module = 'cdb'
action = 'GetCdbExportLogUrl'
action_params = {
'cdbInstanceId':'cdb-l2lpuyjt',
'type':'slowlog_day',
}
config = {
'Region': Region,
'secretId': SecretId,
'secretKey': SecretKey,
} try:
service = QcloudApi(module, config)
cdb = json.loads(service.call(action, action_params))
return cdb['data']
except Exception as e:
import traceback
print('traceback.format_exc():\n%s' % traceback.format_exc())if __name__ == '__main__':
cdb_data = qcloud_cdb_log('sjsldjflsjdfljsljdljwejjlwjkljlwer','sldjflsjdlfjsljdfljsljfldkjslfjldsjlfjdslf','ap-beijing')
logname_test1 = cdb_data[-2]['file_name']
link_test1 = cdb_data[-2]['out_url']
slowlog_test1 = log_test1_dir + logname_test1
logname_test2 = 'test2_slowlog_' + yesterday_format + '.log'
download(link_test1,slowlog_test1)
sender = 'jiankong@test.com'
#receivers = ['lw@test.com']
receivers = ['xb@test.com']
password = ''
smtpServer = 'smtp.test.com'
subject = '慢日志'
content = '慢日志,请查看附件'
sendmail(sender,password,receivers,smtpServer,subject,content,logname_test1,logname_test2)
相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:9,083
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,558
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,407
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,180
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,816
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,899