importcopyfrompot_libs.mysql_util.mysql_utilimportMysqlUtilasyncdefmonitor_location_join_by_locations(locations):"""monitor和location关联"""sql="SELECT m.mtid, m.name, m.m_type, l.lid, l.item, l.ad_type " \"FROM monitor m inner join location l on m.mtid = l.mtid " \"WHERE l.lid in %s and m.demolished=0 order by field(l.lid,{})".\format(str(locations).replace("[","").replace("]",""))asyncwithMysqlUtil()asconn:monitor_location_list=awaitconn.fetchall(sql,args=(tuple(locations),))returnmonitor_location_listasyncdefalarm_setting_by_locations(locations):"""根据locations查询alarm_setting"""sql="select lid, threshold from soe_config_record " \"where lid in %s " \"and `etype` in ('overTemp', 'overResidualCurrent')"asyncwithMysqlUtil()asconn:alarm_setting_list=awaitconn.fetchall(sql,args=(tuple(locations),))returnalarm_setting_list