def create_catalog(root): """ Create a json file containing the meter catalog from the meter file. The file is saved to the json directory. Params: root string """ meter_file = defaults.meter_file(root) output_dir = defaults.json_dir(root) catalog = [] json_file = {} meters = utils.read_meter_file(meter_file) for m in meters: meterId, meterName = utils.get_lucid_id_and_name(m) info = {'meterId': meterId, 'meterName': meterName} catalog.append(info) json_file['datasource'] = defaults.URI json_file['meterCatalog'] = catalog json_file['readings'] = [] curr_dt = datetime.now() json_fname = 'catalog_%s.json' % (utils.format_dt(curr_dt)) save_path = os.path.join(output_dir, json_fname) with open(save_path, 'wb') as out: json.dump(json_file, out)
def run(root): creds_file = defaults.creds(root) cnxn_str = utils.get_cnxn_str(creds_file) meter_file = defaults.meter_file(root) earliest = {} latest = {} print("Running check.py...") with Cursor.Cursor(cnxn_str) as cursor: earliest_query = get_query_str(True) latest_query = get_query_str(False) meter_generator = utils.read_meter_file(meter_file) meters = [m for m in meter_generator] earliest = get_timestamps(cursor, meters, earliest_query) latest = get_timestamps(cursor, meters, latest_query) for i, m in enumerate(meters): ion_name = utils.get_ion_name(m) earliest_ts = earliest[ion_name] latest_ts = latest[ion_name] print(" %d)\t%s\tStart: %s\tEnd: %s" % (i, ion_name, earliest_ts, latest_ts))