3 from monitor.database.info.model import *
12 def summarize(query, type):
14 if o.status not in sumdata[type]:
15 sumdata[type][o.status] = 0
16 sumdata[type][o.status] += 1
18 time_str = time.strftime("%m/%d/%y+%H:%M")
20 if len(sys.argv) == 1:
21 print "For use in conjunction with add-google-record.py"
22 print "Usage: %s <nodes|sites>" % sys.argv[0]
25 elif sys.argv[1] == "sites":
27 site_type_list = ['date', 'good', 'offline', 'down', 'online', 'new']
29 for k in site_type_list:
32 fbquery = HistorySiteRecord.query.all()
33 summarize(fbquery, 'sites')
34 sumdata['sites']['date'] = time_str
35 for f in sumdata['sites']:
36 sumdata['sites'][f] = str(sumdata['sites'][f])
38 l = ",".join(site_type_list)
39 v = ",".join([ sumdata['sites'][k] for k in site_type_list ])
40 print "--labels=%s --values=%s" % ( l, v )
42 elif sys.argv[1] == "nodes":
44 node_type_list = ['date', 'good', 'offline', 'down', 'online', 'disabled', 'failboot', 'safeboot']
45 for k in node_type_list:
47 fbquery = HistoryNodeRecord.query.all()
48 summarize(fbquery, 'nodes')
49 sumdata['nodes']['date'] = time_str
50 for f in sumdata['nodes']:
51 sumdata['nodes'][f] = str(sumdata['nodes'][f])
53 l = ",".join(node_type_list)
54 v = ",".join([ sumdata['nodes'][k] for k in node_type_list ])
55 print "--labels=%s --values=%s" % ( l, v )