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