脚本小子-------使用python脚本完成mysql数据库备份、恢复、查询并生成excel

一颗胖大海

于 2019-10-27 09:54:13 发布

阅读量807

点赞数 5

文章标签： python pycharm pymsql xlwt

本文链接：https://blog.youkuaiyun.com/m0_37673800/article/details/102763945

版权

主要使用到的模块：pymysql、xlwt、paramiko、os 。

废话不多说，直接贴代码。

# conding=utf-8
# Version:python3.7
# Tools:Pycharm 2019.2.1
__date__ = "2019/10/26 上午9:29"
__author__ = "HANHAN"

import pymysql
import xlwt
import paramiko
import os, datetime

sql = """select VM_DOMAIN_NAME as 虚拟机名, avg(CPU_AVERAGE_RATE) as cpu利用率平均值 ,AVG(CPU_MAX) as cpu利用率峰值,avg(MEMORY_AVERAGE_RATE) as 内存利用率平均值,AVG(MEMORY_MAX ) 内存利用率峰值 FROM 
(SELECT
TBL_DOMAIN_HOUR_STAT.ID,
TBL_DOMAIN_HOUR_STAT.CLUSTER_ID,
TBL_HOST.`NAME` AS CVK_HOSTNAME,
TBL_DOMAIN.TITLE AS VM_DOMAIN_NAME,
TBL_DOMAIN_HOUR_STAT.TIME,
DATE_FORMAT(TBL_DOMAIN_HOUR_STAT.TIME,'%H:%i') AS Hour_Stamp,
DATE_FORMAT(TBL_DOMAIN_HOUR_STAT.TIME,'%Y-%m-%d %H:%i') AS Time_Stamp,
TBL_DOMAIN_HOUR_STAT.CPU AS CPU_AVERAGE_RATE,
TBL_DOMAIN_HOUR_STAT.CPU_MAX,
TBL_DOMAIN_HOUR_STAT.CPU_MIN,
TBL_DOMAIN_HOUR_STAT.MEMORY AS MEMORY_AVERAGE_RATE,
TBL_D