import re
from lxml import etree
import MySQLdb
def XMLPush(datafile,server,dbuser,password,dbname,table)
def quote(text):
return "'" + text + "'"
def doublequote(text):
return '"' + text + '"'
connection = MySQLdb.connectionect (host = server,
user = dbuser,
passwd = password,
db = dbname)
cursor = connection.cursor()
tree = etree.parse(datafile)
root = tree.getroot()
# Parse out data from XML
data = []
for child in root:
datarow = {}
for leaf in child:
datarow[leaf.tag] = leaf.text
