有时需要获取表的栏位+数值,请参考
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)
输出结果如下: