def run(self, time, inputs): results = Results() if self.first: results.log('First Post!!!!11111ELEVENTY', logging.INFO) self.first = False inputs['time'] = time results.insert_table_row('output', inputs) self.counter += 1 results.command('/awesome/counter', self.counter) return results
def run(self, time, inputs): results = Results() if self.first: results.log("First Post!!!!11111ELEVENTY", logging.INFO) self.first = False inputs["time"] = time results.insert_table_row("output", inputs) self.counter += 1 results.command("/awesome/counter", self.counter) return results
def run(self, current_time, points): """ Main run method that is called by the DrivenBaseClass. points ex: [{'zonetemp_1':72.0,'zonetemp_2':69.2}] """ result = Results() topics = self.inp.get_topics() topic = topics[self.zone_temp_name][0] current_time = self.inp.localize_sensor_time(topic, current_time) out_data = {'datetime': str(current_time)} for zone_topic in self.zone_topics: if zone_topic in topics.keys(): for i, topic in enumerate(topics[zone_topic], start=1): topic_parts = topic.split('/') zone = topic_parts[-2] #the second last item out_data[zone_topic + self.sep + zone] = points[zone_topic + '_' + str(i)] result.insert_table_row(self.table_name, out_data) return result
def run(self, current_time, points): """ Main run method that is called by the DrivenBaseClass. points ex: [{'zonetemp_1':72.0,'zonetemp_2':69.2}] """ result = Results() topics = self.inp.get_topics() topic = topics[self.zone_temp_name][0] current_time = self.inp.localize_sensor_time(topic, current_time) out_data = { 'datetime': str(current_time) } for zone_topic in self.zone_topics: if zone_topic in topics.keys(): for i, topic in enumerate(topics[zone_topic], start=1): topic_parts = topic.split('/') zone = topic_parts[-2] #the second last item out_data[zone_topic + self.sep + zone] = points[zone_topic + '_' + str(i)] result.insert_table_row(self.table_name, out_data) return result
def run(self, current_time, points): """ Main run method that is called by the DrivenBaseClass. """ device_dict = {} result = Results() topics = self.inp.get_topics() topic = topics[self.oa_temp_name][0] current_time = self.inp.localize_sensor_time(topic, current_time) base_topic = self.inp.get_topics() meta_topics = self.inp.get_topics_meta() unit_dict = { self.oa_temp_name: meta_topics[self.oa_temp_name][base_topic[self.oa_temp_name][0]]['unit'] } if len(base_topic[self.ma_temp_name]) > 0: unit_dict[self.ma_temp_name] = meta_topics[self.ma_temp_name][base_topic[self.ma_temp_name][0]]['unit'] if len(base_topic[self.ra_temp_name]) > 0: unit_dict[self.ra_temp_name] = meta_topics[self.ra_temp_name][base_topic[self.ra_temp_name][0]]['unit'] if len(base_topic[self.da_temp_name]) > 0: unit_dict[self.da_temp_name] = meta_topics[self.da_temp_name][base_topic[self.da_temp_name][0]]['unit'] if len(base_topic[self.da_temp_setpoint_name]) > 0: unit_dict[self.da_temp_setpoint_name] = \ meta_topics[self.da_temp_setpoint_name][base_topic[self.da_temp_setpoint_name][0]]['unit'] for key, value in points.items(): device_dict[key.lower()] = value damper_data = [] oatemp_data = [] matemp_data = [] ratemp_data = [] datemp_data = [] datemp_stpt_data = [] ccv_data = [] fan_speedcmd_data = [] fan_status_data = [] hcv_data = [] return_fan_speedcmd_data = [] occ_data = [] discharge_sp_data = [] staticpressure_sp_data = [] for key, value in device_dict.items(): if (key.startswith(self.outdoor_damper_name) #Damper and value is not None): damper_data.append(value) elif (key.startswith(self.oa_temp_name) #OAT and value is not None): oatemp_data.append(value) elif (key.startswith(self.ma_temp_name) #MAT and value is not None): matemp_data.append(value) elif (key.startswith(self.ra_temp_name) #RAT and value is not None): ratemp_data.append(value) elif (key.startswith(self.da_temp_name) #DAT and value is not None): datemp_data.append(value) elif (key.startswith(self.da_temp_setpoint_name) #DAT SetPoint and value is not None): datemp_stpt_data.append(value) elif (key.startswith(self.cc_valve_name) #CoolCoilValvePos and value is not None): ccv_data.append(value) elif (key.startswith(self.hc_valve_name) #HeatCoilValvePos and value is not None): hcv_data.append(value) elif (key.startswith(self.fan_speedcmd_name) #Fan speed and value is not None): fan_speedcmd_data.append(value) elif (key.startswith(self.fan_status_name) #Fan status and value is not None): fan_status_data.append(value) elif (key.startswith(self.returnfan_speedcmd_name) #returnfan_speedcmd_name and value is not None): return_fan_speedcmd_data.append(value) elif (key.startswith(self.occ_name) #Occupancy and value is not None): occ_data.append(value) elif (key.startswith(self.discharge_sp_name) #discharge_sp_data and value is not None): discharge_sp_data.append(value) elif (key.startswith(self.sp_setpoint_name) #staticpressure_sp_data and value is not None): staticpressure_sp_data.append(value) if not oatemp_data: return result if 'celcius' or 'kelvin' in unit_dict.values: if unit_dict[self.oa_temp_name] == 'celcius': oatemp_data = cu.convertCelciusToFahrenheit(oatemp_data) elif unit_dict[self.oa_temp_name] == 'kelvin': oatemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(oatemp_data)) #if self.ma_temp_name in unit_dict: if unit_dict[self.ma_temp_name] == 'celcius': matemp_data = cu.convertCelciusToFahrenheit(matemp_data) elif unit_dict[self.ma_temp_name] == 'kelvin': matemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(matemp_data)) if self.ra_temp_name in unit_dict: if unit_dict[self.ra_temp_name] == 'celcius': ratemp_data = cu.convertCelciusToFahrenheit(ratemp_data) elif unit_dict[self.ra_temp_name] == 'kelvin': ratemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(ratemp_data)) if self.da_temp_name in unit_dict: if unit_dict[self.da_temp_name] == 'celcius': datemp_data = cu.convertCelciusToFahrenheit(datemp_data) elif unit_dict[self.da_temp_name] == 'kelvin': datemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(datemp_data)) if self.da_temp_setpoint_name in unit_dict: if unit_dict[self.da_temp_setpoint_name] == 'celcius': datemp_stpt_data = cu.convertCelciusToFahrenheit(datemp_stpt_data) elif unit_dict[self.da_temp_setpoint_name] == 'kelvin': datemp_stpt_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(datemp_stpt_data)) oatemp = (sum(oatemp_data) / len(oatemp_data)) matemp = (sum(matemp_data) / len(matemp_data)) matemp_data = None ratemp = datemp = datemp_stpt = None fanstatus = fanspeed = outdoor_damper = ccv = hcv = None oaf = None return_fan_speedcmd = None occupancy = None discharge_sp = staticpressure_sp = None if matemp_data: matemp = (sum(matemp_data) / len(matemp_data)) if ratemp_data: ratemp = (sum(ratemp_data) / len(ratemp_data)) if datemp_data: datemp = (sum(datemp_data) / len(datemp_data)) if datemp_stpt_data: datemp_stpt = (sum(datemp_stpt_data) / len(datemp_stpt_data)) if fan_status_data: fanstatus = (sum(fan_status_data) / len(fan_status_data)) if fan_speedcmd_data: fanspeed = (sum(fan_speedcmd_data) / len(fan_speedcmd_data)) if damper_data: outdoor_damper = (sum(damper_data) / len(damper_data)) if ccv_data: ccv = (sum(ccv_data) / len(ccv_data)) if hcv_data: hcv = (sum(hcv_data) / len(hcv_data)) if matemp_data and ratemp_data: denominator = oatemp - ratemp if denominator == 0: oaf = 0 else: oaf = (matemp - ratemp) / denominator if oaf > 1: oaf = 1 elif oaf < 0: oaf = 0 oaf *= 100 if return_fan_speedcmd_data: return_fan_speedcmd = (sum(return_fan_speedcmd_data) / len(return_fan_speedcmd_data)) if occ_data: occupancy = (sum(occ_data) / len(occ_data))*100 if discharge_sp_data: discharge_sp = (sum(discharge_sp_data) / len(discharge_sp_data)) if staticpressure_sp_data: staticpressure_sp = (sum(staticpressure_sp_data) / len(staticpressure_sp_data)) out_data = { 'datetime': str(current_time), 'OutdoorAirTemperature': oatemp, 'MixedAirTemperature': None if not matemp else matemp, 'ReturnAirTemperature': None if ratemp is None else ratemp, 'DischargeAirTemperature': None if datemp is None else datemp, 'DischargeAirTemperatureSetPoint': None if datemp_stpt is None else datemp_stpt, 'SupplyFanStatus': None if fanstatus is None else fanstatus, 'SupplyFanSpeed': None if fanspeed is None else fanspeed, 'OutdoorDamper': None if outdoor_damper is None else outdoor_damper, 'CCV': None if ccv is None else ccv, 'HCV': None if hcv is None else hcv, 'OutdoorAirFraction': None if oaf is None else oaf, 'ReturnFanSpeed': None if return_fan_speedcmd is None else return_fan_speedcmd, 'OccupancyMode': None if occupancy is None else occupancy, 'DuctStaticPressure': None if discharge_sp is None else discharge_sp, 'DuctStaticPressureSetPoint': None if staticpressure_sp is None else staticpressure_sp, } result.insert_table_row('AhuEcam', out_data) return result
def run(self, current_time, points): ''' Check algorithm pre-quisites and assemble data set for analysis. ''' device_dict = {} result = Results() topics = self.inp.get_topics() topic = topics[self.hws_temp_name][0] current_time = self.inp.localize_sensor_time(topic, current_time) base_topic = self.inp.get_topics() meta_topics = self.inp.get_topics_meta() unit_dict = {} if len(base_topic[self.oa_temp_name]) > 0: unit_dict[self.oa_temp_name] = meta_topics[self.oa_temp_name][ base_topic[self.oa_temp_name][0]]['unit'] if len(base_topic[self.hws_temp_name]) > 0: unit_dict[self.hws_temp_name] = meta_topics[self.hws_temp_name][ base_topic[self.hws_temp_name][0]]['unit'] if len(base_topic[self.hwr_temp_name]) > 0: unit_dict[self.hwr_temp_name] = meta_topics[self.hwr_temp_name][ base_topic[self.hwr_temp_name][0]]['unit'] if len(base_topic[self.hw_stsp_name]) > 0: unit_dict[self.hw_stsp_name] = meta_topics[self.hw_stsp_name][ base_topic[self.hw_stsp_name][0]]['unit'] for key, value in points.items(): device_dict[key.lower()] = value oatemp_data = [] loop_dp_values = [] loop_dp_stpt_values = [] hw_pump_status_values = [] boiler_status_values = [] hw_pump_vfd_values = [] hw_stsp_values = [] hws_temp_values = [] hwr_temp_values = [] for key, value in device_dict.items(): if key.startswith(self.loop_dp_stpt_name) and value is not None: loop_dp_stpt_values.append(value) elif key.startswith(self.loop_dp_name) and value is not None: loop_dp_values.append(value) elif key.startswith( self.hw_pump_status_name) and value is not None: hw_pump_status_values.append(value) elif key.startswith(self.boiler_status_name) and value is not None: boiler_status_values.append(value) elif key.startswith(self.hw_pump_vfd_name) and value is not None: hw_pump_vfd_values.append(value) elif key.startswith(self.hw_stsp_name) and value is not None: hw_stsp_values.append(value) elif key.startswith(self.hws_temp_name) and value is not None: hws_temp_values.append(value) elif key.startswith(self.hwr_temp_name) and value is not None: hwr_temp_values.append(value) elif (key.startswith(self.oa_temp_name) #OAT and value is not None): oatemp_data.append(value) if 'celcius' or 'kelvin' in unit_dict.values: if self.oa_temp_name in unit_dict: if unit_dict[self.oa_temp_name] == 'celcius': oatemp_data = cu.convertCelciusToFahrenheit(oatemp_data) elif unit_dict[self.oa_temp_name] == 'kelvin': oatemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(oatemp_data)) if self.hw_stsp_name in unit_dict: if unit_dict[self.hw_stsp_name] == 'celcius': hw_stsp_values = cu.convertCelciusToFahrenheit( hw_stsp_values) elif unit_dict[self.hw_stsp_name] == 'kelvin': hw_stsp_values = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(hw_stsp_values)) if self.hw_stsp_name in unit_dict: if unit_dict[self.hws_temp_name] == 'celcius': hws_temp_values = cu.convertCelciusToFahrenheit( hws_temp_values) elif unit_dict[self.hws_temp_name] == 'kelvin': hws_temp_values = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(hws_temp_values)) if self.hwr_temp_name in unit_dict: if unit_dict[self.hwr_temp_name] == 'celcius': hwr_temp_values = cu.convertCelciusToFahrenheit( hwr_temp_values) elif unit_dict[self.hwr_temp_name] == 'kelvin': hwr_temp_values = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(hwr_temp_values)) oatemp = hw_stsp_temp = hws_temp = hwr_temp = None loop_dp = loop_dp_stpt = None hw_pump_status = boiler_status = None hw_pump_vfd = None if oatemp_data: oatemp = (sum(oatemp_data) / len(oatemp_data)) if hw_stsp_values: hw_stsp_temp = (sum(hw_stsp_values) / len(hw_stsp_values)) if hws_temp_values: hws_temp = (sum(hws_temp_values) / len(hws_temp_values)) if hwr_temp_values: hwr_temp = (sum(hwr_temp_values) / len(hwr_temp_values)) if loop_dp_stpt_values: loop_dp_stpt = (sum(loop_dp_stpt_values) / len(loop_dp_stpt_values)) if loop_dp_values: loop_dp = (sum(loop_dp_values) / len(loop_dp_values)) if hw_pump_status_values: hw_pump_status = (sum(hw_pump_status_values) / len(hw_pump_status_values)) if boiler_status_values: boiler_status = (sum(boiler_status_values) / len(boiler_status_values)) if hw_pump_vfd_values: hw_pump_vfd = (sum(hw_pump_vfd_values) / len(hw_pump_vfd_values)) out_data = { 'datetime': str(current_time), } if not oatemp is None: out_data['OutdoorAirTemperature'] = oatemp if not hws_temp is None: out_data['HotWaterSupplyTemperature'] = hws_temp if not hwr_temp is None: out_data['HotWaterReturnTemperature'] = hwr_temp if not hw_stsp_temp is None: out_data['HotWaterTemperatureSetPoint'] = hw_stsp_temp if not loop_dp is None: out_data['LoopDifferentialPressure'] = loop_dp if not loop_dp_stpt is None: out_data['LoopDifferentialPressureSetPoint'] = loop_dp_stpt if not hw_pump_status is None: out_data['PumpStatus'] = hw_pump_status if not boiler_status is None: out_data['BoilerStatus'] = boiler_status if not hw_pump_vfd is None: out_data['HotWaterPumpVfd'] = hw_pump_vfd result.insert_table_row(self.table_name, out_data) return result
def run(self, current_time, points): """ Main run method that is called by the DrivenBaseClass. """ device_dict = {} result = Results() topics = self.inp.get_topics() topic = topics[self.oa_temp_name][0] current_time = self.inp.localize_sensor_time(topic, current_time) base_topic = self.inp.get_topics() meta_topics = self.inp.get_topics_meta() unit_dict = { self.oa_temp_name: meta_topics[self.oa_temp_name][base_topic[self.oa_temp_name][0]] ['unit'] } if len(base_topic[self.ma_temp_name]) > 0: unit_dict[self.ma_temp_name] = meta_topics[self.ma_temp_name][ base_topic[self.ma_temp_name][0]]['unit'] if len(base_topic[self.ra_temp_name]) > 0: unit_dict[self.ra_temp_name] = meta_topics[self.ra_temp_name][ base_topic[self.ra_temp_name][0]]['unit'] if len(base_topic[self.da_temp_name]) > 0: unit_dict[self.da_temp_name] = meta_topics[self.da_temp_name][ base_topic[self.da_temp_name][0]]['unit'] if len(base_topic[self.da_temp_setpoint_name]) > 0: unit_dict[self.da_temp_setpoint_name] = \ meta_topics[self.da_temp_setpoint_name][base_topic[self.da_temp_setpoint_name][0]]['unit'] for key, value in points.items(): device_dict[key.lower()] = value damper_data = [] oatemp_data = [] matemp_data = [] ratemp_data = [] datemp_data = [] datemp_stpt_data = [] ccv_data = [] fan_speedcmd_data = [] fan_status_data = [] hcv_data = [] return_fan_speedcmd_data = [] occ_data = [] discharge_sp_data = [] staticpressure_sp_data = [] for key, value in device_dict.items(): if (key.startswith(self.outdoor_damper_name) #Damper and value is not None): damper_data.append(value) elif (key.startswith(self.oa_temp_name) #OAT and value is not None): oatemp_data.append(value) elif (key.startswith(self.ma_temp_name) #MAT and value is not None): matemp_data.append(value) elif (key.startswith(self.ra_temp_name) #RAT and value is not None): ratemp_data.append(value) elif (key.startswith(self.da_temp_name) #DAT and value is not None): datemp_data.append(value) elif (key.startswith(self.da_temp_setpoint_name) #DAT SetPoint and value is not None): datemp_stpt_data.append(value) elif (key.startswith(self.cc_valve_name) #CoolCoilValvePos and value is not None): ccv_data.append(value) elif (key.startswith(self.hc_valve_name) #HeatCoilValvePos and value is not None): hcv_data.append(value) elif (key.startswith(self.fan_speedcmd_name) #Fan speed and value is not None): fan_speedcmd_data.append(value) elif (key.startswith(self.fan_status_name) #Fan status and value is not None): fan_status_data.append(value) elif (key.startswith( self.returnfan_speedcmd_name) #returnfan_speedcmd_name and value is not None): return_fan_speedcmd_data.append(value) elif (key.startswith(self.occ_name) #Occupancy and value is not None): occ_data.append(value) elif (key.startswith(self.discharge_sp_name) #discharge_sp_data and value is not None): discharge_sp_data.append(value) elif (key.startswith( self.sp_setpoint_name) #staticpressure_sp_data and value is not None): staticpressure_sp_data.append(value) if not oatemp_data: return result if 'celcius' or 'kelvin' in unit_dict.values: if unit_dict[self.oa_temp_name] == 'celcius': oatemp_data = cu.convertCelciusToFahrenheit(oatemp_data) elif unit_dict[self.oa_temp_name] == 'kelvin': oatemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(oatemp_data)) #if self.ma_temp_name in unit_dict: if unit_dict[self.ma_temp_name] == 'celcius': matemp_data = cu.convertCelciusToFahrenheit(matemp_data) elif unit_dict[self.ma_temp_name] == 'kelvin': matemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(matemp_data)) if self.ra_temp_name in unit_dict: if unit_dict[self.ra_temp_name] == 'celcius': ratemp_data = cu.convertCelciusToFahrenheit(ratemp_data) elif unit_dict[self.ra_temp_name] == 'kelvin': ratemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(ratemp_data)) if self.da_temp_name in unit_dict: if unit_dict[self.da_temp_name] == 'celcius': datemp_data = cu.convertCelciusToFahrenheit(datemp_data) elif unit_dict[self.da_temp_name] == 'kelvin': datemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(datemp_data)) if self.da_temp_setpoint_name in unit_dict: if unit_dict[self.da_temp_setpoint_name] == 'celcius': datemp_stpt_data = cu.convertCelciusToFahrenheit( datemp_stpt_data) elif unit_dict[self.da_temp_setpoint_name] == 'kelvin': datemp_stpt_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(datemp_stpt_data)) oatemp = (sum(oatemp_data) / len(oatemp_data)) matemp = (sum(matemp_data) / len(matemp_data)) matemp_data = None ratemp = datemp = datemp_stpt = None fanstatus = fanspeed = outdoor_damper = ccv = hcv = None oaf = None return_fan_speedcmd = None occupancy = None discharge_sp = staticpressure_sp = None if matemp_data: matemp = (sum(matemp_data) / len(matemp_data)) if ratemp_data: ratemp = (sum(ratemp_data) / len(ratemp_data)) if datemp_data: datemp = (sum(datemp_data) / len(datemp_data)) if datemp_stpt_data: datemp_stpt = (sum(datemp_stpt_data) / len(datemp_stpt_data)) if fan_status_data: fanstatus = (sum(fan_status_data) / len(fan_status_data)) if fan_speedcmd_data: fanspeed = (sum(fan_speedcmd_data) / len(fan_speedcmd_data)) if damper_data: outdoor_damper = (sum(damper_data) / len(damper_data)) if ccv_data: ccv = (sum(ccv_data) / len(ccv_data)) if hcv_data: hcv = (sum(hcv_data) / len(hcv_data)) if matemp_data and ratemp_data: denominator = oatemp - ratemp if denominator == 0: oaf = 0 else: oaf = (matemp - ratemp) / denominator if oaf > 1: oaf = 1 elif oaf < 0: oaf = 0 oaf *= 100 if return_fan_speedcmd_data: return_fan_speedcmd = (sum(return_fan_speedcmd_data) / len(return_fan_speedcmd_data)) if occ_data: occupancy = (sum(occ_data) / len(occ_data)) * 100 if discharge_sp_data: discharge_sp = (sum(discharge_sp_data) / len(discharge_sp_data)) if staticpressure_sp_data: staticpressure_sp = (sum(staticpressure_sp_data) / len(staticpressure_sp_data)) out_data = { 'datetime': str(current_time), 'OutdoorAirTemperature': oatemp, 'MixedAirTemperature': None if not matemp else matemp, 'ReturnAirTemperature': None if ratemp is None else ratemp, 'DischargeAirTemperature': None if datemp is None else datemp, 'DischargeAirTemperatureSetPoint': None if datemp_stpt is None else datemp_stpt, 'SupplyFanStatus': None if fanstatus is None else fanstatus, 'SupplyFanSpeed': None if fanspeed is None else fanspeed, 'OutdoorDamper': None if outdoor_damper is None else outdoor_damper, 'CCV': None if ccv is None else ccv, 'HCV': None if hcv is None else hcv, 'OutdoorAirFraction': None if oaf is None else oaf, 'ReturnFanSpeed': None if return_fan_speedcmd is None else return_fan_speedcmd, 'OccupancyMode': None if occupancy is None else occupancy, 'DuctStaticPressure': None if discharge_sp is None else discharge_sp, 'DuctStaticPressureSetPoint': None if staticpressure_sp is None else staticpressure_sp, } result.insert_table_row('AhuEcam', out_data) return result
def run(self, current_time, points): ''' Check algorithm pre-quisites and assemble data set for analysis. ''' device_dict = {} result = Results() topics = self.inp.get_topics() topic = topics[self.hws_temp_name][0] current_time = self.inp.localize_sensor_time(topic, current_time) base_topic = self.inp.get_topics() meta_topics = self.inp.get_topics_meta() unit_dict = {} if len(base_topic[self.oa_temp_name]) > 0: unit_dict[self.oa_temp_name] = meta_topics[self.oa_temp_name][base_topic[self.oa_temp_name][0]]['unit'] if len(base_topic[self.hws_temp_name]) > 0: unit_dict[self.hws_temp_name] = meta_topics[self.hws_temp_name][base_topic[self.hws_temp_name][0]]['unit'] if len(base_topic[self.hwr_temp_name]) > 0: unit_dict[self.hwr_temp_name] = meta_topics[self.hwr_temp_name][base_topic[self.hwr_temp_name][0]]['unit'] if len(base_topic[self.hw_stsp_name]) > 0: unit_dict[self.hw_stsp_name] = meta_topics[self.hw_stsp_name][base_topic[self.hw_stsp_name][0]]['unit'] for key, value in points.items(): device_dict[key.lower()] = value oatemp_data = [] loop_dp_values = [] loop_dp_stpt_values = [] hw_pump_status_values = [] boiler_status_values = [] hw_pump_vfd_values = [] hw_stsp_values = [] hws_temp_values = [] hwr_temp_values = [] for key, value in device_dict.items(): if key.startswith(self.loop_dp_stpt_name) and value is not None: loop_dp_stpt_values.append(value) elif key.startswith(self.loop_dp_name) and value is not None: loop_dp_values.append(value) elif key.startswith(self.hw_pump_status_name) and value is not None: hw_pump_status_values.append(value) elif key.startswith(self.boiler_status_name) and value is not None: boiler_status_values.append(value) elif key.startswith(self.hw_pump_vfd_name) and value is not None: hw_pump_vfd_values.append(value) elif key.startswith(self.hw_stsp_name) and value is not None: hw_stsp_values.append(value) elif key.startswith(self.hws_temp_name) and value is not None: hws_temp_values.append(value) elif key.startswith(self.hwr_temp_name) and value is not None: hwr_temp_values.append(value) elif (key.startswith(self.oa_temp_name) #OAT and value is not None): oatemp_data.append(value) if 'celcius' or 'kelvin' in unit_dict.values: if self.oa_temp_name in unit_dict: if unit_dict[self.oa_temp_name] == 'celcius': oatemp_data = cu.convertCelciusToFahrenheit(oatemp_data) elif unit_dict[self.oa_temp_name] == 'kelvin': oatemp_data = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(oatemp_data)) if self.hw_stsp_name in unit_dict: if unit_dict[self.hw_stsp_name] == 'celcius': hw_stsp_values = cu.convertCelciusToFahrenheit(hw_stsp_values) elif unit_dict[self.hw_stsp_name] == 'kelvin': hw_stsp_values = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(hw_stsp_values)) if self.hw_stsp_name in unit_dict: if unit_dict[self.hws_temp_name] == 'celcius': hws_temp_values = cu.convertCelciusToFahrenheit(hws_temp_values) elif unit_dict[self.hws_temp_name] == 'kelvin': hws_temp_values = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(hws_temp_values)) if self.hwr_temp_name in unit_dict: if unit_dict[self.hwr_temp_name] == 'celcius': hwr_temp_values = cu.convertCelciusToFahrenheit(hwr_temp_values) elif unit_dict[self.hwr_temp_name] == 'kelvin': hwr_temp_values = cu.convertKelvinToCelcius( cu.convertCelciusToFahrenheit(hwr_temp_values)) oatemp = hw_stsp_temp = hws_temp = hwr_temp = None loop_dp = loop_dp_stpt = None hw_pump_status = boiler_status = None hw_pump_vfd = None if oatemp_data: oatemp = (sum(oatemp_data) / len(oatemp_data)) if hw_stsp_values: hw_stsp_temp = (sum(hw_stsp_values) / len(hw_stsp_values)) if hws_temp_values: hws_temp = (sum(hws_temp_values) / len(hws_temp_values)) if hwr_temp_values: hwr_temp = (sum(hwr_temp_values) / len(hwr_temp_values)) if loop_dp_stpt_values: loop_dp_stpt = (sum(loop_dp_stpt_values) / len(loop_dp_stpt_values)) if loop_dp_values: loop_dp = (sum(loop_dp_values) / len(loop_dp_values)) if hw_pump_status_values: hw_pump_status = (sum(hw_pump_status_values) / len(hw_pump_status_values)) if boiler_status_values: boiler_status = (sum(boiler_status_values) / len(boiler_status_values)) if hw_pump_vfd_values: hw_pump_vfd = (sum(hw_pump_vfd_values) / len(hw_pump_vfd_values)) out_data = { 'datetime': str(current_time), } if not oatemp is None: out_data['OutdoorAirTemperature'] = oatemp if not hws_temp is None: out_data['HotWaterSupplyTemperature'] = hws_temp if not hwr_temp is None: out_data['HotWaterReturnTemperature'] = hwr_temp if not hw_stsp_temp is None: out_data['HotWaterTemperatureSetPoint'] = hw_stsp_temp if not loop_dp is None: out_data['LoopDifferentialPressure'] = loop_dp if not loop_dp_stpt is None: out_data['LoopDifferentialPressureSetPoint'] = loop_dp_stpt if not hw_pump_status is None: out_data['PumpStatus'] = hw_pump_status if not boiler_status is None: out_data['BoilerStatus'] = boiler_status if not hw_pump_vfd is None: out_data['HotWaterPumpVfd'] = hw_pump_vfd result.insert_table_row(self.table_name, out_data) return result