mysql系统的数据接口_MYSQL 数据序列化Api接口

from flask import Flask

from flask import request, Response

app = Flask(__name__)

import os

def getApolloconf(k):

import requests

env = os.environ.get("RUNTIME_ENV") or "dev"

getApolloconfig = requests.get(

'http://configserver-{env}.chj.cloud/configs/op-bmc-api/default/application'.format(env=env))

data = getApolloconfig.json()["configurations"]

return data.get(k)

#######获取配置插入数据库#########

def mysqlConfig(sql):

import pymysql

import json

USERNAME = getApolloconf("USERNAME")

PASSWORD = getApolloconf("PASSWORD")

HOST = getApolloconf("HOST")

DATABASE = getApolloconf("NGINXDATABASE")

dbconfig = pymysql.connect(HOST, USERNAME, PASSWORD, DATABASE)

try:

cursor = dbconfig.cursor()

try:

cursor.execute(sql)

results = cursor.fetchall()

reultData=[]

columnList=["run_type","upstreamname","front_listen","domain_name","backend_ip"]

for row in results:

reultData.append(dict(zip(columnList, list(row))))

str1=(json.dumps(reultData, ensure_ascii=False))

return str1

except Exception as e:

pass

except Exception as err:

print(err)

def nginxtbale():

try:

sql = "select run_type,upstreamname,front_listen,domain_name,backend_ip from nginxManager_dj_nginx_conf order by create_time"

return mysqlConfig(sql)

except Exception as e:

# 如果发生错误则回滚

print(e)

@app.route('/')

def index():

import json

return Response(json.dumps(nginxtbale()), mimetype='application/json')

if __name__ == '__main__':

app.run(

host="192.168.1.1",

port=8008,

debug=True

)

完成接口执行效果如下: