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