pymysql 单独获取表的栏位名称

有时需要获取表的栏位+数值，请参考

https://www.cnblogs.com/xibuhaohao/p/9996571.html

有时只需要栏位名称，那么可以使用

col=self.cursor.description

脚本如下：

[dba@wanliu-jx-db-218 monitor]$ cat mysql_ccpay.py
#coding=utf-8
import sys
import pymysql
import os
#from prometheus_client import Gauge,start_http_server
import time

#v_host=os.popen('echo $HOSTNAME')
#hostname=v_host.read()
#hstname="".join(hostname)
#print(hostname.strip())

class MySQL_Status_Output:
    def __init__(self,host,port,user,password):
        try:
            self.db = pymysql.connect(host=host,port=port,user=user,password=password)
            self.cursor = self.db.cursor()
        except Exception as e:
            print('Wrong')
            print(e)
    def mysql_select_sql(self,sql):
        try:
            self.cursor.execute(sql)
            col=self.cursor.description
            v_result=self.cursor.fetchall()
            return v_result,col
        except Exception as e:
            print(e)
    def close(self):
        self.db.close()

if __name__ == "__main__":
    #start_http_server(9500)
    #ccpayGauge = Gauge('ccpayGauge','Description of gauge', ['mylabelname'])
    while True:
        time.sleep(10)
        try:
            pro_db = MySQL_Status_Output('127.0.0.1',3306,'dbadmin','dbadmin')
            ccpay_machine_enable,col_name = pro_db.mysql_select_sql(" select id '序号',name '姓名',age '年龄' from test.test ")
            pro_db.close()
            col_name_list=[]
            ccpay_machine_enable_name=[]
            for i in range(len(col_name)):
                col_name_list.append(col_name[i][0])
            print(tuple(col_name_list))
            col_name_tuple=tuple(col_name_list)
            for j in range(len(ccpay_machine_enable)):
                ccpay_machine_enable_name=ccpay_machine_enable[j]
                print(ccpay_machine_enable_name)
                me = dict(zip(col_name_tuple,ccpay_machine_enable_name))
                print(me)
        except Exception as e:
            print('Is Wrong')
            print(e)

输出结果如下：

 

转载于:https://www.cnblogs.com/xibuhaohao/p/10003547.html