import sys
import xml.dom.minidom as minidom

fields = "comma, seperated, taglist, from, xml, file"
                       #  Comma seperated field list - same in SQL + XML
tablename = "products" #  The database table to populate
recordset = "record"   #  The tag containing each record.

def main(args):
    f = open(args[1])
    doc = minidom.parseString(f.read())
    f.close()
    for i in doc.getElementsByTagName(recordset):
        vars = []
        vals = []
        for j in fields.split(", "):
            for k in i.getElementsByTagName(j):
                if (k and k.firstChild):
                     vars.append(j)
                     vals.append(k.firstChild.nodeValue.replace("'", "\\'"))
        sqlstring = "INSERT INTO %s (%s) VALUES ('%s');" % (
                      tablename, ", ".join(vars), "', '".join(vals))
        print sqlstring.encode('utf-8')

if __name__ == "__main__":
    if len(sys.argv) < 1:
        print "Usage: %s <filename>"
    else:
        main(sys.argv)