时间:2020-02-20来源:系统城作者:电脑系统城
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
)
完成接口执行效果如下:
2023-03-19
Centos 7.9安装MySQL8.0.32的详细教程2023-03-19
一步步教你利用Mysql存储过程造百万级数据2023-03-19
利用Mysql定时+存储过程创建临时表统计数据的过程问题描述:MYSQL version 5.6.8command 表结构 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 CREATE TABLE command ( ID INT NOT NULL, NAME VARCHAR(16), D...
2023-03-19
一、Galera Cluster 二、基础环境搭建 三、加入配置参数启动集群 四、 测试 五、ProxySql...
2023-03-17