Mercurial > templog
annotate web/log.py @ 74:cb5ea75ee599
merge
| author | Matt Johnston <matt@ucc.asn.au> |
|---|---|
| date | Tue, 03 Jul 2012 21:55:50 +0800 |
| parents | 0a8639039453 |
| children | ca08442635ca |
| rev | line source |
|---|---|
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
1 #:vim:et:ts=4:sts=4:sw=4: |
| 27 | 2 import rrdtool |
| 3 import os | |
| 29 | 4 import os.path |
| 27 | 5 import sys |
| 29 | 6 import glob |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
7 import hashlib |
|
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
8 import tempfile |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
9 import time |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
10 import syslog |
| 44 | 11 import sqlite3 |
|
49
206294a354a7
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
45
diff
changeset
|
12 import traceback |
| 67 | 13 import datetime |
| 29 | 14 from colorsys import hls_to_rgb |
| 27 | 15 |
| 28 | 16 import config |
| 27 | 17 |
| 18 def sensor_rrd_path(s): | |
| 28 | 19 return '%s/sensor_%s.rrd' % (config.DATA_PATH, s) |
| 27 | 20 |
| 29 | 21 # returns (path, sensor_name) tuples |
| 22 def all_sensors(): | |
| 23 return [(r, os.path.basename(r[:-4])) | |
| 24 for r in glob.glob('%s/*.rrd' % config.DATA_PATH)] | |
| 25 | |
| 27 | 26 def create_rrd(sensor_id): |
|
43
ea99aae87884
Create with a start date so that it works
Matt Johnston <matt@ucc.asn.au>
parents:
40
diff
changeset
|
27 # start date of 10 seconds into 1970 is used so that we can |
|
ea99aae87884
Create with a start date so that it works
Matt Johnston <matt@ucc.asn.au>
parents:
40
diff
changeset
|
28 # update with prior values straight away. |
| 61 | 29 if 'voltage' in sensor_id: |
| 63 | 30 args = [ |
| 31 '--step', '3600', | |
| 32 'DS:temp:GAUGE:7200:1:10', | |
| 33 'RRA:AVERAGE:0.5:1:87600'] | |
| 61 | 34 else: |
| 63 | 35 args = [ |
| 36 '--step', '300', | |
| 37 'DS:temp:GAUGE:600:-10:100', | |
| 61 | 38 'RRA:AVERAGE:0.5:1:1051200'] |
| 27 | 39 |
| 61 | 40 rrdtool.create(sensor_rrd_path(sensor_id), |
| 63 | 41 '--start', 'now-60d', |
| 61 | 42 *args) |
| 29 | 43 |
| 44 # stolen from viewmtn, stolen from monotone-viz | |
| 45 def colour_from_string(str): | |
| 46 def f(off): | |
| 47 return ord(hashval[off]) / 256.0 | |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
48 hashval = hashlib.sha1(str).digest() |
| 29 | 49 hue = f(5) |
| 50 li = f(1) * 0.15 + 0.55 | |
| 51 sat = f(2) * 0.5 + .5 | |
| 52 return ''.join(["%.2x" % int(x * 256) for x in hls_to_rgb(hue, li, sat)]) | |
| 53 | |
| 54 def graph_png(start, length): | |
| 55 rrds = all_sensors() | |
| 56 | |
| 57 graph_args = [] | |
| 61 | 58 have_volts = False |
| 29 | 59 for n, (rrdfile, sensor) in enumerate(rrds): |
| 61 | 60 if 'avrtemp' in sensor: |
| 61 continue | |
| 62 if 'voltage' in sensor: | |
| 63 have_volts = True | |
| 64 vname = 'scalevolts' | |
|
71
7d243ba2dd39
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
69
diff
changeset
|
65 graph_args.append('DEF:%(vname)s=%(rrdfile)s:temp:AVERAGE:step=3600' % locals()) |
| 61 | 66 else: |
| 67 vname = 'temp%d' % n | |
|
71
7d243ba2dd39
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
69
diff
changeset
|
68 graph_args.append('DEF:raw%(vname)s=%(rrdfile)s:temp:AVERAGE' % locals()) |
|
7d243ba2dd39
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
69
diff
changeset
|
69 graph_args.append('CDEF:%(vname)s=raw%(vname)s,0.1,*,2,+' % locals()) |
| 29 | 70 width = config.LINE_WIDTH |
| 71 legend = config.SENSOR_NAMES.get(sensor, sensor) | |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
72 colour = config.SENSOR_COLOURS.get(legend, colour_from_string(sensor)) |
| 29 | 73 graph_args.append('LINE%(width)f:%(vname)s#%(colour)s:%(legend)s' % locals()) |
| 74 | |
| 67 | 75 end = int(start+length) |
| 76 start = int(start) | |
| 77 | |
| 29 | 78 tempf = tempfile.NamedTemporaryFile() |
| 67 | 79 dateformat = '%H:%M:%S %Y-%m-%d' |
| 80 watermark = ("Now %s\t" | |
| 81 "Start %s\t" | |
| 82 "End %s" % ( | |
| 83 datetime.datetime.now().strftime(dateformat), | |
| 84 datetime.datetime.fromtimestamp(start).strftime(dateformat), | |
| 85 datetime.datetime.fromtimestamp(end).strftime(dateformat) )) | |
| 86 | |
| 87 args = [tempf.name, '-s', str(start), | |
| 88 '-e', str(end), | |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
89 '-w', str(config.GRAPH_WIDTH), |
|
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
90 '-h', str(config.GRAPH_HEIGHT), |
| 29 | 91 '--slope-mode', |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
92 '--border', '0', |
|
73
0a8639039453
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
71
diff
changeset
|
93 # '--vertical-label', 'Voltage', |
|
71
7d243ba2dd39
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
69
diff
changeset
|
94 '--y-grid', '0.1:1', |
|
7d243ba2dd39
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
69
diff
changeset
|
95 '--dynamic-labels', |
| 56 | 96 '--grid-dash', '1:0', |
| 97 '--color', 'GRID#00000000', | |
| 98 '--color', 'MGRID#aaaaaa', | |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
99 '--color', 'BACK#ffffff', |
| 67 | 100 '--disable-rrdtool-tag', |
| 101 '--watermark', watermark, | |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
102 '--imgformat', 'PNG'] \ |
| 29 | 103 + graph_args |
| 67 | 104 args += ['--font', 'DEFAULT:12:%s' % config.GRAPH_FONT] |
| 105 args += ['--font', 'WATERMARK:10:%s' % config.GRAPH_FONT] | |
| 61 | 106 if have_volts: |
|
71
7d243ba2dd39
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
69
diff
changeset
|
107 args += ['--right-axis', '10:-20', # matches the scalevolts CDEF above |
|
73
0a8639039453
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
71
diff
changeset
|
108 '--right-axis-format', '%.0lf', |
|
0a8639039453
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
71
diff
changeset
|
109 # '--right-axis-label', 'Temperature' |
|
0a8639039453
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
71
diff
changeset
|
110 ] |
| 61 | 111 |
| 29 | 112 rrdtool.graph(*args) |
| 113 return tempf.read() | |
| 114 | |
| 27 | 115 def sensor_update(sensor_id, measurements, first_real_time, time_step): |
| 116 try: | |
| 117 open(sensor_rrd_path(sensor_id)) | |
| 118 except IOError, e: | |
| 119 create_rrd(sensor_id) | |
| 120 | |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
121 if measurements: |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
122 values = ['%d:%f' % p for p in |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
123 zip((first_real_time + time_step*t for t in xrange(len(measurements))), |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
124 measurements)] |
| 27 | 125 |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
126 rrdfile = sensor_rrd_path(sensor_id) |
| 40 | 127 # XXX what to do here when it fails... |
|
49
206294a354a7
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
45
diff
changeset
|
128 for v in values: |
|
206294a354a7
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
45
diff
changeset
|
129 try: |
|
206294a354a7
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
45
diff
changeset
|
130 rrdtool.update(rrdfile, v) |
| 63 | 131 except rrdtool.error, e: |
|
49
206294a354a7
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
45
diff
changeset
|
132 print>>sys.stderr, "Bad rrdtool update '%s'" % v |
|
206294a354a7
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
45
diff
changeset
|
133 traceback.print_exc(file=sys.stderr) |
| 33 | 134 |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
135 # be paranoid |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
136 f = file(rrdfile) |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
137 os.fsync(f.fileno()) |
| 27 | 138 |
| 33 | 139 def record_debug(lines): |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
140 f = open('%s/debug.log' % config.DATA_PATH, 'a+') |
|
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
141 f.write('===== %s =====\n' % time.strftime('%a, %d %b %Y %H:%M:%S')) |
| 33 | 142 f.writelines(('%s\n' % s for s in lines)) |
| 143 f.flush() | |
| 144 return f | |
| 145 | |
| 27 | 146 def parse(lines): |
| 33 | 147 |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
148 debugf = record_debug(lines) |
| 33 | 149 |
| 27 | 150 entries = dict(l.split('=', 1) for l in lines) |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
151 if len(entries) != len(lines): |
| 27 | 152 raise Exception("Keys are not unique") |
| 153 | |
| 154 num_sensors = int(entries['sensors']) | |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
155 num_measurements = int(entries['measurements']) |
| 27 | 156 |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
157 sensors = [entries['sensor_id%d' % n] for n in xrange(num_sensors)] |
| 27 | 158 |
| 159 meas = [] | |
| 160 for s in sensors: | |
| 161 meas.append([]) | |
| 162 | |
| 28 | 163 def val_scale(v): |
| 164 # convert decidegrees to degrees | |
| 165 return 0.1 * v | |
| 166 | |
| 27 | 167 for n in xrange(num_measurements): |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
168 vals = [val_scale(int(x)) for x in entries["meas%d" % n].strip().split()] |
| 27 | 169 if len(vals) != num_sensors: |
| 170 raise Exception("Wrong number of sensors for measurement %d" % n) | |
| 171 # we make an array of values for each sensor | |
| 172 for s in xrange(num_sensors): | |
| 173 meas[s].append(vals[s]) | |
| 174 | |
|
31
5e75e08d20ac
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
29
diff
changeset
|
175 avr_now = float(entries['now']) |
| 27 | 176 avr_first_time = float(entries['first_time']) |
| 177 time_step = float(entries['time_step']) | |
| 178 | |
| 61 | 179 if 'avrtemp' in entries: |
| 180 avrtemp = val_scale(int(entries['avrtemp'])) | |
| 181 sensor_update('avrtemp', [avrtemp], time.time(), 1) | |
| 182 | |
| 183 if 'voltage' in entries: | |
| 184 voltage = 0.001 * int(entries['voltage']) | |
| 185 sensor_update('voltage', [voltage], time.time(), 1) | |
| 186 | |
| 40 | 187 #sqlite |
| 188 # - time | |
| 189 # - voltage | |
| 190 # - boot time | |
| 191 | |
| 27 | 192 first_real_time = time.time() - (avr_now - avr_first_time) |
| 193 | |
| 194 for sensor_id, measurements in zip(sensors, meas): | |
| 40 | 195 # XXX sqlite add |
| 27 | 196 sensor_update(sensor_id, measurements, first_real_time, time_step) |
| 33 | 197 |
|
37
8da0fdadc8d7
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
33
diff
changeset
|
198 debugf.write("Updated %d sensors\n" % len(sensors)) |
| 33 | 199 debugf.flush() |