def show_calibration(args):
log.debug('show_calibration(%s)' % args.ref)
d = Database(args.database_path)
c = d._conn.cursor()
c.execute("""
SELECT ref, anemometer_1_factor, anemometer_2_factor,
max_windspeed_ms, irradiance_factor, max_irradiance
FROM calibration
WHERE ref LIKE ?
ORDER BY ref
""", (args.ref,))
headers = result_headers(c)
headerlen = [len(h) for h in headers]
print(' '.join(headers))
print(' '.join(['-' * hl for hl in headerlen]))
for r in c.fetchall():
print('%-3s %19.3f %19.3f %16.3f %17.3f %14.3f' % tuple(r))
def export_data(args):
d = Database(args.database_path)
c = d._conn.cursor()
filt = generate_filter(args, c)
filt.select_events()
result_csv = []
c.execute("""
SELECT ref, event_start, event_end, windspeed_ms_1, windspeed_ms_2, wind_direction, irradiance_wm2
FROM event e
WHERE EXISTS (
SELECT 1
FROM tmp_event_rids t
WHERE t.rid = e.rowid
)
""")
print(','.join(result_headers(c)))
for r in c.fetchall():
print(','.join([str(i) for i in list(r)]))
def export_average(args):
d = Database(args.database_path)
c = d._conn.cursor()
filt = generate_filter(args, c)
filt.select_events()
wind_field = 'windspeed_ms_%d' % args.anemometer_no
if args.split:
c.execute("""
SELECT wind_direction, avg(%s), count(1)
FROM event e,
tmp_event_rids t
WHERE t.rid = e.rowid
GROUP BY wind_direction
""" % wind_field)
else:
c.execute("""
SELECT avg(%s), count(1)
FROM event e,
tmp_event_rids t
WHERE t.rid = e.rowid
""" % wind_field)
print(','.join(result_headers(c)))
for r in c.fetchall():
print(','.join([str(i) for i in list(r)]))
