This repository has been archived by the owner on Jan 15, 2020. It is now read-only.
/
getchartdata.py
98 lines (76 loc) · 2.93 KB
/
getchartdata.py
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
#!/usr/bin/python3
import database
import datetime
import time
import os
SETTINGS_FILENAME = os.path.abspath('settings/dbExample.json')
def main():
get_voltage_chart_data(1)
def get_voltage_chart_data(meterId):
""" Return json object for flot chart
"""
query_filename = os.path.abspath('sql/Last50VoltReadings.sql')
params_dict = {'METERID': meterId}
h, d = database.run_query(SETTINGS_FILENAME, query_filename, params_dict)
chartdata = {}
chartdata['label'] = 'Voltage Profile'
chartdata['a'] = []
chartdata['b'] = []
chartdata['c'] = []
for row in d:
dTime = datetime.datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S')
ts = int(time.mktime(dTime.timetuple()) * 1000)
chartdata['a'].append([ts,row[1]])
chartdata['b'].append([ts,row[2]])
chartdata['c'].append([ts,row[3]])
return chartdata
def get_thd_chart_data(meterId):
""" Return json object for flot chart
"""
query_filename = os.path.abspath('sql/Last50THDReadings.sql')
params_dict = {'METERID': meterId}
h, d = database.run_query(SETTINGS_FILENAME, query_filename, params_dict)
chartdata = {}
chartdata['label'] = 'THD Profile'
chartdata['a'] = []
chartdata['b'] = []
chartdata['c'] = []
for row in d:
dTime = datetime.datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S')
ts = int(time.mktime(dTime.timetuple()) * 1000)
chartdata['a'].append([ts,row[1]])
chartdata['b'].append([ts,row[2]])
chartdata['c'].append([ts,row[3]])
return chartdata
def get_unbal_chart_data(meterId):
""" Return json object for flot chart
"""
query_filename = os.path.abspath('sql/Last50UnbalReadings.sql')
params_dict = {'METERID': meterId}
h, d = database.run_query(SETTINGS_FILENAME, query_filename, params_dict)
chartdata = {}
chartdata['label'] = 'Unbalance Profile'
chartdata['a'] = []
for row in d:
dTime = datetime.datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S')
ts = int(time.mktime(dTime.timetuple()) * 1000)
chartdata['a'].append([ts,row[1]])
return chartdata
def get_events_chart_data(meterId):
""" Return json object for flot chart
"""
query_filename = os.path.abspath('sql/EventsByMonth.sql')
params_dict = {'METERID': meterId}
h, d = database.run_query(SETTINGS_FILENAME, query_filename, params_dict)
chartdata = {}
chartdata['label'] = 'Unbalance Profile'
chartdata['sag'] = []
chartdata['swl'] = []
for row in d:
dTime = datetime.datetime.strptime(row[0], '%Y-%m-%d')
ts = int(time.mktime(dTime.timetuple()) * 1000)
chartdata['sag'].append([ts,row[1]])
chartdata['swl'].append([ts,row[2]])
return chartdata
if __name__ == '__main__':
main()