VisibleLoadMonitor/webServer.py at master · didi909/VisibleLoadMonitor · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
# -*- coding: utf-8 -*-
#__author__="ZJL"

from flask import Flask
from flask import request
from flask import Response
import pymysql
import configparser
import json
import time
import datetime
import random


#读取数据库配置文件
db = configparser.ConfigParser()
db.read('conf/database.conf')

host=db.get('db', 'host')
port=db.get('db', 'port')
user=db.get('db', 'user')
passwd=db.get('db', 'pass')
dbname=db.get('db', 'dbname')

# host=db.get('db1', 'host')
# port=db.get('db1', 'port')
# user=db.get('db1', 'user')
# passwd=db.get('db1', 'pass')
# dbname=db.get('db1', 'dbname')

class initCPUInfo:
    def __init__(self,initRow):
        self.initRow=initRow

    def initDataByRownum(self):
        # 打开数据库连接
        db = pymysql.connect(host,user,passwd,dbname)
        # 使用cursor()方法获取操作游标
        cursor = db.cursor()
        # SQL 插入语句
        sql = """select concat('{"name":"',createtime,'","value":["',createtime,'",',cpuload,']}')
                  from cpuinfo order by createtime desc limit %d;""" % \
                        (self.initRow)
        try:
            # 执行sql语句
            cursor.execute(sql)
            # 获取所有记录列表
            results = cursor.fetchall()
            # for row in results:
            #     content = row[0]
            #     # 打印结果
            #     print ("content=%s" % (content))
            # 提交到数据库执行
            db.commit()
            return results
        except Exception as e:
           # Rollback in case there is any error
           #print 'str(e):\t\t', str(e)
           print (str(e))
           db.rollback()
        # 关闭数据库连接
        db.close()

class getOSInfo:
    def __init__(self,hostName,startTime):
        self.hostName=hostName
        self.startTime=startTime

    def getCpuInfoByCreateTime(self):
        # 打开数据库连接
        db = pymysql.connect(host,user,passwd,dbname)
        # 使用cursor()方法获取操作游标
        cursor = db.cursor()
        # SQL 插入语句
        sql = """select concat('{"name":"',createtime,'","value":["',createtime,'",',cpuload,']}')
                  from cpuinfo where hostname = '%s' and createtime >= '%s';""" % \
                        (self.hostName,self.startTime)
        try:
            # 执行sql语句
            cursor.execute(sql)
            # 获取所有记录列表
            results = cursor.fetchall()
            # for row in results:
            #     content = row[0]
            #     # 打印结果
            #     print ("content=%s" % (content))
            # 提交到数据库执行
            db.commit()
            return results
        except Exception as e:
           # Rollback in case there is any error
           #print 'str(e):\t\t', str(e)
           print (str(e))
           db.rollback()
        # 关闭数据库连接
        db.close()

    def getMemInfoByCreateTime(self):
        # 打开数据库连接
        db = pymysql.connect(host,user,passwd,dbname)
        # 使用cursor()方法获取操作游标
        cursor = db.cursor()
        # SQL 插入语句
        sql = """select concat('{"name":"',createtime,'","value":["',createtime,'",',cpuload,']}')
                  from meminfo where hostname = '%s' and createtime >= '%s';""" % \
                        (self.hostName,self.startTime)
        try:
            # 执行sql语句
            cursor.execute(sql)
            # 获取所有记录列表
            results = cursor.fetchall()
            # for row in results:
            #     content = row[0]
            #     # 打印结果
            #     print ("content=%s" % (content))
            # 提交到数据库执行
            db.commit()
            return results
        except Exception as e:
           # Rollback in case there is any error
           #print 'str(e):\t\t', str(e)
           print (str(e))
           db.rollback()
        # 关闭数据库连接
        db.close()

app = Flask(__name__)

data = {}

def Response_headers(content):
    resp = Response(content)
    resp.headers['Access-Control-Allow-Origin'] = '*'
    return resp

@app.route('/')
def hello_world():
    return Response_headers('hello world')

@app.route('/echarts')
def echarts():
    datas = {
        "data":[
            {"name":"allpe","num":60},
            {"name":"peach","num":45},
            {"name":"Pear","num":137},
            {"name":"avocado","num":22},
            {"name":"cantaloupe","num":64},
            {"name":"Banana","num":28},
            {"name":"Grape","num":80},
            {"name":"apricot","num":225},
            {"name":"HWZ","num":25}
        ]
    }
    content = json.dumps(datas)
    resp = Response_headers(content)
    return resp

@app.route('/echarts0')
def echarts0():


    #获取延迟5秒数据
    a=initCPUInfo(12)
    sqlResult = a.initDataByRownum()

    # print(sqlResult)
    for row in sqlResult:
        rowResult = str(row[0],encoding='utf-8')
        newStr = newStr + str(rowResult) + ','
        # print(str(row[0],encoding='utf-8'))
        # print ("content=%s" % ((newStr)))

    newStr = newStr[:-1]
    content = '''{"data": ['''+newStr+']}'
    # datas = {"data": [{"name":"1998-09-03 00:01:06","value":["1998-09-03 00:01:06",0.81]},{"name":"1998-09-03 00:01:07","value":["1998-09-03 00:01:07",0.05]},{"name":"1998-09-03 00:01:08","value":["1998-09-03 00:01:08",0.07]},{"name":"1998-09-03 00:01:09","value":["1998-09-03 00:01:09",0.84]},{"name":"1998-09-03 00:01:10","value":["1998-09-03 00:01:10",0.81]},{"name":"1998-09-03 00:01:11","value":["1998-09-03 00:01:11",0.54]},{"name":"1998-09-03 00:01:12","value":["1998-09-03 00:01:12",0.93]},{"name":"1998-09-03 00:01:13","value":["1998-09-03 00:01:13",0.57]},{"name":"1998-09-03 00:01:14","value":["1998-09-03 00:01:14",0.91]},{"name":"1998-09-03 00:01:15","value":["1998-09-03 00:01:15",0.16]},{"name":"1998-09-03 00:01:16","value":["1998-09-03 00:01:16",0.68]},{"name":"1998-09-03 00:01:17","value":["1998-09-03 00:01:17",0.00]},{"name":"1998-09-03 00:01:18","value":["1998-09-03 00:01:18",0.50]},{"name":"1998-09-03 00:01:19","value":["1998-09-03 00:01:19",0.46]},{"name":"1998-09-03 00:01:20","value":["1998-09-03 00:01:20",0.88]},{"name":"1998-09-03 00:01:21","value":["1998-09-03 00:01:21",0.05]},{"name":"1998-09-03 00:01:22","value":["1998-09-03 00:01:22",0.25]},{"name":"1998-09-03 00:01:23","value":["1998-09-03 00:01:23",0.34]},{"name":"1998-09-03 00:01:24","value":["1998-09-03 00:01:24",0.50]},{"name":"1998-09-03 00:01:25","value":["1998-09-03 00:01:25",0.93]},{"name":"1998-09-03 00:01:26","value":["1998-09-03 00:01:26",0.53]},{"name":"1998-09-03 00:01:27","value":["1998-09-03 00:01:27",0.05]},{"name":"1998-09-03 00:01:28","value":["1998-09-03 00:01:28",0.61]},{"name":"1998-09-03 00:01:29","value":["1998-09-03 00:01:29",0.72]},{"name":"1998-09-03 00:01:30","value":["1998-09-03 00:01:30",0.13]},{"name":"1998-09-03 00:01:31","value":["1998-09-03 00:01:31",0.20]},{"name":"1998-09-03 00:01:32","value":["1998-09-03 00:01:32",0.90]},{"name":"1998-09-03 00:01:33","value":["1998-09-03 00:01:33",0.30]},{"name":"1998-09-03 00:01:34","value":["1998-09-03 00:01:34",0.42]},{"name":"1998-09-03 00:01:35","value":["1998-09-03 00:01:35",0.08]},{"name":"1998-09-03 00:01:36","value":["1998-09-03 00:01:36",0.61]},{"name":"1998-09-03 00:01:37","value":["1998-09-03 00:01:37",0.34]},{"name":"1998-09-03 00:01:38","value":["1998-09-03 00:01:38",0.73]},{"name":"1998-09-03 00:01:39","value":["1998-09-03 00:01:39",0.46]},{"name":"1998-09-03 00:01:40","value":["1998-09-03 00:01:40",0.51]},{"name":"1998-09-03 00:01:41","value":["1998-09-03 00:01:41",0.44]},{"name":"1998-09-03 00:01:42","value":["1998-09-03 00:01:42",0.90]},{"name":"1998-09-03 00:01:43","value":["1998-09-03 00:01:43",0.16]},{"name":"1998-09-03 00:01:44","value":["1998-09-03 00:01:44",0.34]},{"name":"1998-09-03 00:01:45","value":["1998-09-03 00:01:45",0.76]},{"name":"1998-09-03 00:01:46","value":["1998-09-03 00:01:46",0.70]},{"name":"1998-09-03 00:01:47","value":["1998-09-03 00:01:47",0.70]},{"name":"1998-09-03 00:01:48","value":["1998-09-03 00:01:48",0.41]},{"name":"1998-09-03 00:01:49","value":["1998-09-03 00:01:49",0.07]},{"name":"1998-09-03 00:01:50","value":["1998-09-03 00:01:50",0.64]},{"name":"1998-09-03 00:01:51","value":["1998-09-03 00:01:51",0.84]},{"name":"1998-09-03 00:01:52","value":["1998-09-03 00:01:52",0.37]},{"name":"1998-09-03 00:01:53","value":["1998-09-03 00:01:53",0.76]},{"name":"1998-09-03 00:01:54","value":["1998-09-03 00:01:54",0.96]},{"name":"1998-09-03 00:01:55","value":["1998-09-03 00:01:55",0.35]},{"name":"1998-09-03 00:01:56","value":["1998-09-03 00:01:56",0.75]},{"name":"1998-09-03 00:01:57","value":["1998-09-03 00:01:57",0.78]},{"name":"1998-09-03 00:01:58","value":["1998-09-03 00:01:58",0.80]},{"name":"1998-09-03 00:01:59","value":["1998-09-03 00:01:59",0.30]},{"name":"1998-09-03 00:02:00","value":["1998-09-03 00:02:00",0.69]},{"name":"1998-09-03 00:02:01","value":["1998-09-03 00:02:01",0.25]},{"name":"1998-09-03 00:02:02","value":["1998-09-03 00:02:02",0.39]},{"name":"1998-09-03 00:02:03","value":["1998-09-03 00:02:03",0.36]},{"name":"1998-09-03 00:02:04","value":["1998-09-03 00:02:04",0.28]},{"name":"1998-09-03 00:02:05","value":["1998-09-03 00:02:05",0.23]},{"name":"1998-09-03 00:02:06","value":["1998-09-03 00:02:06",0.62]},{"name":"1998-09-03 00:02:07","value":["1998-09-03 00:02:07",0.06]},{"name":"1998-09-03 00:02:08","value":["1998-09-03 00:02:08",0.44]},{"name":"1998-09-03 00:02:09","value":["1998-09-03 00:02:09",0.71]},{"name":"1998-09-03 00:02:10","value":["1998-09-03 00:02:10",0.43]},{"name":"1998-09-03 00:02:11","value":["1998-09-03 00:02:11",0.31]},{"name":"1998-09-03 00:02:12","value":["1998-09-03 00:02:12",0.58]},{"name":"1998-09-03 00:02:13","value":["1998-09-03 00:02:13",0.43]},{"name":"1998-09-03 00:02:14","value":["1998-09-03 00:02:14",0.23]},{"name":"1998-09-03 00:02:15","value":["1998-09-03 00:02:15",0.23]},{"name":"1998-09-03 00:02:16","value":["1998-09-03 00:02:16",0.96]},{"name":"1998-09-03 00:02:17","value":["1998-09-03 00:02:17",0.16]},{"name":"1998-09-03 00:02:18","value":["1998-09-03 00:02:18",0.44]},{"name":"1998-09-03 00:02:19","value":["1998-09-03 00:02:19",0.42]},{"name":"1998-09-03 00:02:20","value":["1998-09-03 00:02:20",0.38]},{"name":"1998-09-03 00:02:21","value":["1998-09-03 00:02:21",0.59]},{"name":"1998-09-03 00:02:22","value":["1998-09-03 00:02:22",0.49]},{"name":"1998-09-03 00:02:23","value":["1998-09-03 00:02:23",0.78]},{"name":"1998-09-03 00:02:24","value":["1998-09-03 00:02:24",0.24]},{"name":"1998-09-03 00:02:25","value":["1998-09-03 00:02:25",0.45]},{"name":"1998-09-03 00:02:26","value":["1998-09-03 00:02:26",0.62]},{"name":"1998-09-03 00:02:27","value":["1998-09-03 00:02:27",0.69]},{"name":"1998-09-03 00:02:28","value":["1998-09-03 00:02:28",0.62]},{"name":"1998-09-03 00:02:29","value":["1998-09-03 00:02:29",0.66]},{"name":"1998-09-03 00:02:30","value":["1998-09-03 00:02:30",0.61]},{"name":"1998-09-03 00:02:31","value":["1998-09-03 00:02:31",0.95]},{"name":"1998-09-03 00:02:32","value":["1998-09-03 00:02:32",0.13]},{"name":"1998-09-03 00:02:33","value":["1998-09-03 00:02:33",0.78]},{"name":"1998-09-03 00:02:34","value":["1998-09-03 00:02:34",0.49]},{"name":"1998-09-03 00:02:35","value":["1998-09-03 00:02:35",0.50]},{"name":"1998-09-03 00:02:36","value":["1998-09-03 00:02:36",0.76]},{"name":"1998-09-03 00:02:37","value":["1998-09-03 00:02:37",0.16]},{"name":"1998-09-03 00:02:38","value":["1998-09-03 00:02:38",0.75]},{"name":"1998-09-03 00:02:39","value":["1998-09-03 00:02:39",0.06]},{"name":"1998-09-03 00:02:40","value":["1998-09-03 00:02:40",0.31]}]}
    print(content)

    # content = json.dumps(datas)  #dumps是将dict转化成str格式，loads是将str转化成dict格式，我之前用常量赋值给变量，这段代码是可以生效的，但是用变量赋值就不行，把这一段dumps用法去掉就行了，应该是不需要转换
    resp = Response_headers(content)
    return resp

@app.route('/OS_host1')
def OS_host1():

    #定义变量，用于存储json数据
    cpuStr = ''
    memStr = ''

    oneSec = datetime.timedelta(seconds = 1)
    queryTime = datetime.datetime.now()-oneSec*5

    #初始化数据库操作对象
    a=getOSInfo('host1',queryTime)
    #获取延迟5秒cpu数据
    cpuResult = a.getCpuInfoByCreateTime()
    # print(sqlResult)
    for row in cpuResult:
        rowResult = str(row[0],encoding='utf-8')
        # rowResult = row[0]
        cpuStr = cpuStr + str(rowResult) + ','
    cpuStr = cpuStr[:-1]

    #获取延迟5秒mem数据
    memResult = a.getMemInfoByCreateTime()
    for row in memResult:
        rowResult = str(row[0],encoding='utf-8')
        # rowResult = row[0]
        memStr = memStr + str(rowResult) + ','
    memStr = memStr[:-1]

    content = '''{"cpudata": ['''+cpuStr+'],"memdata": ['''+memStr+']}'
    # datas = {"data": [{"name":"1998-09-03 00:01:06","value":["1998-09-03 00:01:06",0.81]},{"name":"1998-09-03 00:01:07","value":["1998-09-03 00:01:07",0.05]},{"name":"1998-09-03 00:01:08","value":["1998-09-03 00:01:08",0.07]},{"name":"1998-09-03 00:01:09","value":["1998-09-03 00:01:09",0.84]},{"name":"1998-09-03 00:01:10","value":["1998-09-03 00:01:10",0.81]},{"name":"1998-09-03 00:01:11","value":["1998-09-03 00:01:11",0.54]},{"name":"1998-09-03 00:01:12","value":["1998-09-03 00:01:12",0.93]},{"name":"1998-09-03 00:01:13","value":["1998-09-03 00:01:13",0.57]},{"name":"1998-09-03 00:01:14","value":["1998-09-03 00:01:14",0.91]},{"name":"1998-09-03 00:01:15","value":["1998-09-03 00:01:15",0.16]},{"name":"1998-09-03 00:01:16","value":["1998-09-03 00:01:16",0.68]},{"name":"1998-09-03 00:01:17","value":["1998-09-03 00:01:17",0.00]},{"name":"1998-09-03 00:01:18","value":["1998-09-03 00:01:18",0.50]},{"name":"1998-09-03 00:01:19","value":["1998-09-03 00:01:19",0.46]},{"name":"1998-09-03 00:01:20","value":["1998-09-03 00:01:20",0.88]},{"name":"1998-09-03 00:01:21","value":["1998-09-03 00:01:21",0.05]},{"name":"1998-09-03 00:01:22","value":["1998-09-03 00:01:22",0.25]},{"name":"1998-09-03 00:01:23","value":["1998-09-03 00:01:23",0.34]},{"name":"1998-09-03 00:01:24","value":["1998-09-03 00:01:24",0.50]},{"name":"1998-09-03 00:01:25","value":["1998-09-03 00:01:25",0.93]},{"name":"1998-09-03 00:01:26","value":["1998-09-03 00:01:26",0.53]},{"name":"1998-09-03 00:01:27","value":["1998-09-03 00:01:27",0.05]},{"name":"1998-09-03 00:01:28","value":["1998-09-03 00:01:28",0.61]},{"name":"1998-09-03 00:01:29","value":["1998-09-03 00:01:29",0.72]},{"name":"1998-09-03 00:01:30","value":["1998-09-03 00:01:30",0.13]},{"name":"1998-09-03 00:01:31","value":["1998-09-03 00:01:31",0.20]},{"name":"1998-09-03 00:01:32","value":["1998-09-03 00:01:32",0.90]},{"name":"1998-09-03 00:01:33","value":["1998-09-03 00:01:33",0.30]},{"name":"1998-09-03 00:01:34","value":["1998-09-03 00:01:34",0.42]},{"name":"1998-09-03 00:01:35","value":["1998-09-03 00:01:35",0.08]},{"name":"1998-09-03 00:01:36","value":["1998-09-03 00:01:36",0.61]},{"name":"1998-09-03 00:01:37","value":["1998-09-03 00:01:37",0.34]},{"name":"1998-09-03 00:01:38","value":["1998-09-03 00:01:38",0.73]},{"name":"1998-09-03 00:01:39","value":["1998-09-03 00:01:39",0.46]},{"name":"1998-09-03 00:01:40","value":["1998-09-03 00:01:40",0.51]},{"name":"1998-09-03 00:01:41","value":["1998-09-03 00:01:41",0.44]},{"name":"1998-09-03 00:01:42","value":["1998-09-03 00:01:42",0.90]},{"name":"1998-09-03 00:01:43","value":["1998-09-03 00:01:43",0.16]},{"name":"1998-09-03 00:01:44","value":["1998-09-03 00:01:44",0.34]},{"name":"1998-09-03 00:01:45","value":["1998-09-03 00:01:45",0.76]},{"name":"1998-09-03 00:01:46","value":["1998-09-03 00:01:46",0.70]},{"name":"1998-09-03 00:01:47","value":["1998-09-03 00:01:47",0.70]},{"name":"1998-09-03 00:01:48","value":["1998-09-03 00:01:48",0.41]},{"name":"1998-09-03 00:01:49","value":["1998-09-03 00:01:49",0.07]},{"name":"1998-09-03 00:01:50","value":["1998-09-03 00:01:50",0.64]},{"name":"1998-09-03 00:01:51","value":["1998-09-03 00:01:51",0.84]},{"name":"1998-09-03 00:01:52","value":["1998-09-03 00:01:52",0.37]},{"name":"1998-09-03 00:01:53","value":["1998-09-03 00:01:53",0.76]},{"name":"1998-09-03 00:01:54","value":["1998-09-03 00:01:54",0.96]},{"name":"1998-09-03 00:01:55","value":["1998-09-03 00:01:55",0.35]},{"name":"1998-09-03 00:01:56","value":["1998-09-03 00:01:56",0.75]},{"name":"1998-09-03 00:01:57","value":["1998-09-03 00:01:57",0.78]},{"name":"1998-09-03 00:01:58","value":["1998-09-03 00:01:58",0.80]},{"name":"1998-09-03 00:01:59","value":["1998-09-03 00:01:59",0.30]},{"name":"1998-09-03 00:02:00","value":["1998-09-03 00:02:00",0.69]},{"name":"1998-09-03 00:02:01","value":["1998-09-03 00:02:01",0.25]},{"name":"1998-09-03 00:02:02","value":["1998-09-03 00:02:02",0.39]},{"name":"1998-09-03 00:02:03","value":["1998-09-03 00:02:03",0.36]},{"name":"1998-09-03 00:02:04","value":["1998-09-03 00:02:04",0.28]},{"name":"1998-09-03 00:02:05","value":["1998-09-03 00:02:05",0.23]},{"name":"1998-09-03 00:02:06","value":["1998-09-03 00:02:06",0.62]},{"name":"1998-09-03 00:02:07","value":["1998-09-03 00:02:07",0.06]},{"name":"1998-09-03 00:02:08","value":["1998-09-03 00:02:08",0.44]},{"name":"1998-09-03 00:02:09","value":["1998-09-03 00:02:09",0.71]},{"name":"1998-09-03 00:02:10","value":["1998-09-03 00:02:10",0.43]},{"name":"1998-09-03 00:02:11","value":["1998-09-03 00:02:11",0.31]},{"name":"1998-09-03 00:02:12","value":["1998-09-03 00:02:12",0.58]},{"name":"1998-09-03 00:02:13","value":["1998-09-03 00:02:13",0.43]},{"name":"1998-09-03 00:02:14","value":["1998-09-03 00:02:14",0.23]},{"name":"1998-09-03 00:02:15","value":["1998-09-03 00:02:15",0.23]},{"name":"1998-09-03 00:02:16","value":["1998-09-03 00:02:16",0.96]},{"name":"1998-09-03 00:02:17","value":["1998-09-03 00:02:17",0.16]},{"name":"1998-09-03 00:02:18","value":["1998-09-03 00:02:18",0.44]},{"name":"1998-09-03 00:02:19","value":["1998-09-03 00:02:19",0.42]},{"name":"1998-09-03 00:02:20","value":["1998-09-03 00:02:20",0.38]},{"name":"1998-09-03 00:02:21","value":["1998-09-03 00:02:21",0.59]},{"name":"1998-09-03 00:02:22","value":["1998-09-03 00:02:22",0.49]},{"name":"1998-09-03 00:02:23","value":["1998-09-03 00:02:23",0.78]},{"name":"1998-09-03 00:02:24","value":["1998-09-03 00:02:24",0.24]},{"name":"1998-09-03 00:02:25","value":["1998-09-03 00:02:25",0.45]},{"name":"1998-09-03 00:02:26","value":["1998-09-03 00:02:26",0.62]},{"name":"1998-09-03 00:02:27","value":["1998-09-03 00:02:27",0.69]},{"name":"1998-09-03 00:02:28","value":["1998-09-03 00:02:28",0.62]},{"name":"1998-09-03 00:02:29","value":["1998-09-03 00:02:29",0.66]},{"name":"1998-09-03 00:02:30","value":["1998-09-03 00:02:30",0.61]},{"name":"1998-09-03 00:02:31","value":["1998-09-03 00:02:31",0.95]},{"name":"1998-09-03 00:02:32","value":["1998-09-03 00:02:32",0.13]},{"name":"1998-09-03 00:02:33","value":["1998-09-03 00:02:33",0.78]},{"name":"1998-09-03 00:02:34","value":["1998-09-03 00:02:34",0.49]},{"name":"1998-09-03 00:02:35","value":["1998-09-03 00:02:35",0.50]},{"name":"1998-09-03 00:02:36","value":["1998-09-03 00:02:36",0.76]},{"name":"1998-09-03 00:02:37","value":["1998-09-03 00:02:37",0.16]},{"name":"1998-09-03 00:02:38","value":["1998-09-03 00:02:38",0.75]},{"name":"1998-09-03 00:02:39","value":["1998-09-03 00:02:39",0.06]},{"name":"1998-09-03 00:02:40","value":["1998-09-03 00:02:40",0.31]}]}
    print(content)

    # content = json.dumps(datas)  #dumps是将dict转化成str格式，loads是将str转化成dict格式，我之前用常量赋值给变量，这段代码是可以生效的，但是用变量赋值就不行，把这一段dumps用法去掉就行了，应该是不需要转换
    resp = Response_headers(content)
    return resp

@app.route('/OS_host2')
def OS_host2():

    #定义变量，用于存储json数据
    cpuStr = ''
    memStr = ''

    oneSec = datetime.timedelta(seconds = 1)
    # 5秒执行一次
    queryTime = datetime.datetime.now()-oneSec*5

    #初始化数据库操作对象
    a=getOSInfo('host2',queryTime)
    #获取延迟5秒cpu数据
    cpuResult = a.getCpuInfoByCreateTime()
    # 读取sql查询结果
    for row in cpuResult:
        rowResult = str(row[0],encoding='utf-8')
        # rowResult = row[0]
        cpuStr = cpuStr + str(rowResult) + ','
    cpuStr = cpuStr[:-1]

    #获取延迟5秒mem数据
    memResult = a.getMemInfoByCreateTime()
    for row in memResult:
        rowResult = str(row[0],encoding='utf-8')
        # rowResult = row[0]
        memStr = memStr + str(rowResult) + ','
    # 截断最后一个逗号
    memStr = memStr[:-1]

    content = '''{"cpudata": ['''+cpuStr+'],"memdata": ['''+memStr+']}'
    # datas = {"data": [{"name":"1998-09-03 00:01:06","value":["1998-09-03 00:01:06",0.81]},{"name":"1998-09-03 00:01:07","value":["1998-09-03 00:01:07",0.05]},{"name":"1998-09-03 00:01:08","value":["1998-09-03 00:01:08",0.07]},{"name":"1998-09-03 00:01:09","value":["1998-09-03 00:01:09",0.84]},{"name":"1998-09-03 00:01:10","value":["1998-09-03 00:01:10",0.81]},{"name":"1998-09-03 00:01:11","value":["1998-09-03 00:01:11",0.54]},{"name":"1998-09-03 00:01:12","value":["1998-09-03 00:01:12",0.93]},{"name":"1998-09-03 00:01:13","value":["1998-09-03 00:01:13",0.57]},{"name":"1998-09-03 00:01:14","value":["1998-09-03 00:01:14",0.91]},{"name":"1998-09-03 00:01:15","value":["1998-09-03 00:01:15",0.16]},{"name":"1998-09-03 00:01:16","value":["1998-09-03 00:01:16",0.68]},{"name":"1998-09-03 00:01:17","value":["1998-09-03 00:01:17",0.00]},{"name":"1998-09-03 00:01:18","value":["1998-09-03 00:01:18",0.50]},{"name":"1998-09-03 00:01:19","value":["1998-09-03 00:01:19",0.46]},{"name":"1998-09-03 00:01:20","value":["1998-09-03 00:01:20",0.88]},{"name":"1998-09-03 00:01:21","value":["1998-09-03 00:01:21",0.05]},{"name":"1998-09-03 00:01:22","value":["1998-09-03 00:01:22",0.25]},{"name":"1998-09-03 00:01:23","value":["1998-09-03 00:01:23",0.34]},{"name":"1998-09-03 00:01:24","value":["1998-09-03 00:01:24",0.50]},{"name":"1998-09-03 00:01:25","value":["1998-09-03 00:01:25",0.93]},{"name":"1998-09-03 00:01:26","value":["1998-09-03 00:01:26",0.53]},{"name":"1998-09-03 00:01:27","value":["1998-09-03 00:01:27",0.05]},{"name":"1998-09-03 00:01:28","value":["1998-09-03 00:01:28",0.61]},{"name":"1998-09-03 00:01:29","value":["1998-09-03 00:01:29",0.72]},{"name":"1998-09-03 00:01:30","value":["1998-09-03 00:01:30",0.13]},{"name":"1998-09-03 00:01:31","value":["1998-09-03 00:01:31",0.20]},{"name":"1998-09-03 00:01:32","value":["1998-09-03 00:01:32",0.90]},{"name":"1998-09-03 00:01:33","value":["1998-09-03 00:01:33",0.30]},{"name":"1998-09-03 00:01:34","value":["1998-09-03 00:01:34",0.42]},{"name":"1998-09-03 00:01:35","value":["1998-09-03 00:01:35",0.08]},{"name":"1998-09-03 00:01:36","value":["1998-09-03 00:01:36",0.61]},{"name":"1998-09-03 00:01:37","value":["1998-09-03 00:01:37",0.34]},{"name":"1998-09-03 00:01:38","value":["1998-09-03 00:01:38",0.73]},{"name":"1998-09-03 00:01:39","value":["1998-09-03 00:01:39",0.46]},{"name":"1998-09-03 00:01:40","value":["1998-09-03 00:01:40",0.51]},{"name":"1998-09-03 00:01:41","value":["1998-09-03 00:01:41",0.44]},{"name":"1998-09-03 00:01:42","value":["1998-09-03 00:01:42",0.90]},{"name":"1998-09-03 00:01:43","value":["1998-09-03 00:01:43",0.16]},{"name":"1998-09-03 00:01:44","value":["1998-09-03 00:01:44",0.34]},{"name":"1998-09-03 00:01:45","value":["1998-09-03 00:01:45",0.76]},{"name":"1998-09-03 00:01:46","value":["1998-09-03 00:01:46",0.70]},{"name":"1998-09-03 00:01:47","value":["1998-09-03 00:01:47",0.70]},{"name":"1998-09-03 00:01:48","value":["1998-09-03 00:01:48",0.41]},{"name":"1998-09-03 00:01:49","value":["1998-09-03 00:01:49",0.07]},{"name":"1998-09-03 00:01:50","value":["1998-09-03 00:01:50",0.64]},{"name":"1998-09-03 00:01:51","value":["1998-09-03 00:01:51",0.84]},{"name":"1998-09-03 00:01:52","value":["1998-09-03 00:01:52",0.37]},{"name":"1998-09-03 00:01:53","value":["1998-09-03 00:01:53",0.76]},{"name":"1998-09-03 00:01:54","value":["1998-09-03 00:01:54",0.96]},{"name":"1998-09-03 00:01:55","value":["1998-09-03 00:01:55",0.35]},{"name":"1998-09-03 00:01:56","value":["1998-09-03 00:01:56",0.75]},{"name":"1998-09-03 00:01:57","value":["1998-09-03 00:01:57",0.78]},{"name":"1998-09-03 00:01:58","value":["1998-09-03 00:01:58",0.80]},{"name":"1998-09-03 00:01:59","value":["1998-09-03 00:01:59",0.30]},{"name":"1998-09-03 00:02:00","value":["1998-09-03 00:02:00",0.69]},{"name":"1998-09-03 00:02:01","value":["1998-09-03 00:02:01",0.25]},{"name":"1998-09-03 00:02:02","value":["1998-09-03 00:02:02",0.39]},{"name":"1998-09-03 00:02:03","value":["1998-09-03 00:02:03",0.36]},{"name":"1998-09-03 00:02:04","value":["1998-09-03 00:02:04",0.28]},{"name":"1998-09-03 00:02:05","value":["1998-09-03 00:02:05",0.23]},{"name":"1998-09-03 00:02:06","value":["1998-09-03 00:02:06",0.62]},{"name":"1998-09-03 00:02:07","value":["1998-09-03 00:02:07",0.06]},{"name":"1998-09-03 00:02:08","value":["1998-09-03 00:02:08",0.44]},{"name":"1998-09-03 00:02:09","value":["1998-09-03 00:02:09",0.71]},{"name":"1998-09-03 00:02:10","value":["1998-09-03 00:02:10",0.43]},{"name":"1998-09-03 00:02:11","value":["1998-09-03 00:02:11",0.31]},{"name":"1998-09-03 00:02:12","value":["1998-09-03 00:02:12",0.58]},{"name":"1998-09-03 00:02:13","value":["1998-09-03 00:02:13",0.43]},{"name":"1998-09-03 00:02:14","value":["1998-09-03 00:02:14",0.23]},{"name":"1998-09-03 00:02:15","value":["1998-09-03 00:02:15",0.23]},{"name":"1998-09-03 00:02:16","value":["1998-09-03 00:02:16",0.96]},{"name":"1998-09-03 00:02:17","value":["1998-09-03 00:02:17",0.16]},{"name":"1998-09-03 00:02:18","value":["1998-09-03 00:02:18",0.44]},{"name":"1998-09-03 00:02:19","value":["1998-09-03 00:02:19",0.42]},{"name":"1998-09-03 00:02:20","value":["1998-09-03 00:02:20",0.38]},{"name":"1998-09-03 00:02:21","value":["1998-09-03 00:02:21",0.59]},{"name":"1998-09-03 00:02:22","value":["1998-09-03 00:02:22",0.49]},{"name":"1998-09-03 00:02:23","value":["1998-09-03 00:02:23",0.78]},{"name":"1998-09-03 00:02:24","value":["1998-09-03 00:02:24",0.24]},{"name":"1998-09-03 00:02:25","value":["1998-09-03 00:02:25",0.45]},{"name":"1998-09-03 00:02:26","value":["1998-09-03 00:02:26",0.62]},{"name":"1998-09-03 00:02:27","value":["1998-09-03 00:02:27",0.69]},{"name":"1998-09-03 00:02:28","value":["1998-09-03 00:02:28",0.62]},{"name":"1998-09-03 00:02:29","value":["1998-09-03 00:02:29",0.66]},{"name":"1998-09-03 00:02:30","value":["1998-09-03 00:02:30",0.61]},{"name":"1998-09-03 00:02:31","value":["1998-09-03 00:02:31",0.95]},{"name":"1998-09-03 00:02:32","value":["1998-09-03 00:02:32",0.13]},{"name":"1998-09-03 00:02:33","value":["1998-09-03 00:02:33",0.78]},{"name":"1998-09-03 00:02:34","value":["1998-09-03 00:02:34",0.49]},{"name":"1998-09-03 00:02:35","value":["1998-09-03 00:02:35",0.50]},{"name":"1998-09-03 00:02:36","value":["1998-09-03 00:02:36",0.76]},{"name":"1998-09-03 00:02:37","value":["1998-09-03 00:02:37",0.16]},{"name":"1998-09-03 00:02:38","value":["1998-09-03 00:02:38",0.75]},{"name":"1998-09-03 00:02:39","value":["1998-09-03 00:02:39",0.06]},{"name":"1998-09-03 00:02:40","value":["1998-09-03 00:02:40",0.31]}]}
    print(content)

    # content = json.dumps(datas)  #dumps是将dict转化成str格式，loads是将str转化成dict格式，我之前用常量赋值给变量，这段代码是可以生效的，但是用变量赋值就不行，把这一段dumps用法去掉就行了，应该是不需要转换
    resp = Response_headers(content)
    return resp

@app.errorhandler(403)
def page_not_found(error):
    content = json.dumps({"error_code": "403"})
    resp = Response_headers(content)
    return resp

@app.errorhandler(404)
def page_not_found(error):
    content = json.dumps({"error_code": "404"})
    resp = Response_headers(content)
    return resp

@app.errorhandler(400)
def page_not_found(error):
    content = json.dumps({"error_code": "400"})
    resp = Response_headers(content)
    return resp

@app.errorhandler(410)
def page_not_found(error):
    content = json.dumps({"error_code": "410"})
    resp = Response_headers(content)
    return resp

@app.errorhandler(500)
def page_not_found(error):
    content = json.dumps({"error_code": "500"})
    resp = Response_headers(content)
    return resp

if __name__ == '__main__':
    app.run(debug=True)#threaded=True,