import pandas
import pymysql
import config
import pandas as pd
from  pandas import DataFrame
import openpyxl
def gogo():
    writer = pd.ExcelWriter('./结果/jieguo.xlsx')

    conn = pymysql.connect(host='192.168.140.97', port=3306, user='root', passwd='Huawei@imoc123', db='eticketdb',
                           charset='utf8')

    cursor = conn.cursor()

    for i in config.lst1:
        sql1 = """
        SELECT t.TABLE_NAME,t.table_comment,c.COLUMN_NAME,c.COLUMN_COMMENT
        FROM information_schema.`COLUMNS` c
        INNER JOIN information_schema.`TABLES` t
        ON c.TABLE_NAME = t.TABLE_NAME
        AND t.table_schema like 'easyopsdb'
        AND C.TABLE_NAME='%s'
        
        """%i
        # print(sql1)
        effect_row = cursor.execute(sql1)
        re_1 = cursor.fetchall()
        # print(type(re_1))
        dt = DataFrame(re_1)
        dt.columns = ["TABLE_NAME","table_comment","COLUMN_NAME","COMLUMN_COMMENT"]
        print(dt)
        dt.to_excel(writer, sheet_name=i, index=False, startrow=1)
        writer.save()
    cursor.close()
    conn.close()
    writer.close()
try:
    gogo()
except:
    Exception()