cPickle to SQL Converter

import cPickle
import sqlite3


PICKLE_DB_PATH = ''


SQL_DB_PATH = ''


pickle_data = cPickle.load(PICKLE_DB_PATH)

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


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


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


sql_cur.commit()
sql_cur.close()