import sys
import mysql.connector

if len(sys.argv) < 3:
    print ("Usage: python upload.py <docid> <xml-file>")
    exit()

docid = sys.argv[1]
xmlfile = sys.argv[2]

cnx = mysql.connector.connect(user='alice', password='tiger', host='sql.cs.oberlin.edu', database='xml', charset='utf8', auth_plugin='mysql_native_password')
cursor = cnx.cursor(prepared=True)

docid = int(docid)
f = open(xmlfile,"r")
xmldata = f.read()

query = ("insert into xml.xml values(?,?)")
cursor.execute(query, (docid,xmldata))

# query = ("select xmldoc from xml.xml where docid=?")
query = ("select docid from xml.xml")
cursor.execute(query)
for (doc) in cursor:
    print(doc)

cursor.close()
cnx.commit()
cnx.close()