def bt2_units(): base_dir=GF.get_configxml('DProvXML', 1) deprov_file=base_dir+'/'+deprovxml try: deprov_fileobj=open(deprov_file, "r") except Exception as error: GF.print_error("Reading deprovision file", error, 1) else: bt2Units=list() deprov_xmlobj=GF.open_configxml(deprov_fileobj) deprov_fileobj.close() base_node=deprov_xmlobj.getroot() base_locaddr=int(base_node.attrib.get('addrBase')) for node in deprov_xmlobj.findall('.//xcoders//HashMap'): resource_id=node.find('.//NA').attrib.get('value') xcode_node=node.find('.//XCodeDevCfgT') macaddr_node=xcode_node.findall('.//macAddr//MacAddressT//List//NA') loc_addr=int(xcode_node.attrib.get('locAddr')) xcode_mac='' for mac in macaddr_node: val=int(mac.attrib.get('value')) hex_val="%02X" % int(hex(val&0xff)[2:], 16) xcode_mac=xcode_mac+hex_val macaddr=GF.prettify(xcode_mac) ip=GF.int2ip(base_locaddr+loc_addr) return_result=GF.formdhcp_host(resource_id, macaddr, ip) bt2Units.append(return_result) GF.writeDHCP_BT2_Units(bt2Units)
def update_vixs(conn): GF.writeDHCP_BT2_Units(vixs_dhcp) cursor=conn.cursor() query="INSERT INTO vixs_details(boardMAC, vixsMAC, vixsIP, resourceId) VALUES(%s,%s,%s,%s)" for board in boardvixs_map: for vixs in boardvixs_map[board]: cursor.execute(query, (board, vixs, vixsip_map[vixs], vixsrid_map[vixs])) conn.commit()