pod及rds每日信息收集

1. 前言：

通过top命令收集pod的cpu及内存信息，每30秒收集一次，插入数据库进行数据存储。
通过阿里云接口来收集rds的相关信息

一、定义模型（表）

所有pod信息表
pod_all_info

pod实时数据表
pod_realtime_date_202012

pod数据计算邮件表
pod_day_info

所有rds信息表
rds_all_info

实时数据表
rds_*_info_202012

数据计算邮件表
rds_day_info

二、邮件及数据库连接池引用

send_email.py

#!/usr/bin/env python
# encoding=utf-8
from email.mime.image import MIMEImage
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
import smtplib


class SendEmail(object):
    # 构造函数：初始化基本信息
    def __init__(self, host, user, passwd):
        self._user = user
        self._account = user
        server = smtplib.SMTP_SSL(host, 465)
        #server.connect(host)
        server.login(self._account, passwd)
        self._server = server
        # 发送文件或html邮件

    def sendTxtMail(self, to_list, sub, content, subtype='html'):
        # 如果发送的是文本邮件，则_subtype设置为plain
        # 如果发送的是html邮件，则_subtype设置为html
        msg = MIMEText(content, _subtype=subtype, _charset='utf-8')
        msg['Subject'] = sub
        msg['From'] = self._user
        msg['To'] = ",".join(to_list)
        try:
            self._server.sendmail(self._user, to_list, msg.as_string())
            print("mail has been send successfully.")
            return True
        except Exception as e:
            print(str(e))
            return False

    # 发送带附件的文件或html邮件
    def sendAttachMail(self, to_list, sub, content ,file_ ,filename, subtype='html'):
        # 创建一个带附件的实例
        msg = MIMEMultipart()
        # 增加附件1
        att1 = MIMEText(open(r'%s'%file_, 'rb').read(), 'base64', 'utf-8')
        att1["Content-Type"] = 'application/octet-stream'
        # 这里的filename可以任意写，写什么名字，邮件中显示什么名字
        att1["Content-Disposition"] = 'attachment; filename="%s"'%filename
        msg.attach(att1)
        # 增加邮件内容
        msg.attach(MIMEText(content, _subtype=subtype, _charset='utf-8'))

        msg['Subject'] = sub
        msg['From'] = self._user
        msg['To'] = ";".join(to_list)

        try:
            self._server.sendmail(self._user, to_list, msg.as_string())
            print("mail has been send successfully.")
            return True
        except Exception as e:
            print(str(e))
            return False

    # 发送图片附件或html邮件
    def sendImageMail(self, to_list, sub, content, file_, subtype='html'):
        # 创建一个带附件的实例
        msg = MIMEMultipart()
        # 增加邮件内容
        msg.attach(MIMEText(content, _subtype=subtype, _charset='utf-8'))
        # 增加图片附件
        image = MIMEImage(open(r'%s'%file_, 'rb').read())
        # 附件列表中显示的文件名
        image.add_header('Content-Disposition', 'attachment;filename=p.jpg')
        msg.attach(image)
        msg['Subject']