def process_meter_data_gen_duid(table: AEMOTableSchema) -> ControllerReturn:
cr = ControllerReturn(total_records=len(table.records))
records = generate_facility_scada(
table.records,
interval_field="interval_datetime",
facility_code_field="duid",
power_field="mwh_reading",
)
cr.processed_records = len(records)
cr.inserted_records = bulkinsert_mms_items(FacilityScada, records,
["generated"])
cr.server_latest = max([i["trading_interval"] for i in records])
return cr
def process_unit_solution(table: AEMOTableSchema) -> ControllerReturn:
cr = ControllerReturn(total_records=len(table.records))
records = generate_facility_scada(
table.records,
interval_field="settlementdate",
facility_code_field="duid",
power_field="initialmw",
)
cr.processed_records = len(records)
cr.inserted_records = bulkinsert_mms_items(FacilityScada, records,
["generated"])
cr.server_latest = max(
[i["trading_interval"] for i in records if i["trading_interval"]])
return cr
def process_unit_scada_optimized(table: AEMOTableSchema) -> ControllerReturn:
cr = ControllerReturn(total_records=len(table.records))
records = generate_facility_scada(
table.records, # type:ignore
interval_field="settlementdate",
facility_code_field="duid",
power_field="scadavalue",
)
cr.processed_records = len(records)
cr.inserted_records = bulkinsert_mms_items(
FacilityScada, records, ["generated", "eoi_quantity"]) # type: ignore
cr.server_latest = max(
[i["trading_interval"] for i in records if i["trading_interval"]])
return cr
def process_rooftop_actual(table: AEMOTableSchema) -> ControllerReturn:
cr = ControllerReturn(total_records=len(table.records))
records = generate_facility_scada(
table.records,
interval_field="interval_datetime",
facility_code_field="regionid",
power_field="power",
network=NetworkAEMORooftop,
)
records = [rooftop_remap_regionids(i) for i in records if i]
records = [i for i in records if i]
cr.processed_records = len(records)
cr.inserted_records = bulkinsert_mms_items(FacilityScada, records,
["generated", "eoi_quantity"])
cr.server_latest = max([i["trading_interval"] for i in records])
return cr
def process_rooftop_forecast(table: AEMOTableSchema) -> ControllerReturn:
cr = ControllerReturn(total_records=len(table.records))
records = generate_facility_scada(
table.records, # type: ignore
interval_field="interval_datetime",
facility_code_field="regionid",
power_field="powermean",
is_forecast=True,
network=NetworkAEMORooftop,
)
records = [rooftop_remap_regionids(i) for i in records
if i] # type: ignore
records = [i for i in records if i]
cr.processed_records = len(records)
cr.inserted_records = bulkinsert_mms_items(FacilityScada, records,
["generated"]) # type: ignore
cr.server_latest = max([i["trading_interval"] for i in records])
return cr