def init_electricity_dashboard(mysql):
"""
Parameters:
mysql: mysql connection to EMS DB
"""
""""to initialize the electricity_dashboard table for each site"""
field_list=['alarm_color','alarm_details','alarm_logs','deltaMinutes','efficiencyTable','lastTime','loadTable','PUETable','realTimeCO2','realTimeEfficiency','realTimeLoad','realTimePUE','siteAbsoluteLoad','status_flag']
site_id_sql="SELECT id FROM emsdb.site;"
site_id_datas=insertDBdata.get_data(mysql, site_id_sql)
if site_id_datas:
site_id_list=[4,10]
for site_id_data in site_id_datas:
#site_id=site_id_data[0]
site_id_list.append(site_id_data[0])
site_id_list=[4,10]
site_dashboard_data_list=[]
print 'site_id_list=',site_id_list
site_id_list=[]
for site_id in site_id_list:
for field in field_list:
site_dashboard_data_list.append([site_id, field])
sql_insert_dashbord_field="insert ignore into emsdb.electricity_dashboard (site_id,field) values(%s,'%s');"
insertDBdata.insert_data(mysql, sql_insert_dashbord_field, site_dashboard_data_list)
else:
pass
return
def eventInsert(mysql,generate_event_data):
"""
Parameters:
mysql: mysql connection to EMS DB
generate_event_data: list type, event log data from agent/client
Return values:
"""
event_insert_sql="insert ignore into emsdb.event_log (date_time,event_id,info) values(%s,%s,%s);"
insertDBdata.insert_data(mysql, event_insert_sql, generate_event_data)
return
def electricityInsert(mysql,electricity_data):
"""
Parameters:
mysql: mysql connection to EMS DB
electricity_data: list type, electricity data from agent/client
Return values:
"""
#print 'Received data length:', len(dbdata),type(dbdata)
electricity_sql = "INSERT IGNORE INTO emsdb.electricity (date_time,measurement_id,value) values(%s,%s,%s);"
#listdata = json.loads(dbdata)
insertDBdata.insert_data(mysql, electricity_sql, electricity_data) #insert data to electricity
return
