pymysql查询每个库存储空间

import pymysql


class DB(object):

    def __init__(self,user,password,host,database):
        self.user = user
        self.password = password
        self.host = host
        self.database = database
        try:
            self.db = pymysql.connect("%s"%host, "%s"%user, "%s"%password, "%s"%database)
        except Exception as e:
            print(e)

    def get_data(self):
        #con = pymysql.connect(host=self.host, user=self.user, password=self.password, database=self.database)
        sql = "show databases"
        cursor = self.db.cursor()
        cursor.execute(sql)
        results = cursor.fetchall()
        dists = {}
        for i in results:
            sql = "select concat(round(sum(data_length)/(1024*1024),2) + round(sum(index_length)/(1024*1024),2)) as 'DB' from tables where table_schema='%s'; "%(i[0])
            cursor.execute(sql)
            results = cursor.fetchall()
            try:
                dists[i[0]] = float(results[0][0])
            except:
                dists[i[0]] = 0
        cursor.close()
        self.db.close()
        #print(dists)
        distss = sorted(dists.items(), key=lambda x: x[1])
        #print(distss)
        for i in distss:
            print(i[0],str(i[1])+'MB')

if __name__ == "__main__":
    host = 'aliyuncs.com'
    user = 'gcbx'
    password = 'super'
    database = 'information_schema'
    db = DB(user,password,host,database)
    db.get_data()