# -*- coding: utf-8 -*-

from xml.dom import minidom

prefix = "icq_"
dbHost = "127.0.0.1"
dbUser = "root"
dbPass = "password"
dbName = "transport"

dom = minidom.parse('test.xml')

uin = dom.getElementsByTagName('uin')[0].childNodes[0].data
password = dom.getElementsByTagName('password')[0].childNodes[0].data
jid = dom.getElementsByTagName('password')[0].childNodes[0].data

connection = MySQLdb.connect(dbHost, dbUser, dbPass, dbName)
c = connection.cursor()

c.execute("""INSERT INTO %s_users (jid, uin, password, language, encoding, last_login, vip, online)
        VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')""", (prefix, jid, uin, password, 'pl', 'utf8', '2011-06-16 21:02:38', '0', '1') )

c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('enable_avatars', '4', '1');""")
c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('enable_chatstate', '4', '1');""")
c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('enable_notify_email', '4', '0');""")
c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('enable_transport', '4', '1');""")
c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('first_synchronization_done', '4', '1');""")
c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('reject_authorizations', '4', '0');""")
c.execute("""INSERT INTO %s_users_settings (var, type, value) VALUES ('save_files_on_server', '4', '0');""")

for node in dom.getElementsByTagName('contact'):
    c.execute("SELECT id FROM %_users WHERE jid = '%s';" % jid)
    user_id = c.fetchone()[0]

    c.execute("""INSERT INTO %s_buddies (user_id, uin, subscription, nickname, groups, flags) VALUES ('%s', '%s', '%s', '%s', 'Buddies', '0');"""
                user_id, node.attributes["uin"].value, node.attributes["subscribe"].value, node.attributes["uin"].value)