def dealXML(xmlStr): dDb = mysql.connector.connect(host="localhost", user="******", passwd="123456", database="ghddi", auth_plugin='mysql_native_password') dCursor = dDb.cursor() domTree = xml.dom.minidom.parseString(xmlStr) collection = domTree.documentElement nodeList = collection.getElementsByTagName(TARGET_NAME) insertList = [] for node in nodeList: tId = node.getElementsByTagName(ID_KEY)[0].childNodes[0].nodeValue if tId == None: continue nodeList2 = node.getElementsByTagName('ENEM01') for node2 in nodeList2: pa = node2.getElementsByTagName( 'ENEM.PA')[0].childNodes[0].nodeValue pbList = node2.getElementsByTagName('ENEM.PB') if len(pbList) > 0: pb = pbList[0].childNodes[0].nodeValue else: pb = None insertList.append([tId, pa, pb]) dCursor.executemany(INSERT_INTO_TABLE_ENEM_P, insertList) dDb.commit() dCursor.closeSession() dDb.closeSession() insertTM.setValue(TARGET_NAME, ID_KEY, INSERT_INTO_TABLE_ENEM, KEY_NAME) insertTM.dealXML(xmlStr)
def dealXML(xmlStr): insertTM.setValue(TARGET_NAME, ID_KEY, INSERT_INTO_TABLE_EM, KEY_NAME) insertTM.dealXML(xmlStr)
def dealXML(xmlStr): insertTM.setValue(TARGET_NAME, ID_KEY, INSERT_QUAN, KEY_NAME) insertTM.dealXML(xmlStr)