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)]))