import cPickle
import sqlite3
import es
import os


ADDON_PATH = es.getAddonPath('') # <--- Name des Addons hier rein, von dem die DB geladen werden soll

PICKLE_DB_NAME = ''
PICKLE_DB_PATH = os.path.join(ADDON_PATH, PICKLE_DB_NAME)


SQL_DB_NAME = ''
SQL_DB_PATH = os.path.join(ADDON_PATH, SQL_DB_NAME)


pickle_file = open(PICKLE_DB_PATH, 'wb')
pickle_data = cPickle.load(pickle_file)
pickle_file.close()

sql_conn = sqlite3.connect(SQL_DB_PATH)
sql_conn.text_factory = str
sql_cur = sql_conn.cursor()


sql_cur.execute(""" CREATE TABLE IF NOT EXISTS playerdata (steamid TEXT UNIQUE, name TEXT, counter INT) """)


for x in pickle_data:
    sql_cur.execute(""" INSERT OR IGNORE INTO playerdata (steamid, name, counter) VALUES (?, ?, ?) """, (x, playerdata[x]['name'], playerdata[x]['counter']))


sql_cur.commit()
sql_cur.close()