SHOW:
|
|
- or go back to the newest paste.
| 1 | import cPickle | |
| 2 | import sqlite3 | |
| 3 | import es | |
| 4 | import os | |
| 5 | ||
| 6 | ||
| 7 | ADDON_PATH = es.getAddonPath('') # <--- Name des Addons hier rein, von dem die DB geladen werden soll
| |
| 8 | ||
| 9 | PICKLE_DB_NAME = '' | |
| 10 | PICKLE_DB_PATH = os.path.join(ADDON_PATH, PICKLE_DB_NAME) | |
| 11 | ||
| 12 | ||
| 13 | SQL_DB_NAME = '' | |
| 14 | SQL_DB_PATH = os.path.join(ADDON_PATH, SQL_DB_NAME) | |
| 15 | ||
| 16 | ||
| 17 | pickle_file = open(PICKLE_DB_PATH, 'rb') | |
| 18 | pickle_data = cPickle.load(pickle_file) | |
| 19 | pickle_file.close() | |
| 20 | ||
| 21 | sql_conn = sqlite3.connect(SQL_DB_PATH) | |
| 22 | sql_conn.text_factory = str | |
| 23 | sql_cur = sql_conn.cursor() | |
| 24 | ||
| 25 | ||
| 26 | sql_cur.execute(""" CREATE TABLE IF NOT EXISTS playerdata (steamid TEXT UNIQUE, name TEXT, counter INT) """)
| |
| 27 | ||
| 28 | ||
| 29 | for x in pickle_data: | |
| 30 | sql_cur.execute(""" INSERT OR IGNORE INTO playerdata (steamid, name, counter) VALUES (?, ?, ?) """, (x, playerdata[x]['name'], playerdata[x]['counter']))
| |
| 31 | ||
| 32 | ||
| 33 | - | sql_cur.commit() |
| 33 | + | sql_conn.commit() |
| 34 | sql_cur.close() |
